JR32813: DB2 ERROR MESSAGES ARE SUPPRESSED UNEXPECTEDLY.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• Jobs with DB2 Enterprise stage fails intermittently while DB2
  online backup, without any helpful messages for trouble
  shooting. The customer uses message handler to suppress warning
  message "Due to DB2 defect for array execetion in PDF system,
  commitsize option is ignored", but this message has ID of
  TNDB000000 and many other Fatal / Warning messages from DB2
  Enterprise stage are covered by this ID and suppressed
  unexpectedly.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  The problem is seen when using DB2 EE Upsert in DS 7.5.2
  ****************************************************************
  PROBLEM DESCRIPTION:
  Due to a resource bundle issue the message id for multiple error
  messages thrown by DB2 EE is showing up as TNDB0000. So when a
  message handler for TNDB0000 is used all these error messages
  are incorrectly suppressed.
  ****************************************************************
  RECOMMENDATION:
  Install the patch patch_JR21813
  ****************************************************************
  

Problem conclusion

• A fix was made to assign proper message id to the error
  messages.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• DB2EE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R752 PSN

     UP