Click on an APAR number to display the full information for that APAR. There may be a few days delay after the APAR closes before it is available on this website.
Click on a PTF number to download that PTF. You will need an IBMID. Latest update: 21 November 2024
DB2 Query Monitor Version 2.3
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PM85046
5_Jun
2013
UK94869


ERRORS IN ESTAE SETUP PROCESSING FOR SDUMP CAN PREVENT ABEND DUMPS
PM84650
2_May
2013
UK94008


CPU CONSUMPTION IS HIGHER FOR AN APPLICATION WHEN QM IS RUNNING,ALTHOUGH THE APPLICATION IS NOT BEING MONITORED BY QM.
PM85777
2_May
2013
UK94006


COMPATIBILITY WITH DATA CAPTURE
PM85348
18_Apr
2013
UK93578


INCORRECT CCSID REPORTED FOR HOST VARIABLES WITH DISTRIBUTED WORKLOADS ON DB2 V8
PM82272
5_Apr
2013
UK93195


STORED PROCEDURE NAME NOT REPORTED FOR NESTED STORED PROCEDURE CALL.
PM83973
5_Apr
2013
UK93195


ENHANCEMENT FOR FUTURE DB2 VERSION
PM78312
20_Mar
2013
UK92697


MODIFICATIONS TO INTERNAL STORAGE MANAGEMENT SYSTEM TO IMPROVE PERFORMANCE
PM79237
20_Mar
2013
UK92710


DATA COLLECTION IS NOT OCCURRING ON MACHINES THAT DO NOT HAVE THE EXTRACT CPU TIME FACILITY.
PM81190
12_Mar
2013
UK92447


INCORROUT - CCSID NOT REPORTED FOR NULL TERMINATED CHAR STRING (SQLTYPE = 460) HOST VARIABLE
PM82829
12_Mar
2013
UK92452


ADDRESS SPACES ARE NOT BEING CREATED, MESSAGE MSGIEA602I MAY BE ISSUED.
PM82953
12_Mar
2013
UK92452


ABEND60D-18 POSSIBLE ABEN0CX OR NO STATISTICS BEING COLLECTED OFAN ISOLATED THREAD, MISSING MONITORING DATA FOR A THREAD
PM80429
28_Feb
2013
UK92082


Description not available. Security/Integrity exposure
PM77917
15_Feb
2013
UK91728


OQWT INTEGRATION
PM78779
15_Feb
2013
UK91733


INCORRECT CURSOR NAME DISPLAYED UNDER SQLCA SCREEN
PM81259
15_Feb
2013
UK91738


ABENDS0C4-04 IN LMOD CQMTTXTX
PM77994
23_Jan
2013
UK91139


PRODUCT SUITE COMPATIBILITY SUPPORT
PM78037
7_Jan
2013
UK90765


DETECT NEW DRDA CONNECTION ON EXISTING THREAD
PM74071
2_Jan
2013
UK90696


LOG RECORDS MAY BE GENERATED ON CQM STARTUP FOR ABEND0C4 RC3B
PM77735
18_Dec
2012
UK90474


ABEND0C4 IN CQMMINST + X'955C', CQM COLLECTS MINIMUM MONITORING DATA.
PM75733
17_Dec
2012
UK90439


INCORRECT INDEX NAME MAY BE REPORTED IN OBJECT SUMMARIES
PM77108
10_Dec
2012
UK90201


GUARDIUM APPLIANCE DOES NOT SHOW SQL EXECUTION IF -904 SQLCODE
PM73761
20_Nov
2012
UK83699


MESSAGE CQM3308E MAY BE ISSUED
PM65477
20_Nov
2012
UK83699


CQM1205E ISM ERROR OCCURRED, CQM1203I RC=0008, RSN=004C, RSN=0038
PM70562
6_Sep
2012
UK81578


CQMMSTR STOP STC GETS RC08
PM65020
28_Aug
2012
UK81383


HOST VARIABLE/PARAMETER MARKER DATA WITH CCSID 819 NOT READABLE IN THE HOSTV_TEXT COLUMN IN TABLE SYSTOOLS.CQM23_EXCP_HOSTV
PM65732
14_Aug
2012
UK81068


CQM8021E INTERVAL ...IS BEING WRITTEN AND CANNOT BE OFFLOADED UNTIL IT COMPLETES
PM64324
9_Aug
2012
UK80969


DB2 QUERY MONITOR #SSMN SUBTASK ABENDU3312 MESSAGES CQM3312E AND CQM2002E
PM66025
9_Aug
2012
UK80960


CQM1217W REQUEST WOULD HAVE EXCEEDED MAXIMUM ALLOCATIONS VALUE DB2 QUERY MONITOR MSQLW SUBTASK ABEND ABEND0C4
PM63662
9_Aug
2012
UK80959


CQM2606E TERMINATING DUE TO DATASET_FULL(AB0RT)
PM63192
27_Jul
2012
UK80609


CHANGES TO IMPROVE EFFICIENCY WHEN RETRIEVING SQL TEXT FROM THE CATALOG
PM63072
26_Jul
2012
UK80553


QM ABENDU1126 MODULE CQM#TIAB
PM67695
26_Jul
2012
UK80568


SUPPORT FOR FUTURE ENHANCEMENTS
PM60321
17_Jul
2012
UK80353


ERRONEOUS ZIIP CPU TIMES AND CPU GREATER THAN ELAPSED
PM61893
16_Jul
2012
UK80331


INCORRECT VALUE IN THE DB2_ELAPSED COLUMN OF THE SUMM_METRICS TABLE
PM54396
28_Jun
2012
UK79985


DELAY AND ELAPSED TIME ATTRIBUTED TO THE WRONG PROGRAM FOR TWO-PHASE COMMITS WITHIN RRS.
PM63301
12_Jun
2012
UK79507


SUPPORT FOR FUTURE ENHANCEMENTS
PM62933
21_May
2012
UK78904


EXAGGERATED ELAPSE TIMES IN SUMMARIES, GLOBAL CONTENTION DELAY TOTAL AND NO ASSOCIATED TIMES RESULTING IN INCORRECT DELAYS
PM59148
7_May
2012
UK78550


STATEMENT NUMBERS OVER 9,999 ARE TRUNCATED ON PANELS CQM$HSTV AND CQM$HST8
PM60843
7_May
2012
UK78551


