PM70811: CQM8023E STATEMENT TEXT LONGER THAN 2 MB ISSUED FOR SPANNED SQL TEXT RECORDS. BATCH DB2 OFFLOAD JOB ABENDS AND ENDS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CQM8023E STATEMENT TEXT LONGER THAN 2 MB issued for spanned SQL
  TEXT records.  Batch DB2 offload job abends and ends.
  

Local fix

• Please provide the METRDATA and TEXTDATA output files from the
  CQM@WDB2 step and contact IBM Techincal Support for assistance
  in identifying the bad record and excluding data collection for
  the workload in the monitoring profile.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: CQM8023E STATEMENT TEXT LONGER THAN     *
  *                      2 MB issued for spanned SQL TEXT        *
  *                      records.  Batch DB2 offload job         *
  *                      abends and ends.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Apply the PTF.
  

Problem conclusion

• Apply the PTF
  

Temporary fix

Comments

• ž**** PE13/01/10 PTF IN ERROR. SEE APAR PM77044  FOR DESCRIPTION
  

APAR Information

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

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

  UK83673

Modules/Macros

• CQM@ITXT CQM@WDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R310 PSY UK83673

     UP12/12/02 P F211

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.