Server to Parallel Conversion

• What is S2PX?

  • Server to Parallel Migration: Read This First

• S2PX Architecture and Workflow

  • Design Conversion Approach
  • Data Type Inference
  • Server Job Translation

• S2PX Conversion Notes

  • Converting jobs with Job Control
  • Data Type Conversions
  • Differences between Server and Parallel VarChar
  • DataStage Macros
  • Dynamic Arrays
  • + 2 more pages

• Parallel Job Structural Differences

  • Introducing Parallel Job Structural Differences
  • Job Decomposition
  • Stage Decomposition
  • Replicating Server Job designs using containers
  • Parallel Job Naming
  • + 4 more pages

• Stage Type Conversions

  • Aggregator Stage
  • Complex Flat File Stage
  • Db2 Connector Stage
  • DRS Connector Stage
  • Folder Stage
  • + 23 more pages

• Preparing to use S2PX

  • S2PX Prerequisites
  • Installing the S2PX tools
  • Using the S2PX Command Line

• Running S2PX Analysis

  • Creating Server ISX Export Files for Analysis
  • Executing S2PX Analysis
  • The S2PX Analysis Excel Spreadsheet

• Running S2PX Conversion

  • The S2PX configuration file
  • Generating Parallel Function Definitions
  • Creating Server DSX Export Files for Conversion
  • Executing S2PX Conversion
  • Conversion Logging

• Frequently Asked Questions

  • Can S2PX automatically remove unsupported characters from column names?
  • Can the S2PX Analysis command produce a single output for multiple ISX files?
  • Do we need a dedicated server to run S2PX?
  • Do we need to export our DataStage assets in a certain order?
  • Do we need to upgrade MettleCI to use S2PX?
  • + 17 more pages

• Troubleshooting

  • Parallel Char function fails to convert numeric values greater than 127
  • S2PX produces java.lang.OutOfMemoryError
  • NullPointerException when converting MettleCI Unit Test Specifications
  • Unable to find executable ‘dsadm.exe’
  • Parallel Job failed with APT_CombineOperatorController,0: FatalError: Null value on the accessor interfacing to field "column"
  • + 1 more pages

• Reference

  • Sample config.yml file
  • Creating the HASH_DICTIONARY Table
  • S2PX Analysis Asset Queries
  • S2PX Error Reference
  • Unofficial Support for running S2PX on macOS

• S2PX Release History

  • Server-to-Parallel - S2PX Release v1.0
  • Server-to-Parallel - S2PX Release v1.1
  • Server-to-Parallel - S2PX Release v1.2
  • Server-to-Parallel - S2PX Release v1.3
  • Server-to-Parallel - S2PX Release v2.0