IBM Support

A mechanism to suppress individual warnings from the DataStage DB2 Enterprise stage in a server job.

Technote (FAQ)


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.

Document information

More support for: InfoSphere DataStage

Software version: 8.7, 9.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1622687

Modified date: 27 March 2013