PI84055: CQM V3.2 PROFILE(CQMPROFS) AND INTERVAL(CQMINTER) DATASETS CAN BE CORRUPTED IF ACCESSED FROM CQM V3.3

IBM Db2 Query Monitor for z/OS CAE Browser Client download
Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CQM V3.2 PROFILE (CQMPROFS) and INTERVAL (CQMINTER) data sets
  can be corrupted if accessed from CQM V3.3, resulting in message
  CQM2604E and possible SVC dump may be generated.
  Corruption can also occur if the CQMPROFS and CQMINTER data sets
  are reused when upgrading from CQM V3.2 to V3.3 and then
  attempting to fallback to V3.2, or if the CQMPROFS dataset is
  used simultaneously by both V3.2 and V3.3 CQM subsystems.
  Once they are accessed or used by CQM V3.3, the CQMPROFS and
  CQMINTER data sets are no longer compatible with CQM V3.2.
  Example error messages for the Profile data set (CQMPROFS):
  CQM2604E VSAM LOGIC ERROR VSAMRC=X'08' VSAMRS=X'002C'
  CQM#IVSM(05D36)
  CQM3301E LOAD FAILED FOR PROFILE profile ON ssid
  CQM3304E PROFILE CHANGE FAILED FOR ssid
  Example error messages for the Interval data set (CQMINTER):
  CQM2604E VSAM LOGIC ERROR VSAMRC=X'08' VSAMRS=X'002C'
  CQM#UINX(01026)
  IEA794I SVC DUMP HAS CAPTURED:  974
  DUMPID=010 REQUESTED BY JOB (cqmproc  )
  DUMP TITLE=DB2 QUERY MONITOR #DRVR SUBTASK ABEND
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Query Monitor z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: CQM V3.2 PROFILE (CQMPROFS) and         *
  *                      INTERVAL (CQMINTER) data sets can be    *
  *                      corrupted if accessed from CQM V3.3,    *
  *                      resulting in message CQM2604E and       *
  *                      possible SVC dump may be generated.     *
  *                      Corruption can also occur if the        *
  *                      CQMPROFS and CQMINTER data sets         *
  *                      are reused when upgrading from CQM      *
  *                      V3.2 to V3.3 and then attempting to     *
  *                      fallback to V3.2, or if the CQMPROFS    *
  *                      dataset is used simultaneously by both  *
  *                      V3.2 and V3.3 CQM subsystems.           *
  *                      Once they are accessed or used by CQM   *
  *                      V3.3, the CQMPROFS and CQMINTER data    *
  *                      sets are no longer compatible with      *
  *                      CQM V3.2. Example error messages for    *
  *                      the Profile data set (CQMPROFS):        *
  *                      CQM2604E VSAM LOGIC ERROR VSAMRC=X'08'  *
  *                      VSAMRS=X'002C' CQM#IVSM(05D36)          *
  *                      CQM3301E LOAD FAILED FOR PROFILE        *
  *                      profile ON ssid                         *
  *                      CQM3304E PROFILE CHANGE FAILED FOR      *
  *                      ssid                                    *
  *                      Example error messages for the          *
  *                      Interval data set (CQMINTER):           *
  *                      CQM2604E VSAM LOGIC ERROR VSAMRC=X'08'  *
  *                      VSAMRS=X'002C' CQM#UINX(01026)          *
  *                      IEA794I SVC DUMP HAS CAPTURED:  974     *
  *                      DUMPID=010 REQUESTED BY JOB (cqmproc  ) *
  *                      DUMP TITLE=DB2 QUERY MONITOR #DRVR      *
  *                      SUBTASK ABEND                           *
  ****************************************************************
  * 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:

  UI49876 UI49877

Modules/Macros

• CQM$ACTV CQM$CPRF CQM$DDB2 CQM$SM01 CQM$SM02
  CQM#FEXS CQM#GPRF CQM#IVCV CQM#IVSM CQM#LOAX CQM#QAPI CQM#QAPX
  CQM#QSQL CQM#SSMN CQM#UINX CQM@WDB2 CQMBLOB  CQMCAE   CQMCAEPT
  CQMCAPI  CQMCPXPT CQMEO    CQMJAR   CQMMACTX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R320 PSY UI49876

     UP17/09/11 P F709

• R330 PSY UI49877

     UP17/09/11 P F709

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.