PK09869: QM OFFLOAD PROCESS MAY ISSUE MESSAGES DSNU338I AND DSNU017I - FOLLOWED BY S04E ABEND IN OFFLOAD - REASON X'00E40323'.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Offload Job may fail with ABEND=S04E U0000 REASON=00E40323
  accompanied by both the following messages:
  DSNU338I -T4 DSNURWBF - INVALID COLUMN SPECIFICATION FOR
  OBJECT_NAME
  DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION
  ABENDED, REASON=X'00E40323'
  Code has changed to correctly account for SQL text of unusual
  length.
  ******************************************
  ADDITIONALLY FIXED THIS APAR
  ******************************************
  Samplib member CQM@LDB2 has been modified to include DDs SYSDISC
  and SYSERR so that the load job can continue processing in the
  instance of encountering duplicate load records - and as an aid
  to diagnostics.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Offload Job may fail with ABEND=S04E    *
  *                      U0000 REASON=00E40323 accompanied by    *
  *                      both the following messages:            *
  *                      DSNU338I -T4 DSNURWBF - INVALID COLUMN  *
  *                      SPECIFICATION FOR OBJECT_NAME           *
  *                      DSNU017I DSNUGBAC - UTILITY DATA BASE   *
  *                      SERVICES MEMORY EXECUTION ABENDED,      *
  *                      REASON=X'00E40323'                      *
  *                      Code has changed to correctly account   *
  *                      for SQL text of unusual length.         *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK08590

Modules/Macros

•    CQM@ITXT CQM@LDB2 CQM@WDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UK08590

     UP05/11/08 P F511

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.