A fix is available
APAR status
Closed as program error.
Error description
After upgrading from CQM V2.3 to V3.3 in DB2V11 (CM), the data from older intervals (plan, packages, sql texts, CPU...) are not displayed properly. Furthermore, we get an error 0C9 - 00000009, when trying to view the sql text. In the attached file, there is a print screen of the error we get.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: IBM Db2 Query Monitor for z/OS * * users of component * * - CQM Data Collector * * - Summaries * **************************************************************** * PROBLEM DESCRIPTION: Issue with upgrade from CQM V2.3 to CQM * * V3.3. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Multiple skip-level migrations caused ABENDs S0C9 on Summaries panels for the data from old V2.3 intervals (plan, packages, sql texts, CPU...).
Problem conclusion
Logic was corrected to process data from older versions correctly. Search Keywords: ABEND 0C9 SUMMARIES CQM V2.3
Temporary fix
Comments
APAR Information
APAR number
PH31899
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
330
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-11-19
Closed date
2021-02-18
Last modified date
2021-03-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CQM#ARCX CQM#CIDC CQM#CTLF CQM#FDSN CQM#INIX CQM#INTX CQM#IVCV CQM#IVSM CQM#LOAX CQM#PARM CQM#QAPI CQM#QAPX CQM#QSQL CQM#SDAQ CQM#SWTX CQM#UINX CQM$ACTV CQM$BUFP CQM$CALL CQM$CNCL CQM$CPRF CQM$DB2C CQM$DDB2 CQM$DELY CQM$DSCV CQM$ERRP CQM$FILT CQM$FLT2 CQM$FLTC CQM$HSTV CQM$INTD CQM$INTV CQM$LINK CQM$LOCK CQM$MAIN CQM$OBJS CQM$PRFS CQM$PROF CQM$QLCA CQM$QRPT CQM$RANG CQM$SM01 CQM$SMKY CQM$SQC2 CQM$SQC3 CQM$SQCD CQM$SQCE CQM$SQCI CQM$SQCL CQM$SQCM CQM$SQCP CQM$SQCS CQM$SQLT CQM$TEXT CQM$YLOG CQM$YXLG CQM18 CQM185E CQM@WDB2 CQMBLOB CQMCAEPT CQMCPXPT CQMDSECT CQMICRT CQMJAR CQMMEMTX CQMMEXXX CQMMQAPX CQMSSV CQMTTXTX CQMUPXPT
Fix information
Fixed component name
DB2 QUERY MONIT
Fixed component ID
5655E6701
Applicable component levels
R330 PSY UI74033
UP21/03/05 P F102
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"3.3.0"}]
Document Information
Modified date:
06 March 2021