A mechanism to suppress individual warnings from the DataStage DB2 Enterprise stage in a server job.
How can I suppress individual warnings in a DataStage server job from the DB2 Enterprise stage, as implied by APAR JR37364?
It is possible to suppress all warnings by setting the environment variable DS_NO_DB2CLI_WARNINGS, however this may not be the desired behavior.
The changes described in APAR JR37364 effectively allow a message handler-like mechanism to be used to suppress specific warnings from the DB2 EE stage. These changes are included in Information Server DataStage 8.7 and beyond, or can be added as a patch to earlier versions.
To take advantage of these changes, on the system hosting the DataStage engine, first create a plain text file with a list of warning messages to suppress, such as this:
There is a hard limit of 25 messages which can be listed in the file; if more than 25 need to be suppressed, then DS_NO_DB2CLI_WARNINGS will need to be used to suppress all warning messages from DB2.
Once the file is created, set environment variable DSDB2_MESSAGE_HANDLER_FILE to the full path and file name of the text file containing the list of messages to suppress.