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
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
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
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….