PQ94842: CQM R210 MSGCQM2604E VSAM LOGIC ERROR, ABEND U2604 IN CQMMEXCW WITH LONG VARCHAR HOST VARIABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a LONG VARCHAR data type is used as a host variable the
  Query Monitor data collector may fail with an ABEND U2604,
  and message
  
  CQM2604E VSAM LOGIC ERROR VSAMRC=X'08' VSAMRS=X'006C'
  CQMMEXCW(03ABE)
  
  The handling of collection of host variable images has been
  changed to address this issue.
  

Local fix

• Increasing the space allocation for all the VSAM backstore
  datasets used by the Query Monitor  instance may provide
  temporary relief
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a LONG VARCHAR data type is used as  *
  *                      a host variable the Query Monitor data  *
  *                      collector may fail with an ABEND U2604, *
  *                      and message                             *
  *                                                              *
  *                      CQM2604E VSAM LOGIC ERROR VSAMRC=X'08'  *
  *                      VSAMRS=X'006C' CQMMEXCW(03ABE)          *
  *                                                              *
  *                      The handling of collection of host      *
  *                      variable images has been changed to     *
  *                      address this issue.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to address this issue.
  

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:

Modules/Macros

•    CQM164I
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UQ95223

     UP04/12/09 P F412

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.