This page summarises the Asset Queries currently shipping with S2PX. Asset Queries are similar to MettleCI Compliance Queries in that they parse your DataStage Jobs' source code looking for patterns (or more commonly anti-patterns) tat you should know about. In the case of S2PX this capability is used to identify aspects of your Server Jobs' designs that could have some impact on S2PX’s ability to convert your Server Job to a Parallel equivalent which 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 |
|---|---|
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). |