Will Copying DSParams from Lower version to Higher version cause issues?

The DSParams file contains the values for all the parameters and environment variables of a DataStage Project. The structure of this file changes in different releases of DataStage. As result, copying a DSParams from a different release is not a valid procedure and it should never be attempted. Doing this will cause unexpected behavior in DataStage, including abnormal terminations. Depending … Read more >>

Job fails to abort even though warning threshold has reached

In Designer/Director, when I was running a job with more warnings, the abort was not raised even though the warning threshold was set to 50; The job status in Director sometimes shows Abort and other times, it shows Finished (see log). I was pretty much confused with job status and started debugging

the root cause of the problem can be … Read more >>

Failed to load the Java Virtual Machine when trying to launch DataStage designer

When I was trying to log in to either Designer or Director or Admin client after a fresh DataStage client install on a Windows 7 machine; I encountered failed to load Java Virtual Machine. The most common cause of this problem is a failure of the Java Virtual Machine to allocate enough memory. Check the memory settings in the file:… Read more >>

DataStage Errors while trying to write records to DB2 Connector Stage

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

DB2 function SQLFetch failed:  SQLSTATE = HY000: Native Error Code = -1,042: Msg = [IBM][CLI Driver][DB2/AIX64] SQL1042C  An unexpected system


DataStage Errors while viewing data using View Data on Oracle Connector Stage

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

An Exception occurred while trying to receive the response form the handler: An exception was received from the handler: Error loading connector library libccora10g.so. libcIntsh.so.10.1: cannot open shared object filr: No