TSO USER ABEND478 RC08 IN CQM$TEXT
PM61627
19_Apr
2012
UK78096


ABENDSC03 WHEN OFFLOAD DATA WITH SMALL SQLCTEXT DATASET
PM59587
10_Apr
2012
UK77804


ABEND0C4 RC04 AT LMOD CQM@ITXT OFFSET X'2856'
PM57882
29_Mar
2012
UK77495


CQM2602E OPEN FAILED FOR VSAM DATASET... DB2 QUERY MONITOR #ARCH SUBTASK ABEND
PM57928
13_Mar
2012
UK77018


COMMAND TIMESTAMP IS INCORRECT IN AN OFFLOAD TABLE
PM57014
29_Feb
2012
UK76683


MISSING OBJECT DETAILS - MISSING INDEX GETPAGES IN SUMMARIES ANDEXCEPTIONS
PM53265
27_Feb
2012
UK76564


PANEL CQM$SQCM SHOWS WRONG NUMBERS WHEN GROUP BY SQLCODE
PM35707
23_Feb
2012
UK76478


WRONG EXCEPTION GETPAGE COUNTS
PM52526
21_Feb
2012
UK76403


ALERTS FROM THE ALERT BROWSER LOST AFTER PK78911 WHEN CQM CAE 2.3 CUSTOMERS RETAIN THEIR CAE EVENTS OVER A SERVER
RESTART.
PM42616
9_Feb
2012
UK76044


OFFLOAD TABLE SUMM_TEXT HAS INCORRECT VALUE FOR TEXT_TIMESTAMP
PM51646
3_Feb
2012
UK75931


OBJECT ELAPSED TIME MAY BE INCORRECT WHEN VIEWING MULTIPLE INTERVALS
PM56212
1_Feb
2012
UK75857


ABENDS0C4 IN MODULE CQMTXLA1 OFFSET X'A8' 12/01/19 PTF
PECHANGE
PM33191
30_Jan
2012
UK75804


CODE CHANGES TO IMPROVE FRR RETRY PROCESSING.
PM40092
5_Jan
2012
UK75220


ABEND0C4-11 CQMMINST +43C AT PM28593 ON CQM SHUTDOWN.
PM54487
5_Jan
2012
UK75224


ABEND0C4 CAUSED BY STORAGE OVERLAY WITH ACTIVE COLLECTION CONTAINING LARGE NUMBER OF FILTERS
PM49839
28_Dec
2011
UK75136

HIPER

ABENDS0D DB2 QUERY MONITOR R230
PM38304
28_Dec
2011
UK75140


CQM12XX MESSAGES MAY BE FORMATTED INCORRECTLY.
PM53289
28_Dec
2011
UK75136


ABEND0C4 RC11 IN CQM#LCSX, ABENDSB78-18
PM45839
8_Dec
2011
UK74619
PM56212

PERFORMANCE ENHANCEMENT
PM50246
8_Dec
2011
UK74619
PM56212

HOST VARIABLES INCORRECTLY REPORTED FOR EXECUTE IMMEDIATE SQL STATEMENTS.
PM37676
7_Dec
2011
UK74570


INCONSISTENT DATA IN GROUP_NAME COLUMN.
PM31832
18_Nov
2011
UK73998


ABEND0C1 IN MODULE CQMTTXTX+30BA
PM44678
15_Nov
2011
UK73874


ABEND0D5-21 IN CQMOINST+ X'F40' AT CQM SHUTDOWN, MONITORING AGENT NOT DE-INSTALLED.
PM42518
2_Nov
2011
UK73488


POSSIBLE MISSING EVENTS DURING COLLECTION
PM39556
2_Nov
2011
UK73486


MISSING DYNAMIC SQL TEXT WITH REOPT BIND OPTIONS.
PM49535
2_Nov
2011
UK73457


INCORROUT: COLLECTOR NOT COLLECTING AUDIT DATA IN SOME SITUATIONS
PM41190
1_Nov
2011
UK73410


THERE IS A DIRECTORY BROWSING VULNERABILITY IN CAE SERVER.
PM43184
1_Nov
2011
UK73421


MESSAGE HOST VARIABLES NOT AVAILABLE WHEN DISPLAYING TEXT HOSTVARS ON GUI TAB
PM43917
1_Nov
2011
UK73410


IGD17501I ATTEMPT TO OPEN A HFS FILE FAILED, RETURN CODE IS (00000081) REASON CODE IS (0594003D) WHEN STARTING CAE SERV
USS
PM49337
1_Nov
2011
UK73410


ADD CAE SUPPORT FOR CASE SENSITIVE PASSWORDS.
PM45478
27_Oct
2011
UK73306


MESSAGE "CQM104I NO HOST VARIABLES PRESENT OR PROFILE STATED NOTTO COLLECT THEM " IS INCORRECTLY ISSUED.
PM33890
24_Oct
2011
UK73186


ABEND S0C4 DSNLZLLM . DSNLZS01 ISSUED.
PM49110
20_Oct
2011
UK73089


MESSAGE CQM155E - ERROR OPENING SQLCD BACKSTORE DATA SET, CQM2602E ABENDSA03 IN CQM@WDB2.
PM46958
19_Oct
2011
UK73044


COLLECTION OF CREATE/ALTER/DROP EVENTS IN ASC TASK.
PM46784
18_Oct
2011
UK73014


STAGE 0 FILTERING
PM48101
13_Oct
2011
UK72866

HIPER

DB2 THREADS HANG AFTER COLLECTOR SHUTDOWN
PM34020
27_Sep
2011
UK72288


CQM1055E REASON = 10000000 ISSUED
PM46092
9_Sep
2011
UK71774


CQM1217W, CQM1204I, CQM1209I, CQM1203I ISSUED BY CQM COLLECTOR WHILE MONITORING A V9 DB2
PM44784
29_Aug
2011
UK71347

HIPER

DB2 ABEND04E RC00E50079 IN DSNVSRX 11/08/01 PTF
PECHANGE
PM44860
29_Aug
2011
UK71347


HIGH CPU USAGE
PM41463
8_Aug
2011
UK70594


IMPROVED FILTER PROCESSING
PM33658
1_Aug
2011
UK70384


