PM49110: MESSAGE CQM155E - ERROR OPENING SQLCD BACKSTORE DATA SET, CQM2602E ABENDSA03 IN CQM@WDB2.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Message 'CQM155E - error opening dsname' may be issued when
  viewing SQLCODES from prior intervals in the ISPF interface.
  Message 'CQM2602E OPEN FAILED FOR VSAM DATASET dsname' may be
  issued when running the CQM@LDB2 offload sample job.
  
  ABEND=SA03 U0000 REASON=00000000 507 may occur when running the
  CQM@LDB2 offload sample job.
  Changes made in PTF UK68783 (APAR PK78911) can cause the
  Negative SQLCODES files for intervals created prior to applying
  PTF UK68783 (APAR PK78911) to be  incompatible with the ISPF
  interface and offload process.
  

Local fix

• 1) RESTORE PTF UK68783, then run the offload process.
  2) Remove the 'SQLCODES' option from the input DATA for program
    CQM@WDB2 in the CQM@LDB2 job.  If this local fix is used, the
    SQLCODES data will not be available in the offload tables.
  3) Do not view the SQLCODES or offload the SQLCODES for
     intervals prior to applying UK68783.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Message 'CQM155E - error opening        *
  *                      dsname' may be issued when              *
  *                      viewing SQLCODES from prior intervals   *
  *                      in the ISPF interface. Message          *
  *                      'CQM2602E OPEN FAILED FOR VSAM DATASET  *
  *                      dsname' may be issued when running the  *
  *                      CQM@LDB2 offload sample job. ABEND=SA03 *
  *                      U0000 REASON=00000000 507 may occur     *
  *                      when running the CQM@LDB2 offload       *
  *                      sample job. Changes made in PTF         *
  *                      UK68783 (APAR PK78911) can cause the    *
  *                      Negative SQLCODES files for intervals   *
  *                      created prior to applying PTF UK68783   *
  *                      (APAR PK78911) to be  incompatible      *
  *                      with the ISPF interface and offload     *
  *                      process.                                *
  ****************************************************************
  * 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:

  UK73089

Modules/Macros

•    CQM$SQCI CQM#QAPI CQM#QAPX CQM@WDB2
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R230 PSY UK73089

     UP11/10/26 P F110

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.