Open (non-IBM) Java v1.8

S2PX is implemented as a MettleCI Command Line plugin and so is subject to the prerequisites of that tool. MettleCI CLI components cannot use the IBM-specific version of Java typically shipped with DataStage due to technical limitations with that version. See the MettleCI CLI documentation for more details.

Relevant MettleCI documentation

IBM DataStage Fix Pack

v11.7 : 11.7.1.4 SP1

v11.5: TBC by IBM

S2PX requires the installation of a DataStage Fix pack in your existing DataStage environment to provide a number of additional capabilities requires for it to operate.

• New S2PX datatype conversion functions which are required to convert between Server datatypes and native Parallel datatypes.

• New DataStage Parallel functions equivalent to previously Server-only functions. Note that any Server functions not implemented in IBM’s Fix Pack will be reported in the relevant Asset Queries.

IBM Support: Fix Central

MettleCI Command Line

Version 128 or later. e.g.

command-shell-1.1-128-dist.zip

The MettleCI Command Line Interface is used as the primary interface into S2PX functionality

Passport Advantage Online for Customers (ibm.com)

S2PX plugin (for MettleCI Command Line)

Version 293 or later

dm-server-px-converter-0.1-293.jar

The S2PX plugin for the MettleCI Command Line Interface.

Passport Advantage Online for Customers (ibm.com)

C++ Compiler

This is required as part of a standard DataStage Parallel Engine installation, however we draw attention to it as a C/C++ Compiler is required when you need to replace a custom Server function currently written in DataStage BASIC with a replacement Parallel function. Instances on these will be identified by S2PX Asset Queries.

Setting up a C++ compiler - IBM Documentation

DRS-compatible Storage Platform

Note that this is only required if your Server Jobs make use of the Hashed File stage. Hashed Files will be replaced with a DRS Connector which will require, at a minimum…

• One or more instances of a supported DRS database

• One or more user accounts with relevant permissions to those database instances

• Appropriate drivers installed on your DataStage Engine(s) necessary to access those database instances

DRS Connector stage - IBM Documentation

Asset Queries

Collection of .grm query files (analogous to Compliance Rules) which can be used to provide pre-conversion insight into how the S2PX tool will handle the conversion of your Server Jobs to Parallel.

Asset Query Reference