ABENDS052 RETURN CODE=102 CQMISMPX+12546 (AT PM20720 LEVEL) ABENDS052 RETURN CODE=102 CQMISMPX+1252E (AT PM28049 LEVEL)
PM32782
13_Jul
2011
UK69730


AUTHID AND/OR SQLID MISSING FOR DB2 V10 ACTIVITY
PM36424
13_Jul
2011
UK69730


SUPPORT FOR FILTERING BY CONNECTION TYPE AND ORIGINAL AUTHID IN AUDIT.
PM23636
8_Jul
2011
UK69568
PM44784

OBJECT DETAIL CAN REPORT N/A FOR TABLE CREATOR OR TABLE NAME FORSOME DB2 V10 WORKLOADS
PM37606
8_Jul
2011
UK69568
PM44784
HIPER

DB2 ABEND04E MIGHT BE CAUSED DUE TO POSSIBLE EXPOSURE TO OVERLAYWHEN NESTED DYNAMIC SQL WORKLOAD RECEIVES A -905
PM36542
16_Jun
2011
UK68822


EXCEPTION HOST VARIABLE INFORMATION COLLECTED IS NOT FOUND IN DB2 OFFLOAD TABLES
PK78911
14_Jun
2011
UK68783


PRECONDITIONING APAR TO ALLOW FOR FEATURES IN FUTURE VERSIONS
PM39096
31_May
2011
UK68327


INVALID MESSAGE CQM1055E REASON=80000000 MAY BE ISSUED AFTER THECOLLECTOR IS RECYCLED.
PM38983
20_May
2011
UK67975


UNNECESSARY LOGREC RECORDS MAY BE WRITTEN
PM35426
27_Apr
2011
UK67155


HIGH CPU CONSUMPTION BY ASC COLLECTOR
PM35316
18_Apr
2011
UK66860


DB2 QUERY MONITOR FOR Z/OS V2R3 FOR DB2 V9 / V10 ISSUES CQM2002EMESSAGE AND WILL NOT COMPLETE STARTUP
PM25281
11_Apr
2011
UK66646


CQM1055E INTEGRATED STORAGE MANAGER DURING REQUEST FOR FREE DB2CMDS RC08 RS55 DURING INTERNAL QM EXTENT PROCESSING
PM34473
30_Mar
2011
UK66410


DB2 QUERY MONITOR FOR Z/OS V2R3 FOR DB2 V8 ISSUES CQMQ2002E MESSAGE AND WILL NOT COMPLETE STARTUP
PM25505
28_Mar
2011
UK66187


IMPROVED SUPPORT OF SCREEN DISPLAYS WIDER THAN 132 BYTES
PM29182
22_Mar
2011
UK66035


SQL TEXT IS NOT DISPLAYED UNDER SUMMARIES WHEN PLAN HAS REOPT(AUTO)
PM32673
22_Mar
2011
UK66025


ABEND0C4 DURING ABNORMAL TASK TERMINATION.
PM23842
14_Mar
2011
UK65762


MESSAGES CQM3308E AND CQM3192I MAY BE ISSUED
PM12174
11_Mar
2011
UK65726


SQL CODES CANNOT BE ADDED TO THE SQLCODE EXCLUSION LIST IN DB2 QUERY MONITOR PROFILES
PM06856
3_Mar
2011
UK65434


MESSAGING ENHANCEMENTS
PM22156
16_Feb
2011
UK64920


COLUMN SORT ORDER UNDER EXCEPTIONS NOT MAINTAINED CONSISTENTLY WHEN NAVIGATING THROUGH INTERVALS USING PF4 AND PF6
PM31038
15_Feb
2011
UK64856

HIPER

HIGH CPU USAGE IN DB2 TASKS, LOOP IN CQMOXG9X RANGE +81A - +908 11/02/17 PTF
PECHANGE
PM28049
20_Jan
2011
UK64083


ABEND0C4 CQMOXG9X AND DB2 ABEND04E RC00E50001
PM28593
28_Dec
2010
UK63539
PM31038
HIPER

STORAGE OVERLAY MAY CAUSE DB2 THREADS TO HANG , INCORRECT DATA MAY BE DISPLAYED , PSA OVERLAY 10/12/15 PTF PECHANGE
PM27711
16_Dec
2010
UK63210


CQM1050E, CQM1055E AND CQM USER ABEND1050 WHILE PROCESSING NEGATIVE SQLCODES.
PM26079
8_Dec
2010
UK62947


SQL TEXT NOT PROVIDED FOR SOME DYNAMICALLY EXECUTED PREPARED STATEMENTS
PM19751
19_Nov
2010
UK62363


QUERY MONITOR INCORRECTLY REPORTING SQLCODE805
PM19709
19_Nov
2010
UK62363


CQM INCORRECTLY REPORTING -904 SQL CODE FOR PARALLEL TASKS
PM23979
19_Nov
2010
UK62363


SQL COMMIT STATEMENT REPORTED IN INCORRECT PROGRAM
PM21452
16_Nov
2010
UK62240


INCORROUT: INCORRECT DATA IN HOSTV OF SQLTYPE LARGE INTEGER (496)
PM19455
16_Nov
2010
UK62238


CQM ID-ONLY FILTERING
PM20720
16_Nov
2010
UK62240


MODIFICATIONS TO SUPPORT FUTURE ENHANCMENTS
PM21933
2_Nov
2010
UK61864


DB2 V9 HOST VARIABLE (DOUBLE) NOT DISPLAYING PROPERLY
PM11844
1_Nov
2010
UK61832
PM31038

INCORRECT OBJECTS / CONTOKENS DISPLAYED FOR SOME DB2 V10 WORKLOADS
PM23621
28_Oct
2010
UK61756


ABEND 0C4-11 IN MODULE CQMMHSTX + X'E26'
PM18856
19_Oct
2010
UK61484


ABEND S0D6-00000027 OCCURS WHEN USING "NORUN" OPTION VIEWING INTV HISTORY DATA
PM23855
19_Oct
2010
UK61485


INACCURATE DB2_ELAPSED IN DB2 OFFLOAD TABLES
PM12266
28_Sep
2010
UK60850


ABEND 0C1 IN CQMTTXTX + 25DA
PM22250
28_Sep
2010
UK60847


MESSAGE CQM2002E MAY BE INCORRECTLY ISSUED
PM17150
22_Sep
2010
UK60688

