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

Technote (FAQ)


Question

How can I suppress individual warnings in a DataStage server job from the DB2 Enterprise stage, as implied by APAR JR37364?

Answer

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:

DSTAGE-DB2CLI-0108
DSTAGE-DB2CLI-0110
...

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.

Rate this page:

(0 users)Average rating

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:

2013-03-27

Translate my page

Machine Translation

Content navigation