|
DB2 Query Monitor Version 2.1
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2007 |
DB2 WLM ADDRESS SPACE ABEND MAY OCCUR WHEN STOPPING QM COLLECTOR, S0C4, S0C1, U4087 ARE POSSIBLE | ||||
2007 |
CQM CAE LOGIN FROM LAPTOP CLIENT TO DESKTOP SERVER CAN OFTEN HANG ON "VALIDATING LOGIN" | ||||
2007 |
CAE AGENT JAR UPGRADE FOR DAYLIGHT SAVING TIME JAR COMPATIBILITY DST2007 | ||||
2007 |
UPGRADE WORKSTATION JAVA SDK/JRE FOR ADJUSTMENTS TO THE US DAYLIGHT SAVINGS CHANGES IN MARCH 2007, DST2007 | ||||
2007 |
INCREASED STORAGE GROWTH IN SP230 KEY7 WITHIN THE QM ADDRESS SPACE ASSOCIATED WITH DISTRIBUTED WORKLOADS | ||||
2006 |
SQLCODE -925, ABEND878-10 IN QM ADDRESS SPACE | ||||
2006 |
HIGH CPU USAGE IN APPLICATIONS | ||||
2006 |
MESSAGE CQM1153E RETURN CODE 04 REASON CODE 07 INCORRECTLY ISSUED | ||||
2006 |
VIEWING SQL TEXT RESULTS IN A CQM145I MESSAGE WHEN THE CODEPAGE IS 1141 AND THERE IS AN @ IN THE PROGRAM NAME. | ||||
2006 |
LATENT QM CODE REMOVAL. | ||||
2006 |
MSGCQM145E GENERATED WHEN PROGRAM NAMES CONTAIN THE '@' CHARACTER WHEN THE USER'S TERMINAL CCSID IS 1141 OR 273 | ||||
2006 |
ABEND0C4 CQM@WDB2+028020 WHEN SPECIFYING DATA PARM IN CQMPARMS | ||||
2006 |
MESSAGE CQM153E INCORRECTLY DISPLAYED WHEN PERFORMING SOME CCSIDCONVERSIONS | ||||
2006 |
MSGCQM2001E RECEIVED WHEN ATTEMPTING TO MONITOR A DB2 SUBSYSTEM. | ||||
2006 |
ABEND S0C4 CAN OCCUR IN MODULE CQMMHSTV | ||||
2006 |
ADD VERIFICATION FOR 500-1208, 1208-500 CCSID PAIRS UPON STARTUP. STARTUP WILL TERMINATE IF THESE CCSIDS ARE MISSING. | ||||
2006 |
EXCESSIVE CPU USE WHILE COLLECTING OBJECT DATA | ||||
2006 |
ABEND0C4 RC11 IN MODULE CQMMSQ71 CAUSES TEMPORARY SPIKE IN CPU USAGE | ||||
2006 |
INVALID CONTINUATIONS GENERATED FOR EXPORTED SQL TEXT. | ||||
2006 |
A WORK LIST ABENDU4ED CAN OCCUR IN THE CQM DATA COLLECTOR | ||||
2006 |
DRAIN LOCK DELAY EVENT COUNTS MAY BE INACCURATE. | ||||
2006 |
CQM INCORRECTLY COMBINING NEGATIVE SQLCODES LEADING TO INCORRECTEXCEPTION OR ALERT PROCESSING | ||||
2006 |
DB2 MAY APPEAR TO HANG DUE TO ABEND S0C4 WHILE ISSUING TIMEUSED FROM CQMMESQL 06/04/04 PTF PEREMOVE |
||||
2006 |
LOOP IN CQMMEXCW AT OFFSET X'645A' | ||||
2006 |
CQM V2.1 - D6690 - DEFECTS IN THE SUPPLIED SAMPLE LIB FOR NEW OFFLOAD | ||||
2006 |
CQMCAE MEMBER IN SAMPLIB IS VERSION SPECIFIC WHERE COMPATIBILITYWITH MULTIPLE VERSIONS IS POSSIBLE | ||||
2006 |
S0C4 ABEND AT OFFSET X'8DE' IN MODULE CQM#SSMN | ||||
2006 |
AFTER A DB2 SUBSYSTEM IS RECYCLED, CURRENT ACTIVITY AND EXCEPTIONS MAY NO LONGER BE DISPLAYED | ||||
2006 |
S0C4 ABEND IN MODULE COPYMEM OR ABEND U1002 | ||||
2006 |
UPON SHUTDOWN/RESTART, CQM DOES NOT RECOGNIZE THE LAST INTERVAL WRITTEN TO THE BACKSTORE. | ||||
2006 |
GRAPHICS ARE NOT DISPLAYED, IN THE HELP TOPICS PANEL, IN CLIENT ONLY INSTALL | ||||
2006 |
UNPRINTABLE ( GARBLED ) CHARACTERS APPEAR IN THE STRUCTURAL USAGE PANEL CQM$SU8Q | ||||
2006 |
CAE AGENT HAS TROUBLE STARTING WHEN HOST CHANGES IP ADDRESS OFTEN | ||||
2006 |
S0C4 ABEND ON MODULE CQMOXG81 AT OFFSET X'04BA' | ||||
2006 |
S0C4 ABEND IN MODULE CQM#QAPI | ||||
2006 |
S0C4 ABEND IN MODULE CQMTTGET WHEN VIEWING SQL TEXT THAT IS NO LONGER AVAILABLE | ||||
2006 |
POTENTIAL S0C6 ABEND IN MODULE CQMOXG81 | ||||
2005 |
CORRECT CODE TO HONOR EXISTING VIEWS AND ALLOW SORTING BY SQL TEXT. | ||||
2005 |
EXCEPTION CALL LEVEL TEXT GENERATED VIA DB2 V8 MAY BE GARBLED | ||||
2005 |
CQM153E - RETURN CODE 04 REASON CODE 000C DUE TO CCSID HANDLING FOR JDBA PROBLEM | ||||
2005 |
UNDISPLAYABLE CHARACTERS IN QM (ACTIVITY BROWSER AND MESSAGE DETAILS) SCREENS. | ||||
2005 |
IF RESTARTED QUICKLY, QM MAY ATTEMPT TO REALLOCATE THE SAME DATASET AND FAIL. | ||||
2005 |
POTENTIAL INCONSISTENCY IN THE NUMBER OF NEGATIVE SQLCODES REPORTED ON THE EXCEPTION PANEL VERSES THE VIEW SQLCODES PANEL. |
||||
2005 |
NEW UTILITY TO ALLOW USERS TO EASILY REPRO THE BACKSTORE DATASETS FOR DIAGNOSTIC PURPOSES | ||||
2005 |
POTENTIAL S0C9-00000009 ABEND WHEN RUNNING CQM V2.1 ON Z/OS V1.7 | ||||
2005 |
UPON BACKSTORE DATASET ALLOCATION FAILURE, CLEANUP ROUTINES CAN POTENTIALLY LEAVE "RESIDUAL" BACKSTORE DATASETS. | ||||
2005 |
HIGH CPU USAGE BY QUERY MONITOR COLLECTOR TASK WHEN ENCOUNTERINGLONG-RUNNING UNIT-OF-WORK. POTENTIAL LOOP OR HANG | ||||
2005 |
QUERY MONITOR MAY DISPLAY EXCESSIVE CPU VALUES FOR STATEMENTS THAT END WITH SQLCODE -905. | ||||
2005 |
POSSIBLE ISSUE OF WHICH CANCELING A THREAD MAY CAUSE DB2 TO HANG. | ||||
2005 |
POTENTIAL S0C4 ABEND IN MODULE CQMTTXTW AT OFFSET X'1A1A' (LEVEL10/24/05 12.52): RESULTS IN TERMINATION OF THE STARTED TASK. | ||||
2005 |
ERROR MESSAGE CQM145I DISPLAYED WHEN ATTEMPTING TO VIEW SQL TEXTVIA CURRENT ACTIVITY PANEL CQM$ACTA | ||||
2005 |
QM NOW BREAKS ON SPECIFIC SQL TEXT CLAUSES E.G. WHERE, FROM ETC.IN THE QM EXPORT DATASET | ||||
2005 |
HOST VARIABLE TYPE REAL AND DOUBLE ARE NOT DISPLAYED IN CQM$HST8PANEL - INPUT HOST VARIABLES | ||||
2005 |
TYPE FIELD IS BLANK AFTER DRILL-DOWN INTO LOCK STATISTICS PANEL | ||||
2005 |
IN OPERATIONAL SUMMARIES, UNKNOWN SQL TYPE IS DISPLAYED FOR DECLARE GLOBAL TEMPORARY TABLE | ||||
2005 |
CORRECT POTENTIAL LOOP IN DB2 PRECEDED BY LOOPING IN MODULES CQMMSQ71 OR CQMMSQ81 | ||||
2005 |
GUI CAE INTERVAL SELECTION HAS ROUNDING PROBLEMS | ||||
2005 |
MSGCEE3204S (S0C4) FROM COMPILE UNIT /U/SOVBLD/CM1411SR2A/CM1411SR2A-20040515/SRC/JVM/SOV/CI/JNI.C EP JNI_SETPRIMITIVEARRAYREGIO |
||||
2005 |
CAE SERVER OUTOFMEMORYERROR | ||||
2005 |
WHEN VIEWING PROFILES AND CONFIGURATIONS PANELS, USER ROLE VALUES ARE NOT BEING DISPLAYED. | ||||
2005 |
THE CQM CLIENT IS ERRONEOUSLY POSTING NEGATIVE VALUES IN THE EXCEPTIONS %UAT FIELD. | ||||
2005 |
INCORRECT EXCEPTION AND ALERT PROCESSING FOR LONG RUNNING SQL TASKS. | ||||
2005 |
CODE WILL BE UPDATED IN MODULE CQMMMETR TO ADDRESS A LOOPING ISSUE | ||||
2005 |
CANCEL THREAD OPERATION CAN RESULT IN LOOP IN MODULE CQMMEXCP. | ||||
2005 |
S0C4-04 ABEND IN MODULE CQMMSQL AT OFFSET X'811A' | ||||
2005 |
POTENTIAL S878-10 ABEND DUE TO INCREASED SP230 KEY 7 STORAGE UTILIZATION IN THE CQM ADDRESS SPACE. | ||||
2005 |
CQM MAY INADVERTENTLY BYPASS THE MONITOR PROFILE FOR A WORKLOAD. | ||||
2005 |
QM OFFLOAD ABENDS WITH -873 WHEN RUNNING ON DB2 V8 COMPATIBILITYMODE. | ||||
2005 |
QM OFFLOAD PROCESS MAY ISSUE MESSAGES DSNU338I AND DSNU017I - FOLLOWED BY S04E ABEND IN OFFLOAD - REASON X'00E40323'. | ||||
2005 |
MSGCQM162E BEING REPLACED WITH NEW, MORE DESCRIPTIVE MSGCQM250E "AUTHORIZATION FAILURE IN TARGET DB2 SSID" | ||||
2005 |
QUERY MONITOR STARTED TASK MAY HAVE HIGH MEMORY CONSUMPTION | ||||
2005 |
ABENDS0C4-11 CAN OCCUR IN MODULE CQMTTXTW AT OFFSET X'1710'. | ||||
2005 |
WRITE ATTEMPTS MADE TO TEXTDATA BACKSTORE DSN WHEN OUT-OF-SPACE CONDITION EXISTS. ERROR MSG IEC070I OCCURS ON EACH ATTEMPT. | ||||
2005 |
QUERY MONITOR DISPLAYS EXCESSIVE CPU VALUES FOR SOME STATEMENTS THE CQM OFFLOAD FAILS WITH A -433 SQL CODE. ( SQLCODE433 ) | ||||
2005 |
S0C1 ABEND IN MODULE CQMMESQL AT OFFSET X'350' | ||||
2005 |
HIGH CPU CONSUMPTION CAN OCCUR DUE TO POTENTIAL LOOP IN MODULE CQMMEXCW | ||||
2005 |
ADD CONVERSION SERVICES MESSAGING TO CQM#WDB2 | ||||
2005 |
LOWER-CASE DATA ENTERED IN SPECIFIC FIELDS ON PANEL CQM$PR8U ERRONEOUSLY CONVERTED TO UPPER-CASE. | ||||
2005 |
S0C1 ABEND OCCURS FOLLOWING A S878-10 ABEND IN MODULE CQMOXGET | ||||
2005 |
DISPLAY OF OBJECTS BY SQL VARIES WHEN SELECTING MULTIPLE INTERVALS | ||||
2005 |
CQM ISPF MEMORY EXHASUSTED WHEN VIEWING A LARGE AMOUNTS OF SQL TEXT IN SUMMARIES | ||||
2005 |
AE PK07148 | ||||
2005 |
REDUCE CPU CONSUMED BY QUERY MONITOR | ||||
2005 |
OBJECT STATISTICS FOR LONG-RUNNING SQL STATEMENTS MAY NOT BE DISPLAYED. | ||||
2005 |
LARGE MEMORY ALLOCATIONS AFTER APPLYING PK06344/UK04836 | ||||
2005 |
AN ABEND CAN OCCUR IN CQMMSQ71 DUE TO A CONTROL BLOCK OVERLAY | ||||
2005 |
PROHIBIT STARTUP WHEN OBSOLETE CQMPARM FORCE(M) SPECIFIED. ERROR MSGS CQM2101E & CQM2110E WILL ACCOMPANY THE STARTUP FAIL |
||||
2005 |
CORRECTIVE APAR FOR JCLIN ISSUE. MSGGIM23911E AND MSGIEW2470E MODS CQMMEXCN AND CQM@ITX6 ON BULK PTF APPLY. | ||||
2005 |
0C4-10 CQMOXG81, RUNNING ON DB2 V8 | ||||
2005 |
QM ABENDS INTERNALLY WITH ABENDS0C4 CQMOXGET +43E | ||||
2005 |
GARBLED TEXT DISPLAYED IN QM FOR DYNAMIC SQL TEXT OR CQM153E RC 4 RS C | ||||
2005 |
HOST VARIABLE DISPLAY PROBLEM, SEEMS TO BE ASCII. | ||||
2005 |
STORAGE LEAK IN HOST VARIABLE COLLECTION | ||||
2005 |
SOC4 ERROR IN DSNAPRHX WHEN RUNNING QUERY MONITOR, WITH FORCE(M)ENABLED, TOGETHER WITH STROBE | ||||
2005 |
QUERY MONITOR TO REDUCE MEMORY CONSUMPTION IN DATASPACES | ||||
2005 |
HELP FOR MESSAGE CQM149E REFERS TO INCORRECT MANUAL. | ||||
2005 |
VIEW OBJECT NAME EMPTY IN GUI WHILE DISPLAYED AS N/A IN ISPF | ||||
2005 |
MSG CQM7003E COLUMN VAR# MISSING FOR TABLE EXCEPTION HOSTV | ||||
2005 |
0C4-4 IN TTXTW SUBTASK | ||||
2005 |
CQM153E ON DISTSERV THREADS | ||||
2005 |
IKJ56702I INVALID VALUE FOR KEYWORD , V R INVOKING DB2 SQL/PAFROM DB2 QUERY MONITOR R210 | ||||
2005 |
PAGE FROM INTERVAL TO INTERVAL WITHOUT GOING TO INTERVAL SELECTION PANEL. | ||||
2005 |
EXPORTED ROWS TO EXCEL SHOW INCORRECTLY DUE TO USE OF COMMAS AS DECIMAL DELIMITERS | ||||
2005 |
CQM153E RC08 RS03 CCSID TRANSLATION ERROR WHERE INDIRECT CONVERSION PAIRS ARE DEFINED | ||||
2005 |
ABENDS378 RC24 IN MODULE CQMMFREE | ||||
2005 |
LOGREC MESSAGE "S00D6" IS GENERATED IN ERROR AFTER QM IS STOPPED. | ||||
2005 |
CURRENT ACTIVITY IS OVERSTATED. | ||||
2005 |
ABEND0C4 IN DSN3AB00+14C OCCURS IN DB2 CAUSED BY CQMMAB71 DURING-913 | ||||
2005 |
WHEN QM AND OMEGAMON ARE MONITORING THE SAME DB2 SSID(S), ABEND U3590 OR RC00E40030 CAN OCCUR. | ||||
2005 |
PANEL CQM$EXCA - THE 1ST SQL STATEMENT IN A SERIES IS ASSOCIATEDWITH THE WRONG SQL CODE | ||||
2005 |
S0C4 POSSIBLE IN MODULE CQM$FILT FROM ACTIVE FILTERS PANEL WHEN DELETING FILTERS FROM THE ACTIVE FILTERS PANEL | ||||
2005 |
PANEL CQM$SQCM INCORRECTLY DISPLAYS ISPF TABLE OF NEGATIVE SQL CODES | ||||
2005 |
Incorrect elapsed time in exceptions with SPTR Directory | ||||
2005 |
QUERY MONITOR V2.1 STROBE V3.1 CANNOT BE ACTIVE AND MONITORING THE SAME SUBSYSTEMS AT THE SAME TIME | ||||
2005 |
INCORRECT GET PAGE TOTAL IN CURRENT ACTIVITY AND ALERTS | ||||
2005 |
PANEL CQM$QLCA - "COLL" FIELD CAN DISPLAY INCORRECT VALUE. | ||||
2005 |
HOST VARIABLE NODES NOT RELEASED IN QM DATASPACES CAN RESULT IN HIGH STORAGE USAGE | ||||
2005 |
ADD SUPPORT FOR VOLSER IN SPECIFYING BACK STORE DATA SETS IN NON-SMS ENVIRONMENTS | ||||
2005 |
NEW CATALOG_OBJECTS PARM: ALLOWS REDUCTION IN DATASPACE STORAGE PER INTERVAL BY REDUCING OBJ DETAILS FOR PREPARE SQL CALLS. | ||||
2005 |
LINK-EDIT PROCESSING FOR SYSMOD UQ93292 FAILED FOR MODULE CQM3MSTB WHEN APPLYING UQ93292 AND UQ95223 TOGETHER | ||||
2005 |
DATABASE LIST IS INCONSISTENT IN ACTIVITY SUMMARIES; STATIC STORED PROCEDURE TEXT SHOWS UNAVAILABLE CQM145I | ||||
2004 |
INSTALL ON WINDOWS 2003 SERVER FAILS | ||||
2004 |
CAE CLIENT ALERT BROWSER TIMESTAMPS ARE DIFFERENT FROM PC AND HOST TIMES. | ||||
2004 |
DB2 QM CAE CLIENT SHOWING WRONG TIME ON ALERTS | ||||
2004 |
QUERY MONITOR DOES NOT ACCEPT JDK VERSION 1.4.2 IN USS ON Z/OS | ||||
2004 |
CUSTOMERS SHOULD EDIT CQMPARMS AND START QM WITH NO OPTKEYS PARAMETER. | ||||
2004 |
CQM R210 MSGCQM2604E VSAM LOGIC ERROR, ABEND U2604 IN CQMMEXCW WITH LONG VARCHAR HOST VARIABLE | ||||
2004 |
S0C4 ABEND IN CQMMMETR | ||||
2004 |
SQL TEXT FOR ASCII DB2 SUBSYSTEM DISPLAYED INCORRECTLY | ||||
2004 |
HOST VARIABLES ON ASCII DISPLAYED INCORRECTLY | ||||
2004 |
S878 IN CQM@LDB2 WHEN LOADING MULTIPLE PARTITIONS | ||||
2004 |
MSGCQM244E ERROR MESSAGE DISPLAYED WHEN RUNNING DB2 QUERY MONITOR R210 | ||||
2004 |
AE PQ92223 | ||||
2004 |
THIS APAR WILL INCORPORATE CODE FIXES FOR A NUMBER OF ISSUES AGAINST CQM V2.1 (COMPID 5655-E6701 /FMID H238210/ PGM 5697-I03) |
||||
2004 |
S0C4 ABEND IN CQMTTXTW AT OFFSET 16F8 DURING SHUTDOWN | ||||
2004 |
QUERY MONITOR STC ABENDSA78 AFTER APPLYING UQ93869 | ||||
2004 |
CQMPROC - STORAGE LEAK WHEN SQL WORKLOAD INCLUDES DYNAMIC SQL, QUERY MONITOR STC MSGIRA200E AUXILIARY STORAGE SHORTAGE, WAIT | ||||
2004 |
WITH DATA COLLECTOR RUNNING, A S322 ABEND CAN OCCUR IN A BATCH JOB THAT CONTAINS A HEAVY DYNAMIC SQL WORKLOAD | ||||
2004 |
CQM V2.1 INITIAL CORRECTIVE SERVICE | ||||
2004 |
CQM DB2 Plan Excluded in profile still appears in Summaries | ||||
2004 |
QM is understating both synchronous and other i/o delay times in comparison with SMF data. | ||||
2004 |
PANEL CQM$TEXT SHOWS INCORRECT CURSOR NAME | ||||
2004 |
allow manual define of VSAM file w/o SMS control | ||||
2004 |
CQM6102E SCRATCH FAILED | ||||
2004 |
No exceptions in Alert Browser, exceptions do show in ISPF | ||||
2004 |
Client GUI has mismatched ( incorrect ) Timestamps | ||||
2004 |
ABEND S0C4-10 DURING DELETE OF PROFILES | ||||
2004 |
ISPF error ISPP178 occurs when user inputs a large number in field 'Workload Name' in panel CQM$PR8N | ||||
2004 |
'Exclude filtered data' filter function not working when viewing DB2 commands (panel CQM$DB2C). | ||||
2004 |
PANELS CQM$PR8U AND CQM$PR8V - PFSHOW ON CAN PREVENT VIEW/EDIT OF LAST LINES IN MONITOR PROFILE | ||||
2004 |
PANEL CQM$PR8U, CQM$PRFU , NO WARNING THAT CHANGES ARE NOT SAVED IF USER DOES NOT PRESS ENTER BEFORE EXIT | ||||
2004 |
0C4 WHEN PROFILE CREATED AND ACTIVATED WITH NAME THAT DID NOT EXIST BUT PROFILE NAME WAS IN CQMPARMS AT STARTUP | ||||
2004 |
CAEAGENT JCL CANNOT PROVIDE A STEPLIB VARIABLE WITH MORE THAN 72CHARACTERS | ||||
2004 |
Size Limitation of CQM VSAM file names | ||||
2004 |
SQLCODE811 ( -811 ) in option S(SQL) in summary activity | ||||
2004 |
'No agent for action' for command actions using TCSH script type | ||||
2004 |
Query Monitor DB2 offload feature | ||||
2004 |
No 'DB2 ssid' displayed when view lock statistics in cqm$su8p | ||||
2004 |
Display overlay for host variables in display | ||||
2004 |
GUI DOES NOT RESPOND TO A REQUEST FOR HELP MADE WITH THE F1 KEY | ||||
2004 |
DSNTIAR TEXT MISSING IF SQL EXECUTED VIA CONNECT EXTERNAL SYMPTOM CODE | ||||
2004 |
Statement Descriptions incorrect in DB2 v8 | ||||
2004 |
Exclude -SQLCODE by program not functioning in profile | ||||
2004 |
select filter from a saved dataset may cause error error message CQM231E in some cases | ||||
2004 |
ENTERING NEXT ON PREVIOUS SQL CODE VIEWING INTERVAL JUMPS TO CURRENT | ||||
2004 |
TEXTD OPEN GETS IEC161I 052(011)-084 WHEN SHROPTIONS NOT (3,3) | ||||
2004 |
Incorrect Object Names on DROP | ||||
2004 |
CPU, ELAP, and DELAY time display fields expanded to allow display of 6 digits to the right of the decimal point | ||||
2004 |
cae_agent_exec reference non-existant jar | ||||
2004 |
high cpu utilization, storage problems | ||||