HIPER

EXPOSURE FOR SUSPENDED EXTENT PROCESSING MAY RESULT IN LOOPING ISM REQUESTS AND CAUSE SYSTEM WAIT STATE TO OCCUR
PM09024
9_Sep
2010
UK60348


CQM2604E VSAM LOGIC ERROR VSAMRC=X'08' VSAMRS=X'006C' CQMMEXC1(07644) ABEND18A RC55000101 CQMTTXTX+1BC6
PM13470
9_Sep
2010
UK60348


DB2 QUERY MONITOR MEXCW SUBTASK ABEND S378 RC14
PM18571
2_Sep
2010
UK60263


DB2 QUERY MONITOR MONITORING AGENT FAILS TO INSTALL FOR DB2 V10 SUBSYSTEMS
PM19337
2_Sep
2010
UK60219


OBJECT DETAIL NOT DISPLAYING AFTER DB2 VERSION IS UPGRADED
PM19583
2_Sep
2010
UK60263


DB2 QUERY MONITOR AGENT INSTALL FAILURE MAY OCCUR
PM18569
27_Aug
2010
UK60080


INTERNAL MODIFICATIONS TO SUPPORT ADDITION OF STMT_ID DATA FOR STATIC AND DYNAMIC SQL STATEMENTS
PM19028
27_Aug
2010
UK60080


INCORRECT LENGTH AND VALUE USED FOR VARGRAPHIC HOST VARIABLE TYPES
PM19032
27_Aug
2010
UK60080


BIND VARIABLES STATEMENTS WITH NO PLACE HOLDERS, BUT HAS VALUES
PM19250
27_Aug
2010
UK60080


ERROR WITH COLLECTION OF HOSTV OF SQLTYPE 480 CONTAINING IEEE FLOATING POINT
PM20411
27_Aug
2010
UK60080


ABENDU1050 CQMISMAX+59A OR ABEND0C1 CQMISMPX+12400 AND COLLECTOR STARTED TASK TERMINATES
PM15031
26_Aug
2010
UK59998


INFLATED ELAPSE TIMES CAN OCCUR IN OPERATIONAL SUMMARIES AFTER PACKAGES ARE EXCLUDED FROM PROFILE
PM18192
20_Aug
2010
UK59873

HIPER

HIGH CPU USAGE MAY OCCUR WHEN MONITORING NEGATIVE SQLCODES
PM19527
20_Aug
2010
UK59873


HIGH CPU SEEN IN APPLICATION CALLS
PM19253
17_Aug
2010
UK59737


INCORRECT VALUE FOR "REQUESTOR SERVER" FIELD
PM16268
6_Aug
2010
UK59515


MEMORY IS NOT RELEASED AFTER DISPLAYING LARGE AMOUNTS OF SQLCODEDATA IN CQM CAE
PM10909
5_Aug
2010
UK59479


POTENTIAL SUBTASK ABEND IN THE EXCEPTION WRITER RESULTING IN CQM1055E ERROR MESSAGE
PM10773
27_Jul
2010
UK59202
PM28593

CQM COLLECTOR PERFORMANCE ENHANCEMENTS
PM15063
27_Jul
2010
UK59202
PM28593

INCORRECT DATA IN HOSTV OF SQLTYPE CLOB (408) IN OFFLOAD FILES
PM15555
27_Jul
2010
UK59202
PM28593

USING CACHE_INTERVAL CAUSES DELAYED INTERVAL PROCESSING AND SUMMARY DATA DISAPPEARS FROM PREVIOUS INTERVAL
PM16783
27_Jul
2010
UK59202
PM28593
HIPER

CQM COLLECTOR PERFORMANCE ENHANCEMENTS - ADDITIONAL SUPPORT ABEND0C4 RC38 LMOD DSNX8LLM CSECT DSNX8DAL OFFSET +0AA4
PM13245
27_Jul
2010
UK59202
PM28593

IN DB2 QUERY MONITOR OPERATIONAL SUMMARIES, FOR DB2 V10, UNKNOWNSQL TYPE DISPLAYED FOR SOME CALLS
PM17743
27_Jul
2010
UK59202
PM28593

HOST VARIABLE VALUES MAY BE INCORRECTLY FORMATTED
PM13130
11_Jun
2010
UK57912

HIPER

HIGH CPU COULD OCCUR AFTER AN INTERVAL SNAP CPU CONSUMPTION WOULD SHOW UP IN THE ALLIED ADDRESS SPACE
PM10562
10_May
2010
UK56849


PROVIDE TOLERATION SUPPORT FOR ENHANCEMENTS
PM08739
22_Apr
2010
UK56324


ABEND0C4-11 IEAVRTI0+170E EXIT STORAGE RELEASED BY CQM#REST
PM06435
16_Apr
2010
UK56174


THE CURRENT INTERVAL IS DISPLAYED INSTEAD OF THE ONE SELECTED.
PK91555
14_Apr
2010
UK56085


UDF FOR CORRECTLY FORMATTING THE HOSTV_TEXT FIELD FOR THE APPROPRIATE DATA TYPE.
PM07448
14_Apr
2010
UK56086


DB2 V10 TOLERATION SUPPORT
PM06869
7_Apr
2010
UK55908


SUPPORT FOR HFS AUDIT DATA OFFLOAD FILES
PM07771
29_Mar
2010
UK55654


ABEND0C1 IN MODULE CQMOXG9X OR CQMOXG8X MAY OCCUR
PK87545
11_Mar
2010
UK55110


IMPROVE MANAGEMENT OF LARGE ALERT VOLUMES IN THE DB2 QUERY MONITOR CAE
PK92654
11_Mar
2010
UK55110


EXCESSIVE MEMORY USE IN DB2 QUERY MONITOR CAE ALERT PROCESSING
PK96526
11_Mar
2010
UK55110


NEW PARAMETERS TO ENABLE CONFIGURATION OF THE NUMBER OF OBJECTS AND HOST VARIABLES ANTICIPATED PER ALERT
PM02506
5_Mar
2010
UK54943


SORT SEQUENCE INCORRECT FOR AVG GETPAGES COLUMN IN CSORT FUNCTION IN DB2 QUERY MONITOR
PM00078
5_Mar
2010
UK54942


