Post of the day
DataStage

DataStage job with MQ Connector aborts with error code 2058 ...

Apart from my earlier post, I have faced one more error while developing code using real-time stages DataStage job with MQ Plugin fails with error code 2058 – Failed to connect to Queue Manager, but jobs utilising the MQ Connector succeed. The DS job aborts with “Fatal Error: Fatal: Failed to connect to queue manager….

DataStage

MQ Connector fails with 2053 Error(Fail to write messages) :...

Are you using a real-time stages to push few XML’s to downstream systems such as MQ connector? Recently I have faced a typical error wherein DataStage job fails with 2053 error most of the times(until the queue is cleared) Job log contains error message similar to this: MQ_Connect_ETL,0: MQPUT call executed with completion code 2…

BI & DW

DataStage job aborts with CLI0106E [Connection is closed] er...

Most of the DB2 Target Load DataStage jobs aborted with returning error CLI0106E (Connection is closed) when connecting to a database or CLI0106E Connection is closed. SQLSTATE = 08003. SQLTransact: Error committing transaction. Probable error would be due to “The connection specified by the connection handle is no longer active.” Resolution for error It means…

DataStage

DataSets | Orchadmin Command Explained

Orchadmin is a command line utility provided by DataStage to research on data sets. The general callable format is : $orchadmin [options] [descriptor file] 1. Before using orchadmin, you should make sure that either the working directory or the $APT_ORCHHOME/etc  contains the file “config.apt” OR The environment variable $APT_CONFIG_FILE  should be defined for your session….