Document toolboxDocument toolbox

S2PX Analysis Asset Queries

This page summarises the Asset Queries currently shipping with S2PX. Asset Queries are similar to MettleCI Compliance Queries in that they parse your DataStage Server Jobs' designs to identify design patterns that could impede S2PX’s ability to convert your Server Job to a Parallel equivalent that behaves identically.

The asset queries in S2PX are embedded within the MettleCI s2px analysis CLI command which is used for the pre-conversion identification of aspects of your DataStage Server jobs which will affect the conversion effort. The Asset Queries are classified below by the kind of information they produce and the actions they might prompt:

Query Classification

Description

Query Classification

Description

Advisory

Queries identifying Jobs with issues you may want to be informed of, but about which no action is either possible or required.

Coverage

Utility queries, useful for effort estimation, which describe the components of each Server Job which are not converted by S2PX.

Custom Functions

Queries identifying Jobs that don't contain custom Server routines and so potentially offering a quicker path to a Unit Testing result of their S2PX-generated Parallel equivalents.

Decomposition

Queries describing how many Parallel artefacts or Job Sequences your Server Job will be decomposed into as part of conversion. See Job Decomposition.

Functions

Queries identifying Jobs with issues relating to the use of functions.

Known Issues

Queries identifying where S2PX will unavoidably generate a solution susceptible to a defect in the DataStage Parallel environment.

One Time Tasks

Queries describing the conversion tasks that require remediation activity per artefact, rather than a remediation for each reference to that artefact. For example, a Custom Routine needs to be converted once, regardless of the number of times it is referenced within Jobs.

Remediation

Queries describing the conversion tasks that unavoidably require a human to make a DataStage design decision, and implement the change manually within one or more generated artefact(s). 


S2PX Asset Queries

 

© 2015-2024 Data Migrators Pty Ltd.