INCORRECT INFORMATION MAY BE DISPLAYED FOR A CHILD FOR PARALLEL DATA IN EXCEPTIONS
PK91624
2_Mar
2010
UK54830


INCORRECT STMT# AND STATEMENT TYPE DISPLAYED IN OPERATIONAL SUMMARIES UNDER OPTION "12-CALL"
PK81853
2_Mar
2010
UK54830


DELAY TIMES AND ELAPSED TIMES MAY BE INCORRECTLY CALCULATED IN THE ACTIVITY SUMMARIES AND CURRENT ACTIVITY IN DB2 QUERY
MONITOR
PM06772
2_Mar
2010
UK54830


FOR SOME PARALLEL WORKLOADS SUBMITTED VIA BATCH, THE SQL TEXT ISTRUNCATED IN DRILL DOWN FOR EXCEPTIONS.
PM04559
22_Feb
2010
UK54571


SORT ORDER OUT OF SEQUENCE FOR START/END DATES ON DB2 QUERY MONITOR INTERVAL SELECTION SCREEN IF DATES ARE FROM PREVIOUS
AND
PM04309
9_Feb
2010
UK54248

HIPER

HIGH CPU LOOP IN VSAM BACKSTORE DATASET PROCESSING CQM2604E CQM2609E AND CQM1055E
PK93547
4_Feb
2010
UK54147


DB2 QUERY MONITOR #SWTX SUBTASK ABEND
PM05103
2_Feb
2010
UK54087


POTENTIAL ABEND0C4 IN A DB2 QUERY MONITOR DATA EXTERNALIZATION WRITER DUE TO A NEGATIVE NUMBER BEING USED AS AN ADDRESS
POINTER
PM04274
22_Jan
2010
UK53762


DB2 QUERY MONITOR EXCEPTION DATA MISSING SOME SQL CODES
PM02753
30_Dec
2009
UK53260


DB2 QUERY MONITOR MAXWZ SUBTASK ABEND S0C4
PM02430
28_Dec
2009
UK53206


INCORRECT DATA WHEN HOST VARIABLE IS NULL
PM02493
28_Dec
2009
UK53213


DISTRIBUTED SQL ISSUED VIA OSC IS NOT COLLECTED BY DB2 QUERY MONITOR
PK94797
17_Dec
2009
UK53005


DB2 QUERY MONITOR MCMDW SUBTASK ABENDSD23 CQM2618I CQM1050E
PK98717
11_Dec
2009
UK52808


USER ABEND 4,038 DEC OCCURRED WHEN USING SQLPA TO ANALYZE SQLTEXT
PK98980
10_Dec
2009
UK52778


CQM@ITXT ABEND=S0C4 U0000 REASON=00000004 OFFSET=00002856
PM00502
2_Dec
2009
UK52481

HIPER

DB2 QUERY MONITOR CPU USAGE INCREASE
PK99734
19_Nov
2009
UK52153
PM04309

POSSIBLE STORAGE CREEP SEEN AT THE PK89760 LEVEL IF INFLIGHT(Y) IS SET.
PM00821
19_Nov
2009
UK52153
PM04309
HIPER

EXCESSIVE AUXILIARY STORAGE USAGE AND SYSTEM WIDE PAGING 09/11/09 PTF
PECHANGE
PK98209
19_Nov
2009
UK52141

HIPER

ABEND0DC RC08 MEMTERM ABEND07D RC00 FRR STACK FULL MSG DSNV086E DB2 ABNORMAL TERMINATION REASON 00F30408 - ABEND0C4 RC10 IN
CQM
PK99350
11_Nov
2009
UK51859


STATEMENT NUMBER INCORRECTLY DISPLAYED AS 'N/A' IN DB2 QUERY MONITOR OPERATIONAL SUMMARIES ALSO 0C4 CQMTTEX1+X'31A'
PK98861
29_Oct
2009
UK51576
PM04309
HIPER

A HARD LOOP AFTER INTERVAL SWITCH PROCESSING CAN CAUSE HIGH CPU AND HANG IN THE ALLIED ADDRESS SPACE
PK97205
28_Oct
2009
UK51490


SEND SQL TO OPTIM QUERY TUNER FROM DB2 QUERY MONITOR CAE CLIENT
PK98113
28_Oct
2009
UK51490


CAE SERVER RUNNING ON USS SOMETIMES EXPERIENCES CLASS LOADING DIFFICULTIES WITH VARIOUS SYMPTOMS.
PK90775
19_Oct
2009
UK51183


F CQMSTC,DISPLAY THREADS OUTPUT MESSAGE CQM3190E IS NOT FORMATTED CORRECTLY
PK86434
14_Oct
2009
UK51021


CQM ISPF UPDATES
PK89760
29_Sep
2009
UK50617
PM00821

CPU REDUCTION 09/07/15 PTF
PEREMOVE
PK90891
29_Sep
2009
UK50617
PM00821

COMMIT STATEMENTS NOT DISPLAYED IN OPERATIONAL SUMMARIES
PK96274
29_Sep
2009
UK50617
PM00821

GETPAGE AND OBJECT INFORMATION MAY BE INCORRECTLY DISPLAYED IN ACTIVITY FOR PARALLEL WORKLOADS
PK82168
29_Sep
2009
UK50617
PM00821

PARALLEL ACTIVITY UNDER EXCEPTIONS DOES NOT DISPLAY PARENT, ONLYSHOWS CHILDREN, AND DOES NOT SHOW SQL TEXT FOR CHILDREN
PK69361
29_Sep
2009
UK50617
PM00821

INCORRECT OBJECT ACCESS STATISTICS MAY BE CAPTURED / DISPLAYED WHEN MONITORING WORKLOADS WITH TRIGGERS
PK71861
29_Sep
2009
UK50617
PM00821

DATA IS MISSING FROM EXECUTED PACKAGES FOR SQL NATIVE PROCEDURES
PK96351
23_Sep
2009
UK50408


DB2 QUERY MONITOR MAY ISSUE CQM1055E INCORRECTLY 09/09/18 PTF
PECHANGE
PK94896
14_Sep
2009
UK50077


DB2 QUERY MONITOR PROFILE LINE IS NOT SELECTED WHEN CONNECTION ID OR PLAN NAME IS SPECIFIED IN THE PROFILE
PK92667
31_Aug
2009
UK49723
PK96351
HIPER

