A fix is available
APAR status
Closed as program error.
Error description
The contents of a number of CQM data display and HELP panels have been changed to correct inconsistencies, missing or incorrect HELP panels, data contents and PF-Key navigation problems. The text of MSG CQM802E has been changed to reflect customer referral to IBM support rather than self-diagnosis. When viewing captured SQL text through panels CQM$DQDE and CQM$DESQ the ISPF user may experience a "CALL ATTACH" error in the ISPF session. This will occur when the user is attempting to view the test from a DB2 subsystem that either does not have CQM installed, or the subsystem is at a PTF level prior to UQ71500. ****************** ADDITIONAL SYMPTOMS: * commands disappear for dbrm detail screeen ****************************************
Local fix
LOAL FIX for this error is to run one of the below jobstreams on the DB2 subsystem where the SQL text was collected from. (jobstream BND#STXT for DB2 V6 or below, jobstream BND7STST for DB2 V7) The name of the DB2 application plan for this BIND should match the application PLAN name of the monitoring CQM instance. . //BND#STXT JOB ,'CQM@STXT / V6',CLASS=A,MSGCLASS=X, // NOTIFY=&SYSUID //BIND EXEC PGM=IKJEFT01,DYNAMNBR=20 //STEPLIB DD DISP=SHR,DSN=DSN.SDSNLOAD //SYSPRINT DD SYSOUT=* //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //DBRMLIB DD DISP=SHR,DSN=HILEVEL.V1R1.DBRMLIB //* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * //* * //* LICENSED MATERIALS - PROPERTY OF IBM * * //* 5655-E67 * //* (C) COPYRIGHT IBM CORP 2000, 2002 * //* ALL RIGHTS RESERVED. * //* (C) COPYRIGHT ROCKET SOFTWARE, INC. 2000, 2002 * //* ALL RIGHTS RESERVED. * //* US GOVERNMENT USERS RESTRICTED RIGHTS - * //* USE, DUPLICATION OR DISCLOSURE RESTRICTED * //* BY GSA ADP SCHEDULE CONTRACT WITH IBM CORP. * //* * TRADEMARK OF INTERNATIONAL BUSINESS MACHINES * //* * //* NOTE: * //* * //* FOR DB2 V7 SUBSYSTEMS, RUN MEMBER BND7STXT * //* INSTEAD OF MEMBER BND#STXT. * //* * //* ISSUE CHANGE COMMANDS: * //* C XXXX TO DB2 SUBSYSTEM ID * //* C YYYY TO VALID DB2 USERID * //* CHANGE THE HILEVEL.V1R1.DBRMLIB TO THE NAME OF THE * //* QUERY MONITOR DBRMLIB PDS INSTALLED IN YOUR SYSTEM * //* * //* CHANGE DSN.SDSNLOAD TO THE NAME OF THE DB2 LOADLIB PDS * //* INSTALLED IN YOUR SYSTEM. * //* * //* CHANGE CQMPLAN1 TO A PLAN NAME OF YOUR CHOICE OR KEEP * //* THE DEFAULT - REMEMBER THIS MUST MATCH THE NAME * //* PROVIDED WITHIN THE SETUP PANEL FOR THE MONITORING * //* CQM SYSTEM. //* * //*********************************************************** //SYSTSIN DD * DSN SYSTEM(XXXX) BIND PACKAGE (CQMXXXX) - QUALIFIER (CQMXXXX) - MEMBER (CQM@STXT) - OWNER (YYYY) - ACTION (REPLACE) - DYNAMICRULES (RUN) - EXPLAIN (NO) - ISOLATION (CS) - VALIDATE (RUN) BIND PACKAGE (CQMXXXXH) - QUALIFIER (CQMXXXXH) - MEMBER (CQM@STXT) - OWNER (YYYY) - ACTION (REPLACE) - DYNAMICRULES (RUN) - EXPLAIN (NO) - ISOLATION (CS) - VALIDATE (RUN) BIND PLAN (CQMPLAN1) - PKLIST (CQMXXXX.* - CQMXXXXH.* - ) - ACTION (REPLACE) - RETAIN - DYNAMICRULES (RUN) - EXPLAIN (NO) - ISOLATION (CS) - SQLRULES (DB2) - VALIDATE (RUN) END /* // //BND7STXT JOB ,'CQM@STXT / V7',CLASS=A,MSGCLASS=X, // NOTIFY=&SYSUID //BIND EXEC PGM=IKJEFT01,DYNAMNBR=20 //STEPLIB DD DISP=SHR,DSN=DSN.SDSNLOAD //SYSPRINT DD SYSOUT=* //SYSTSPRT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //DBRMLIB DD DISP=SHR,DSN=HILEVEL.V1R1.DBRMLIB //* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * //* * //* LICENSED MATERIALS - PROPERTY OF IBM * * //* 5655-E67 * //* (C) COPYRIGHT IBM CORP 2000, 2002 * //* ALL RIGHTS RESERVED. * //* (C) COPYRIGHT ROCKET SOFTWARE, INC. 2000, 2002 * //* ALL RIGHTS RESERVED. * //* US GOVERNMENT USERS RESTRICTED RIGHTS - * //* USE, DUPLICATION OR DISCLOSURE RESTRICTED * //* BY GSA ADP SCHEDULE CONTRACT WITH IBM CORP. * //* * TRADEMARK OF INTERNATIONAL BUSINESS MACHINES * //* * //* NOTE: * //* * //* FOR DB2 V6 OR V5 SUBSYSTEMS, RUN MEMBER BND#STXT * //* INSTEAD OF MEMBER BND7STXT. * //* * //* ISSUE CHANGE COMMANDS: * //* C XXXX TO DB2 SUBSYSTEM ID * //* C YYYY TO VALID DB2 USERID * //* * //* * //* CHANGE THE HILEVEL.V1R1.DBRMLIB TO THE NAME OF THE * //* QUERY MONITOR DBRMLIB PDS INSTALLED IN YOUR SYSTEM * //* * //* CHANGE DSN.SDSNLOAD TO THE NAME OF THE DB2 LOADLIB PDS * //* INSTALLED IN YOUR SYSTEM. * //* * //* CHANGE CQMPLAN1 TO A PLAN NAME OF YOUR CHOICE OR KEEP * //* THE DEFAULT - REMEMBER THIS MUST MATCH THE NAME * //* PROVIDED WITHIN THE SETUP PANEL FOR THE MONITORING * //* CQM SYSTEM. * //* * //*********************************************************** //SYSTSIN DD * DSN SYSTEM(XXXX) BIND PACKAGE (CQMXXXX) - QUALIFIER (CQMXXXX) - MEMBER (CQM@STXT) - OWNER (YYYY) - ACTION (REPLACE) - DYNAMICRULES (RUN) - EXPLAIN (NO) - ENCODING(EBCDIC) - ISOLATION (CS) - VALIDATE (RUN) BIND PLAN (CQMPLAN1) - PKLIST (CQMXXXX.* - CQMXXXXH.* - ) - ACTION (REPLACE) - RETAIN DYNAMICRULES (RUN) - EXPLAIN (NO) - ISOLATION (CS) - ENCODING(EBCDIC) - SQLRULES (DB2) - VALIDATE (RUN) END /* //
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 Query Monitor Users * **************************************************************** * PROBLEM DESCRIPTION: The contents of a number of CQM data * * display and HELP panels have been * * changed to correct inconsistencies, * * missing or incorrect HELP panels, * * data contents and PF-Key navigation * * problems. * * * * The text of MSG CQM802E has been * * changed to reflect customer referral * * to IBM support rather than * * self-diagnosis. * * * * When viewing captured SQL text through * * panels CQM$DQDE and CQM$DESQ the ISPF * * user may experience a "CALL ATTACH" * * error in the ISPF session. This will * * occur when the user is attempting to * * view the test from a DB2 subsystem that * * either does not have CQM installed, or * * the subsystem is at a PTF level prior t * * UQ71500. * * * **************************************************************** * RECOMMENDATION: * **************************************************************** Code changed have been made to correct these issues.
Problem conclusion
APPLY PTF
Temporary fix
Comments
APAR Information
APAR number
PQ70420
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
110
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2003-01-29
Closed date
2003-04-03
Last modified date
2003-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UQ75704
Modules/Macros
CQM$CSTM CQM$DECA CQM$DPLN CQM$DQDE CQM$DSQL CQM$DSTM CQM$DTHR CQM$DUDP CQM$DUPL CQM$DUSM CQM$DYNA CQM$EXCP CQM$FTLR CQM$INTV CQM$MAIN CQM$STHR CQM#ICQM CQM#RELD CQM#SCLN CQM#STXT CQM#TIAR CQM@WDB2 CQMBLANK CQMCOMMA CQMCOMPD CQMCOMPS CQMHDQAL CQMHDQDE CQMHDQSM CQMHDQSP CQMHDUPL CQMHINTV CQMHMAIN CQMH0085 CQMMAIN CQMNONUM CQMSSCTL CQMSSTAT CQMUTERM CQM002E CQM01 CQM010E CQM018E CQM06 CQM080E CQM089E CQM10 CQM112E CQM113E CQM114E CQM115E CQM116E CQM117E CQM118E CQM119E CQM120E CQM122E CQM125I CQM7STXT CQM802E CQM91 CQM99 H238110J
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R110 PSY UQ75704
UP03/04/12 P F304 Ž
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"110"}]
Document Information
Modified date:
12 April 2021