PQ91338: CQM6102E SCRATCH FAILED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In some cases the CQM started task may issue msg:
  CQM6102E SCRATCH FAILED FOR xxxxxxxxxxxxxxxxx SCRATCH STATUS
  CODE=08 R0=04190401"
  
  The message may occur at started task startup of at the start of
  interval processing, when CQM atempts to issue a SCRATCH against
  the
  expired CQM backstore VSAM datasets.
  
  This symptom is seen in customer situations where RACF is not
  the security package being used.
  
  Code has been added to call IDCAMS to delete QM's expired
  backstore datasets in lieu of invoking the SCRATCH macro.
  Hopefully this will alleviate the error conditions QM is
  encountering issuing SCRATCH. It has been proven in the past
  that IDCAMS could delete expired VSAM dataset whereas the
  SCRATCH macro failed.
  

Local fix

•    Delete the data sets using IDCAMS or TSO Delete.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: In some cases the CQM started task may  *
  *                      issue msg:                              *
  *                      CQM6102E SCRATCH FAILED FOR             *
  *                      xxxxxxxxxxxxxxxxx SCRATCH STATUS        *
  *                      CODE=08 R0=04190401"                    *
  *                                                              *
  *                      The message may occur at started task   *
  *                      startup of at the start of interval     *
  *                      processing, when CQM atempts to issue   *
  *                      a SCRATCH against the expired CQM       *
  *                      backstore VSAM datasets.                *
  *                                                              *
  *                      This symptom is seen in customer        *
  *                      situations where RACF is not the        *
  *                      security package being used.            *
  *                                                              *
  *                      Code has been added to call IDCAMS to   *
  *                      delete QM's expired backstore datasets  *
  *                      in lieu of invoking the SCRATCH macro.  *
  *                      Hopefully this will alleviate the error *
  *                      conditions QM is encountering issuing   *
  *                      SCRATCH. It has been proven in the past *
  *                      that IDCAMS could delete expired VSAM   *
  *                      dataset whereas the SCRATCH macro       *
  *                      failed.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

Modules/Macros

•    CQMCAE
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R210 PSY UQ93292

     UP04/10/13 P F410

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.