LARGE VOLUME OF CQM1055E MESSAGES RESULTING FROM EXCESSIVE STORAGE GROWTH IN >64K TEXT POOL FOR PREPARE WITH ATTRIBUTE
PK87164
12_Aug
2009
UK49205

HIPER

ABENDS0C4 CQMMCMXX+114C WITH R13=0
PK89888
12_Aug
2009
UK49201

HIPER

ABEND0C4 RC10 CQMMMFRR+170CCV
PK89210
30_Jul
2009
UK48844


MESSAGE CQM1055E REASON=XXXXXXXX INCORRECTLY ISSUED
PK91033
30_Jul
2009
UK48844


DB2 QUERY MONITOR MMETR SUBTASK ABEND0C4
PK91817
30_Jul
2009
UK48849


COLLID AND PROGRAM NAME STORED IN SUMM_METRICS OFFLOAD TABLE IN ASCII FORMAT
PK91489
29_Jul
2009
UK48811


UNRELATED/MISSING OBJECTS IN DISPLAYS: CPU TIME HIGH FOR STORED PROCEDURES: REDUCED PERFORMANCE
PK86332
28_Jul
2009
UK48783


PROBLEMS WITH ACTIONS, RESPONSES, AND THE ALERT BROWSER IN THE CAE
PK86449
14_Jul
2009
UK48387


ABEND0C4-38 CQMOXG81+ED0
PK88384
14_Jul
2009
UK48387


CPU REDUCTION
PK75276
6_Jul
2009
UK48123


CORRECT MISCELLANEOUS MESSAGE AND ISPF SCREEN FORMATTING ERRORS CQMCOMM UPDATES
PK85275
18_Jun
2009
UK47572


INVALID PROGRAM NAMES DISPLAYED ON ACTIVITY BY SQL TEXT PANEL
PK78933
8_Jun
2009
UK47266


ABEND 0C2 RC2 OCCURS AFTER A PREVIOUS INSTANCE OF THE CQM COLLECTOR HAS BEEN CANCELLED.
PK79025
3_Jun
2009
UK47132


CQM1013E PROFILE NAME IS INVALID IN PARAMETERS STARTING AT LINE NN COLUMN N FOR KEYWORD MONITOR, CQM2110E TERMINATING DUE TO
PK85969
26_May
2009
UK46911

HIPER

ABEND0C4 RC11 IN CQMOXG8X: ALSO UTILITY ABEND REASON=X'00E40322'CAUSE=X'000C7000
PK85781
22_May
2009
UK46847


CQM8021E INCORRECTLY ISSUED FOR CQM@LDB2 DB2 OFFLOAD JOB
PK84265
18_May
2009
UK46705


INCORRECT VALUE OF ROWS_AFFECTED REPORTED FOR SELECTS
PK81856
18_May
2009
UK46699
PK91489
HIPER

INCREASED CPU USAGE THAT MAY RESULT WHEN MONITORING WORKLOADS USING CURSOR PROCESSING AND LARGE NUMBERS OF CLOSES
PK83774
24_Apr
2009
UK46046


CQM145I INCORRECTLY ISSUED, ALSO ACTIVITY SUMMARY, EXCEPTIONS, AND CURRENT ACTIVITY MAY DISPLAY PROGRAM "N/A"
PK83375
20_Apr
2009
UK45893


INCORRECT, INFLATED CPU TIME MAY BE REPORTED FOR STORED PROCEDURE WORKLOADS
PK83688
17_Apr
2009
UK45872


JOBLOG TIMESTAMPS MAY SOMETIMES BE SHOWN IN GMT
PK83561
10_Apr
2009
UK45694


ABENDS0C1 IN CQMMSSQX+B56 WHICH COULD LEAD TO A STORAGE CONSTRAINT X'0100000000'
PK80034
10_Apr
2009
UK45694

HIPER

INCREASED CPU USAGE DUE TO INVALID CQM1055E STORAGE CONSTRAINT FOR REASON=00000010 MESSAGE, AND CURRENT ACTIVITY NOT CLEARED
PK82655
2_Apr
2009
UK45458
PK85969

REMOVE QUERY MONITOR 'HOOKS' FROM DB2 SUBSYSTEMS WITHOUT RECYCLING THE DB2 SUBSYSTEM
PK81261
30_Mar
2009
UK45370


ABENDS0C1 LOW CORE IN QUERY MONITOR BATCH PROGRAM
PK80373
24_Mar
2009
UK45186


VALUES FOR TIME, DATE, TIMESTAMP HOST VARIABLES ARE DISPLAYED INCORRECTLY.
PK81372
18_Mar
2009
UK45002

HIPER

CQM1050E INTEGRATED STORAGE MANAGER FAILURE DURING REQUEST FOR FREE SQLTEXT RC=008 RS=00065
PK78599
12_Mar
2009
UK44841


CQM1153E RETURN CODE 08 REASON CODE 03 WAS ENCOUNTERED DURING TRANSLATION SOURCE CCSID = 63456 TARGET CCSID = 1208
PK78791
12_Mar
2009
UK44845


CQM GUI DOESN'T SHOW NEGATIV SQL CODES/ALERTS
PK78471
12_Mar
2009
UK44845


INCORRECT TIMESTAMP DISPLAYED FOR DB2 COMMAND ACTIVITY ON THE CAE GUI CLIENT
PK78678
12_Mar
2009
UK44845


THE DATABASE NAME IS EMPTY IN PROPERTY TABLE FOR OBJECTS AND THEDATABASE COLUMN IN ACTIVITY BROWSER IS EMPTY.
PK80924
9_Mar
2009
UK44702


ADD DAY/MONTH TIMESTAMP DISPLAYED IN CAE AGENT LOG
PK75828
6_Mar
2009
UK44645


INCORRECT LARGE DELAYS TIMES AND EVENT COUNTERS ARE DISPLAYED INSUMMARIES AND EXCEPTIONS
PK72550
3_Mar
2009
UK44511


EXCEPTIONS REPORTED IN QUERY MONITOR MAY INCLUDE MULTIPLE SQL CALLS.
PK73505
3_Mar
2009
UK44511


SQLCODE -925 AND SQLCODE -926 MAY BE INCORRECTLY REPORTED IN THE ESQLCODE FIELD UNDER EXCEPTIONS AND CURRENT ACTIVITY
PK73784
26_Feb
2009
UK44394


