How do I turn on debugging information for the DataStage Connector (e.g., DB2, Oracle, ODBC, etc)?

Answer

To turn on debugging information for the DataStage Connector (e.g., DB2, Oracle, ODBC, etc), the environment variable CC_MSG_LEVEL should be set to 1 or 2.


Setting CC_MSG_LEVEL to 2 produces debugging output.
Setting CC_MSG_LEVEL to 1 produces tracing output.

To set the CC_MSG_LEVEL environment variable in the DataStage Designer, follow the steps below:

In the DataStage Designer,

1. Right-click on the job and select Properties.
2. On the Job Properties dialog, select the Parameters tab.
3. Click the Add Environment Variable button.
4. On the Choose environment variable dialog, click on the (New...) text at the top of the dialog.
5. In the Create new environment variable dialog, enter "CC_MSG_LEVEL" into both the Name and Prompt fields, and click OK.
6. In the Choose environment variable dialog, under the User Defined section, click on the newly created CC_MSG_LEVEL text. (This should add a row for CC_MSG_LEVEL to the table on the Parameters tab.)
7. On the Job Properties dialog click OK.
8. Compile the job
9. Run the job from the Director and, when prompted, enter "1" for the value of CC_MSG_LEVEL.