IBM Support

IBM InfoSphere DataStage job fails with Abnormal termination of stage error

Troubleshooting


Problem

DataStage Job Error "Abnormal termination of stage" for transformer stage generated after increase in data volume (700K) being processed

Symptom

Increase of DataStage job processing record and/or data volume. One case showed on UNIX platform cause database ODBC plugin to abort abnormally.

Resolving The Problem

On AIX with DataStage 7.5.x, per process heap space can be increased by performing the following:

  1. Changing DSEngine shared memory offsets in $DSHOME/uvconfig
  2. Setting the LDR_CNTRL environment variable to MAXDATA=0x30000000 in either $DSHOME/dsenv or at the project level using the Administrator.

    Other values that may help resolve issue depending on the results of testing:

    DMEMOFF 0x90000000
    PMEMOFF 0xa0000000
    CMEMOFF 0xb0000000
    NMEMOFF 0xc0000000

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"}],"Version":"7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21469169