MASS DELETE FROM DISTRIBUTED CONNECTION IS NOT CAPTURED, FOR DB2V9 INSTALLATIONS
PK78907
6_Feb
2009
UK43846


INCORRECT INTERVAL START DISPLAYED ON THE CAE GUI CLIENT
PK75606
6_Feb
2009
UK43844


DYNAMIC SQL FROM OP SUMMARIES VIA DB2 DRILL DOWN, INCORRECTLY PROMPTED - SSID AND VERS.MSG EXTRANEOUS INFORMATION WAS
RECVD.
PK77388
6_Feb
2009
UK43845


CQMC0001E UNABLE TO BIND TO ANY OF THE PORTS ON Z/OS 1.10
PK77581
5_Feb
2009
UK43807


CQM1050E INTEGRATED STORAGE MANAGER FAILURE DURING REQUEST FOR FREE SQLTEXT RC=008 RS=00052
PK74717
5_Feb
2009
UK43807


INCORRECT TRIGGERING OF AN ALERT OR EXCEPTION BASED ON GETPAGES
PK77436
5_Feb
2009
UK43807


CQM1050E FOR REAON=01, 02 OR 03
PK70002
5_Feb
2009
UK43807

HIPER

CQMMMETX ABEND WITH CQM1050E FOR RC=8 AND REASON=52. ALSO, MISSING DATA IN THE ISPF DISPLAYS OR ABENDSDC2 RC0045
PK73790
28_Jan
2009
UK43549


QUERY MONITOR MEXCW SUBTASK ABEND SYSTEM COMPLETION CODE=0C4 REASON CODE=00000011
PK77751
27_Jan
2009
UK43503


ABENDS0C4 RC04 WHEN TRYING TO VIEW HOSTV IN EXCEPTIONS
PK72030
23_Jan
2009
UK43427


CAE CLIENT-ONLY INSTALL DEFAULTS TO WRONG INSTALLATION FOLDER
PK76229
19_Jan
2009
UK43301
PK83359
HIPER

ROLLUP SUPPORT INTERNAL CHANGES TO COMMON CODE
PK76149
7_Jan
2009
UK42931


CAE AGENT SYSOUT TIME DOESN'T MATCH MVS TIME
PK78231
7_Jan
2009
UK42931


AE PK76149 FIX COMPLETION
PK76059
6_Jan
2009
UK42881


CQM132E INCORRECTLY ISSUED WHEN ACCESSING SQL TEXT AND HOST VARIABLE INFORMATION
PK74186
6_Jan
2009
UK42882


ABEND S032E RC 00000324 IN CQM#REST WHEN NO MONITOR PARM IS SPECIFIED IN CQMPARMS. ABENDS0C4 RC 00000004 IN CQM#REST
PK75811
10_Dec
2008
UK42348


PERFORMANCE ISSUES INVOLVING FETCH LOOPS IN AN AUDIT ONLY SETUP
PK74269
9_Dec
2008
UK42344

HIPER

ROLL-UP APAR FOR INTERNAL CHANGES
PK72113
9_Dec
2008
UK42344


ADD REQUIRED PARMS EXCPHSTV_DSN AND EXCPTEXT_DSN TO CQMPARMS
PK73648
9_Dec
2008
UK42344


CQM1033E UNABLE TO CREATE MASTER ADDRESS SPACE, MASTER TIMED OUT
PK75094
24_Nov
2008
UK41871


SQL CODE -104 WHEN INVOKING SQL/PA VIA QUERY MONITOR EXPORT SQL FUNCTION
PK74794
21_Nov
2008
UK41813

HIPER

QUERY MONITOR COLLECTOR HIGH CPU USAGE
PK74289
14_Nov
2008
UK41580


INFORMATION IN OPERATIONAL SUMMARIES MAY BE INCORRECT OR MISSINGALSO MSGS CQM1050E AND CQM1050E 09/01/12 PTF
PECHANGE
PK73957
13_Nov
2008
UK41562


#EXCP SUBTASK ABEND WITH SYSTEM COMPLETION CODE#EXCP SUBTASK SAC7-00080001, AND S878 ABEND MAY ALSO RESULT FROM STORAGE
LEAK
PK68149
13_Nov
2008
UK41562


DB2 QUERY MONITOR AGENT INSTALL FAILURE
PK71200
13_Nov
2008
UK41562


MESSAGE ID FEC804E BEING ADDED FOR THE WTO MESSAGE "SUBSYSTEM XXXX IS NOT CURRENTLY ACTIVE"
PK72434
13_Nov
2008
UK41562

HIPER

QUERY MONITOR ABENDS AFTER UPGRADING FROM V8 TO V9, OR FALLING BACK FROM V9 TO V8, WHILE CQM IS MONITORING DB2.
PK73460
7_Nov
2008
UK41440
PK74289

CQM1055E STORAGE CONSTRAINTS, CQM1050E RC=8, RSN=76
PK73118
5_Nov
2008
UK41366

HIPER

HOST VARIABLE INFORMATION MAY NOT BE COLLECTED WHEN MONITORING DISTRIBUTED WORKLOADS AT DB2 V9 LEVEL PK61670
PK69578
4_Nov
2008
UK41310


CANCELLED JOB MAY RESULT IN ABEND0C4 IN CQMMMFRR
PK69999
3_Nov
2008
UK41273


SQLCODE COLLECTION STOPS AFTER A PERIOD OF TIME
PK73133
29_Oct
2008
UK41163

HIPER

MESSAGE CQM1055E REASON=01000000 ISSUED WHEN MONITORING DISTRIBUTED WORKLOADS
PK73313
29_Oct
2008
UK41168

HIPER

ROLLUP APAR FOR INTERNAL CHANGES
PK70123
16_Oct
2008
UK40785

HIPER

ROLLUP APAR
PK66110
15_Oct
2008
UK40741

HIPER

INCREASED ELAPSED TIME AND HIGH CPU IN OPERATIONAL SUMMARIES FOR LOOP IN CQMMSSQX +X'CAA' OR +X'CA0' COUNTER IN CQMSDA
WRAPS
PK66115
15_Oct
2008
UK40741


