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: 18 June 2025
DB2 Query Monitor Version 3.4
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH66277
11_Jun
2025
UO03601


CQM1026E SHARED MEMORY FAILURE FOR OBJECT CQMDATA DURING LIST SHARED REQUEST, RC=004, RS=00000000
PH66353
11_Jun
2025
UO03601


PA LINE COMMAND FOR COLLECTIONS AND PACKAGES
PH66354
11_Jun
2025
UO03601


SHOW COMMIT/ROLLBACK COUNTERS FOR INTERVALS AND OPERATIONAL SUMMARIES
PH66355
11_Jun
2025
UO03601


ALWAYS SHOW ALL AVAILABLE OPTIONS ON 'SELECT SUMMARY LEVEL' PANEL
PH66400
11_Jun
2025
UO03601


ODP PUBLISHING IS NOT HONORING THE EXCEPTIONS LIMIT
PH66593
11_Jun
2025
UO03601


EXCESSIVE CPU USAGE WHEN INFLIGHT(Y) IS SPECIFIED IN CQMPARMS
PH66619
11_Jun
2025
UO03601


MISCELLANEOUS FIXES
PH65636
27_May
2025
UO03394


%ZIP IS NOT CALCULATED CORRECTLY.
PH66119
27_May
2025
UO03394


MISCELLANEOUS FIXES AND UPDATES
PH66204
27_May
2025
UO03394


DIAGNOSTIC IMPROVEMENTS
PH66093
23_May
2025
UO03360


MISC CAE MAINTENANCE
PH64557
14_Apr
2025
UO02810


CQM1213W MAY OCCUR FOR SQLCD WHEN LARGE VALUE IS SPECIFIED FOR MAX_SQLCODE_DETAIL
PH65295
14_Apr
2025
UO02810


Add new column to display standard CPU time (GP)
PH65325
14_Apr
2025
UO02810


MAPPING UPDATES FOR ODP
PH65384
14_Apr
2025
UO02810


NATIONAL CHARACTERS ARE NOT HANDLED CORRECTLY IN THE OFFLOAD ANDIN THE ABBREVIATED SQL STATEMENTS IN WEB INTERFACE
PH65433
14_Apr
2025
UO02810


MESSAGE CQMC2052E OCCURS WHEN SELECTING SQL TEXT FOR A NEGATIVE SQLCODE DETAIL FROM THE ISPF INTERFACE.
PH65470
14_Apr
2025
UO02810


ALLOW ADDING NOTES TO INTERVALS
PH65471
14_Apr
2025
UO02810


ALLOW SETTING EXCEPTIONS AND ALERTS THRESHOLD FOR DELAYS.
PH65472
14_Apr
2025
UO02810


DISPLAY METRICS FOR ACCELERATOR FETCHED ROWS.
PH64618
28_Feb
2025
UO02287


IBM DB2 ADMINISTRATION TOOL INTEGRATION DOES NOT WORK CORRECTLY WITH MIXED CASE NAMES.
PH64753
28_Feb
2025
UO02287


IMPROVED MAINTENANCE MISMATCH CHECK
PH64985
28_Feb
2025
UO02287


CQM8004E FOR 5-DIGIT HOSTVAR_LIMIT VALUES
PH65150
28_Feb
2025
UO02287


MINOR IMPROVEMENTS, PREPARATION FOR FUTURE ENHANCEMENTS
PH64763
31_Jan
2025
UI99840


IMPROVEMENTS FOR DB2 REORG AVOIDANCE FEATURE
PH64700
29_Jan
2025
UI99773


MINOR FIXES AND UPDATES
PH64703
29_Jan
2025
UI99773


LAUNCH IBM DB2 ADMINISTRATION TOOL FROM IBM DB2 QUERY MONITOR FOR CURRENT ACTIVITY AND EXCEPTIONS
PH64708
29_Jan
2025
UI99773


NEW PRIMARY COMMAND VIEW FOR SQL STATEMENTS
PH63888
3_Dec
2024
UI99251


NOV 2024 CAE ENHANCEMENTS
PH63877
27_Nov
2024
UI99218


TRUNCATED STATIC SQL TEXT FROM CAE SERVER.
PH63911
27_Nov
2024
UI99218


CQM1048E ERROR DURING THE OFFLOAD
PH63850
27_Nov
2024
UI99218


INCREASE GETPAGES LIMIT
PH63913
27_Nov
2024
UI99218


PRODUCT IMPROVEMENTS
PH63914
27_Nov
2024
UI99218


MINOR FIXES
PH63015
25_Oct
2024
UI98883


ABSTRACT: NOCLASSDEFFOUNDERROR WHEN IMPORTING CERTIFICATES
PH63274
25_Oct
2024
UI98883


REDUCE EXTRANEOUS SECURITY MESSAGING
PH63437
25_Oct
2024
UI98883


FORMAT THE SQL STATEMENT UNDER TSO/ISPF
PH63438
25_Oct
2024
UI98883


LAUNCH IBM DB2 ADMINISTRATION TOOL FROM IBM DB2 QUERY MONITOR
PH63439
25_Oct
2024
UI98888


