Post of the day
DataStage

DataStage DB2 Connector error while changing the instance na...

I am recently migrating one of the job to 9.1.2 and ended up with below error DB2 Connector stage was created originally with a particular DB2 instance name (eg. Instance 1 DB) and then one goes back into the DB2 Connector to change the DB2 Instance name to a different Instance name (eg. Instance 2…

DataStage

DataStage Errors while trying to write records to DB2 Connec...

One more annoying error that I faced yesterday when I tried to Load data on to a DB2 database It took lot of hours to find the root cause of the problem even though every thing looks fine in Job This problem occurs when DB2 heap size is set to too low on DB Side…

BI & DW

DataStage Errors while viewing data using View Data on Oracl...

Most of the times the following error occurs for “view data” and “test connection” actions in Connector stage properties, even though the job itself runs successfully without any warnings Root cause of this error is  Node agents were not started after adding the oracle environment variables to the dsenv file If the jobs are unable…

Information Server

How to Enable Connector Debugging levels in DataStage

I have recently faced couple of errors and I tried to debug with Standard errors and I am not able to debug much and fix the errors while developing the jobs Here are the some steps to enable Debugging in Connector Stages in DataStage Designer (However these variables cannot be used in PROD without a…