DELAY INFORMATION ON OPERATIONAL SUMMARIES PANEL CQM$SU8P DOES NOT INCLUDE THE ASYNCH CF REQUESTS DELAYS.
PK71513
15_Oct
2008
UK40732


OVERRUN OF OBJECT COLLECTION HASH TABLE LEADS TO CQM1055E REASON=X'01000000' STORAGE CONSTRAINTS, ABEND S0878 MAY OCCUR
PK72515
15_Oct
2008
UK40741


DB2 QUERY MONITOR CPU USAGE INCREASE IN V2.3
PK69808
29_Sep
2008
UK40301


THE COLLECTION, CURSOR_NAME, AND CLIENT_ENDUSER FIELDS MAY BE INCORRECTLY TRANSLATED IN THE DB2 OFFLOAD.
PK71902
29_Sep
2008
UK40302


CAE AGENT LINKS INCORRECTLY WHEN BASE FUNCTION IS APPLIED ALONG WITHCURRENT MAINTENANCE
PK68526
19_Sep
2008
UK40026


CQM014E - INVALID COMMAND RECEIVED WHEN USING PRINTX FUNCTION
PK70521
11_Sep
2008
UK39785


GIM23901E LINK-EDIT PROCESSING FAILED FOR MODULE FECDAREA IN LMOD CQM@STXT IN THE SCQMLOAD
PK71083
11_Sep
2008
UK39784


NO DATA IN CURRENT ACTIVITY WHEN TIMEZONE OFFSET IS ZERO OR POSITIVE
PK70137
5_Sep
2008
UK39571


EXPECTED DATA MISSING FROM CURRENT ACTIVITY, WHEN MONITORING LIGHTLY LOADED DB2 SUBSYSTEM
PK70266
4_Sep
2008
UK39545


CQM153E - RETURN CODE 04 REASON CODE C300 WAS ENCOUNTERED DURINGTRANSLATION. SOURCE CCSID = 1208 TARGET CCSID = 37
PK65120
28_Aug
2008
UK39378


CQM CAE INTEGRATION WITH OPTIMIZATION SERVICE CENTER AND THE CAE CLIENT WILL NOT LAUNCH CORRECTLY
PK63669
25_Aug
2008
UK39249


GET PAGE REQUESTS FIELD IS BEING TRUNCATED ON BUFFER POOL STATISTICS DISPLAY
PK69639
18_Aug
2008
UK39044


CQM1055E WHEN DISABLE SUMMARY REPORTING SET. ALSO, SQLCODE -925 CAN OCCUR ON A STATEMENT WITH AN EXPLICIT COMMIT.
PK67345
4_Aug
2008
UK38653

HIPER

ABENDS0C4: ABND=0C4-00000011 DSNKSALO,M=DSNTFRCV
PK67952
4_Aug
2008
UK38655


WRONG LENGTH FOR MODULE CQM#CQMA LOADED INTO LPA
PK68439
4_Aug
2008
UK38655


S806 RC1C IN CQM$MAIN IF ONLY ONE LOADLIB IS DEFINED IN ISPLLIB STATEMENT OF STARTUP CLIST.
PK65042
14_Jul
2008
UK38096


SCQMSAMP MEMBER CQMCOMM DESCRIBE THE VALUES FOR OPTKEYS COLUMNS IN THE CQM22_INTERVALS TABLE AS "Y" FOR OPTKEYS SET IN
CQMPARMS
PK63505
14_Jul
2008
UK38096


ADD A NEW PARM TO THE OFFLOAD PROGRAM CQM@WDB2 TO PREVENT DUPLICATE RECORDS FROM BEING LOADED IN THE DB2 OFFLOAD TABLES
PK67031
30_Jun
2008
UK37751


CQM1055E DB2 QUERY MONITOR XXXX IS EXPERIENCING STORAGE CONSTRAINTS, DATA LOSS MAY OCCUR, REASON=80000000 DUE TO
EXCESS
PK66507
20_Jun
2008
UK37543


ROW_AFFECTED REPORTING COUNT OF 0 FOR SQL FROM DISTRIBUTED CONNECTIONS
PK66883
20_Jun
2008
UK37538


GENERATE MISMATCHED CQM 2.3 AND ADH 2.1 COLLECTOR MESSAGES AT STARTUP OF EITHER OF THE PRODUCTS' COLLECTORS.
PK66940
20_Jun
2008
UK37532


ENHANCED MESSAGES FOR RACF SECURITY ON CSVDYNLPA
PK64100
9_Jun
2008
UK37199

HIPER

S0C4 RC3B IN MODULE DSNXEET, S378 OR LOOP IN CQMMSQ81
PK66096
5_Jun
2008
UK37094

HIPER

HIGH CPU USAGE IN MAY OCCUR IN ALLIED ADDRESS SPACES DUE TO LOOPIN CQMISMPX
PK66182
2_Jun
2008
UK36987

HIPER

AUDIT DATA MAY NOT BE COLLECTED FOR TABLES IN FROM CLAUSE OF DELETE
PK63432
2_Jun
2008
UK36987


DB2 AUDIT MANAGEMENT EXPERT REPORTING GUI MISSING DELETES
PK65291
23_May
2008
UK36739

HIPER

DB2 QUERY MONITOR MMETR SUBTASK ABEND, ABEND 0C4 IN CQMMMETX MAYOCCUR
PK65576
21_May
2008
UK36648

HIPER

DYNAMIC TEXT MAY NOT BE DISPLAYED DUE TO CORRUPTED LOAD MODULE CQMTTEXX
PK62420
14_Apr
2008
UK35535

HIPER

STORAGE CONSTRAINT REASN=X'01000000' AND EXCESSIVE CPU WHEN DISABLE SUMMARY IS SET TO Y IN A PROFILE LINE MESSAGE
PK62651
14_Apr
2008
UK35536


EXCESSIVE NUMBER OF ALLOCATE CURSOR CALLS MAY BE REPORTED FOR CALLS ASSIGNED TO SECTION ZERO
PK62874
14_Apr
2008
UK35536


ABEND S0C4-00000011 WHEN VIEWING HOST VARIABLES IN CURRENT ACTIVITY PANEL. DELAY COUNTS MAY BE INFLATED FOR DISTRIBUTED
PK61758
13_Mar
2008
UK34562

HIPER

ISPF/ GUI AND COLLECTOR CODE UPDATES

Top of page