Description not available. Security/Integrity exposure
PH63441
25_Oct
2024
UI98889


Description not available. Security/Integrity exposure
PH63486
25_Oct
2024
UI98883


REDUCE CPU IN QUERY MONITOR ADDRESS SPACE
PH62563
24_Sep
2024
UI98507

HIPER

RECOVERY LOOP IN CQMMZIIP
PH62994
24_Sep
2024
UI98507


MINOR INTERNAL FIXES
PH62068
23_Sep
2024
UI98507


ABEND0C4-38 IN CQMMZIIP+X'1F38'
PH62494
23_Sep
2024
UI98507


MSGCQM1217W WHEN QM 3.4 RUNS IN ZIIP OFFLOAD MODE
PH62480
23_Sep
2024
UI98507


INCOROUT LOW CPU TIMES IN CURRENT ACTIVITY FOR STATEMENTS WITH ALOT OF FETCH CALLS
PH61658
24_Jul
2024
UI97776


REDUCE CPU IN QM ADDRESS SPACE WHEN RUNNING ZIIP OFFLOAD MODE
PH62022
24_Jul
2024
UI97776


ABEND0C4-4 IN CQMMEXCX+D22C WHEN THE NUMBER OF HOSTVAR COLLECTEDIS GT 8192
PH61872
24_Jul
2024
UI97776

HIPER

ABEND0C4-11 IN CQMMZIIP+X'388E' ABEND0C1 IN CQMMZIIP
PH62285
24_Jul
2024
UI97776


ELONGATED SHUTDOWN FOR QUERY MONITOR
PH60500
19_Jun
2024
UI97342


KQQJSTPS MISSING. SDA=Y
PH61073
14_Jun
2024
UI97342


CQM1153E RETURN CODE 04 WHEN RUNNING CQM OFFLOAD (S0C4 - 0C)
PH60877
14_Jun
2024
UI97342


NOT ALL OBJECT/OPERATIONAL FILTERS ARE APPLIED CORRECTLY IN OPERATIONAL/STRUCTURAL VIEWS
PH61069
14_Jun
2024
UI97342


ADD ODP CONFIGURATION PARAMETERS TO TCZ
PH60910
14_Jun
2024
UI97342


AUTHENTICATION FAILURE, CAE USERNAMES THAT INCLUDE SPECIAL/NATIONAL CHARACTERS
PH61680
14_Jun
2024
UI97342


DEFECT FIXES AND SERVICEABILITY IMPROVEMENTS
PH61630
14_Jun
2024
UI97342


DB2_SUBSYSTEM COLUMN OF CQM_SUMM_OBJECTS OFFLOAD TABLE MAY CONTAIN X'00000000' VALUE AFTER THE OFFLOAD
PH61499
14_Jun
2024
UI97342


WRONG INTERVAL START DATA IS DISPLAYED AFTER LEAVING CQM$INTV FOR SQLCODES VIEW
PH60660
20_May
2024
UI96961


UDF SCHEDULE DELAY VALUES, UDF_SCHED_DLY ARE INCORRECT AND AMPLIFIED
PH60433
20_May
2024
UI96961


MINOR DEFECT FIXES AND SERVICEABILITY IMPROVEMENTS
PH60779
20_May
2024
UI96961


GENERATED JOB C4C2LST IS MISSING PART OF THE IF STATEMENT
PH60749
20_May
2024
UI96961


NO DETAILS MAY BE DISPLAYED ON SQL CODE SUMMARY PANELS FOR DBRM/PACKAGE
PH61185
20_May
2024
UI96961


EXAGGERATED CPU VALUES FOR FETCH INTENSIVE WORKLOADS
PH59692
9_May
2024
UI96827


MINOR CAE DEFECTS. SUPPORT FOR JAVA 17.
PH59691
9_May
2024
UI96827


SUPPORT JAVA 17
PH60535
25_Apr
2024
UI96679

HIPER

ABEND0C4-38 IN CQM#UNIT+X'199C' CQM2009E
PH59517
23_Feb
2024
UI95793


BAD PROGRAM NAMES GENERATED FROM DISTRIBUTED COMMIT/ROLLBACKS CQM1153E RETURN CODE 04 IN OFFLOAD BATCH JOB.
PH59464
23_Feb
2024
UI95793


EXAGGERATED CPU VALUES FOR FETCH INTENSIVE WORKLOADS
PH58981
23_Feb
2024
UI95793


WRONG PROFILE LINE ASSIGNED WHEN WORKSTATION FIELDS CHANGE
PH58957
23_Feb
2024
UI95793


MINOR INTERNAL DEFECTS.
PH57073
30_Jan
2024
UI95488


OPTIMIZE INTERVAL COMMAND PROCESSING IN DSGS
PH58452
30_Jan
2024
UI95488


MINOR 3.4.0 DEFECT FIXES
PH57923
22_Nov
2023
UI94566


REQUIRED MAINTENANCE FOR QUERY MONITOR 3.4.0 GA

Top of page