PH58310: CQM@WDB2 ABENDS WITH ERROR MESSAGE: CQM7004E UNIDENTIFIED COLUMN, OFFLOAD ENDS WITH RC=12.

202312081627.CQMCAE

APAR status

• Closed as new function.

Error description

• CQM@WDB2 ABENDS with error message:
  CQM7004E UNIDENTIFIED COLUMN,  OFFLOAD ends with RC=12.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1. Users of IBM Db2 Query Monitor V3.3       *
  *                 2. Existing users of QM 3.3 who offload data *
  *                    to summary tables                         *
  ****************************************************************
  Minor internally discovered defects
  

Problem conclusion

• 1. Support for CAE userids that include a '$'
  2. Resolved CAE conflict - unable to showing 3.3 subsystem
  when 3.4 installed
  3. Resolved possible CQM7004E UNIDENTIFIED COLUMN <column name>
  IN TABLE SUMMARY METRICS
  

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:

  UI95069

Modules/Macros

• CQM#EXCP CQM@WDB2 CQMALT18 CQMBLOB  CQMCFPAX CQMCPXPT CQMDDL
  CQMJAR   CQMMEBCX CQMMEBPX CQMMEBRX CQMMEBSX CQMMECCX CQMMECPX
  CQMMECRX CQMMECSX CQMMEDCX CQMMEDPX CQMMEDRX CQMMEDSX CQMMEMTX
  CQMMFREX CQMMINDX CQMUPXPT
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R330 PSY UI95069

     UP23/12/29 P F312

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.