|
DB2 Query Monitor Version 2.2.1
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2010 |
ABEND0C4-4 ABEND0C4 AT CQMOXG81+X'2408' | ||||
2010 |
INCORRECT DATA WHEN HOST VARIABLE IS NULL | ||||
2009 |
CQM@ITXT ABEND=S0C4 U0000 REASON=00000004 | ||||
2009 |
INFLATED CPU TIME DISPLAYED FOR STORED PROCEDURES | ||||
2009 |
DELAY TIMES AND/OR ELAPSED TIMES MAY BE INFLATED WHEN ASYNCHRONOUS CF DELAYS ARE PRESENT | ||||
2009 |
GETPAGES DISPLAYED IN DB2 QUERY MONITOR OPERATIONAL SUMMARIES MAY BE INCORRECT | ||||
2009 |
CQM2603E DE-ALLOCATION FAILED FOR DATASET, CQM1500E ABNORMAL EOTFOR CQMMCMDW SUBTASK | ||||
2009 |
ABEND0C4-38 CQMOXG81+ED0 | ||||
2009 |
ABENDS04F U0000 REASON 00000000, DSNV086E - SSID DB2 ABNORMAL TERMINATION REASON 00D94001 | ||||
2009 |
ABEND0C4 RC10 CQMMSTRM +X'2878' 09/04/30 PTF PECHANGE |
||||
2009 |
CQM1153E RETURN CODE 08 REASON CODE 03 SOURCE CCSID = 63456 TARGET CCSID = 1208, FEC801E OR SQLCODE180 | ||||
2009 |
INCORRECT LARGE DELAYS TIMES AND EVENT COUNTERS ARE DISPLAYED INSUMMARIES AND EXCEPTIONS | ||||
2009 |
HOST VARIABLE INFORMATION MAY NOT BE COLLECTED WHEN MONITORING DISTRIBUTED WORKLOADS AT DB2 V9 LEVEL PK61670. | ||||
2009 |
SQLCODE -925 AND SQLCODE -926 MAY BE INCORRECTLY REPORTED IN THE ESQLCODE FIELD UNDER EXCEPTIONS AND CURRENT ACTIVITY | ||||
2009 |
QUERY MONITOR MEXCW SUBTASK ABEND SYSTEM COMPLETION CODE=0C4 REASON CODE=00000011 | ||||
2009 |
ROLLUP SUPPORT INTERNAL CHANGES TO COMMON CODE | ||||
2009 |
INCORRECT TRIGGERING OF AN ALERT OR EXCEPTION BASED ON GETPAGES | ||||
2009 |
ABEND0C4 IN MODULE CQMOXG81 | ||||
2008 |
SQL CODE -104 WHEN INVOKING SQL/PA VIA QUERY MONITOR EXPORT SQL FUNCTION | ||||
2008 |
EXCEPTIONS REPORTED IN QUERY MONITOR MAY INCLUDE MULTIPLE SQL CALLS. | ||||
2008 |
ROLL-UP APAR FOR INTERNAL CHANGES | ||||
2008 |
UNABLE TO CANCEL LOOPING DDF THREAD. 08/11/19 PTF PECHANGE |
||||
2008 |
ROLLUP APAR FOR INTERNAL CHANGES | ||||
2008 |
ADD SUBSTRING FUNCTIONALITY WITH NEW CQM UDF (CQMUDF03) | ||||
2008 |
INCORRECT STATISTICS MAY BE GATHERED ON DB2 V9 DISTRIBUTED WORKLOADS CAUSING INFLATED VALUES IN SUMMARIES AND EXCEPTIONS | ||||
2008 |
DELAY INFORMATION ON OPERATIONAL SUMMARIES PANEL CQM$SU8P DOES NOT INCLUDE THE ASYNCH CF REQUESTS DELAYS. | ||||
2008 |
LOOP IN DDF ENCLAVE AND HIGH CPU USAGE, CAUSED BY LOOPING DELAY PROCESSING IN CQMMESQL. | ||||
2008 |
COLLECTION CURSOR_NAME AND CLIENT_ENDUSER FIELDS INCORRECTLY TRANSLATED IN OFFLOAD, CQM1153E RETURN CODE 08 REASON CODE 03 | ||||
2008 |
DB2 CPU TIME AND DB2 ELAPSED MAY BE INCORRECTLY DISPLAYED FOR STORED PROCEDURES TERMINATED WITH -905 SQL CODE | ||||
2008 |
SPINLOOP IN CQMMSTRM+X'216E' THROUGH X'2FDE', AT LEVEL PK62230 08/07/29 PTF PECHANGE |
||||
2008 |
ROLLUP APAR | ||||
2008 |
CQM153E - RETURN CODE 04 REASON CODE C300 WAS ENCOUNTERED DURINGTRANSLATION. SOURCE CCSID = 1208 TARGET CCSID = 37 | ||||
2008 |
GET PAGE REQUESTS FIELD IS BEING TRUNCATED ON BUFFER POOL STATISTICS DISPLAY | ||||
2008 |
ABENDS0C3 RC03 FOR MODULE CQMMEXCW IN QUERY MONITOR SUBTASK | ||||
2008 |
ABND=0C4-00000011 DSNKSALO,M=DSNTFRCV. ABEND S0C4 MAY OCCUR IN MODULE DSNKSALO. | ||||
2008 |
CQM#SDIR SUBTASK ABEND AB/S0130 PRCS/00000000 IN ISGGNQDQ. | ||||
2008 |
SCQMSAMP MEMBER CQMCOMM DESCRIBE THE VALUES FOR OPTKEYS COLUMNS IN THE CQM22_INTERVALS TABLE AS "Y" FOR OPTKEYS SET IN CQMPARMS |
||||
2008 |
ADD A NEW PARM TO THE OFFLOAD PROGRAM CQM@WDB2 TO PREVENT DUPLICATE RECORDS FROM BEING LOADED IN THE DB2 OFFLOAD TABLES | ||||
2008 |
MESSAGE CQM1153E RETURN CODE 04 REASON CODE 07 WAS ENCOUNTERED DURING TRANSLATION SOURCE CCSID = 1200 TARGET CCSID = 1208 | ||||
2008 |
INCORRECT ELAPSED TIME MAY BE ALLOCATED TO DESCRIBE CALLS IN ACTIVITY SUMMARIES FOR STATIC SQL | ||||
2008 |
DECIMAL HOST VARIABLES MAY DISPLAY INCORRECTLY ON PANEL CQM$HS8S | ||||
2008 |
ABEND S806 MAY OCCUR IF RUNNING THE ISPF CLIENT FOR V2.2 AND V2.3 CONCURRENTLY ON THE SAME TSO SESSION. | ||||
2008 |
EXCEPTION GETPAGES BY OBJECT INCORRECTLY CALCULATED ON DB2 V9 | ||||
2008 |
ABENDS0C4 RC3B IN MODULE DSNXEET WHEN MONITORING A DB2 SUBSYSTEM | ||||
2008 |
DSNV086E IN DB2 SUBSYSTEM DB2 ABNORMAL TERMINATION REASON=00E50702 08/05/15 PTF PECHANGE |
||||
2008 |
ABEND 0C6-00000006 MAY OCCUR IN THE QM COLLECTOR WHEN MONITORINGDB2 V9 WORKLOADS | ||||
2008 |
ABENDS0C3 MAY OCCUR IN THE QM COLLECTOR AND MESSAGE CQM1500E ABNORMAL EOT FOR CQMMEXCW SUBTASK MAY BE ISSUED | ||||
2008 |
ABND=0C4-00000038,DSNXGRDS.DSNXECL+00BE | ||||
2008 |
EXCESSIVE NUMBER OF ALLOCATE CURSOR CALLS MAY BE REPORTED FOR CALLS ASSIGNED TO SECTION ZERO. | ||||
2008 |
SHORTAGE IN REAL STORAGE MAY OCCUR WHEN MONITORING DISTRIBUTED DB2 V9 WORKLOADS | ||||
2008 |
DATE / TIME / TIMESTAMP HOST VARIABLES MAY BE INCORRECTLY DISPLAYED | ||||
2008 |
ABEND S0C4-00000011 IN CSECT DSN9SCNP MAY OCCUR IN A DB2 SUBSYSTEM MONITORED BY QM | ||||
2008 |
CALCULATIONS FOR DELAY TIMES CAN BE INCORRECT | ||||
2008 |
ELAPSED TIME VALUES FOR INDEXES MAY BE INCORRECT IN OPERATIONAL SUMMARIES | ||||
2008 |
U3590 OMPE ABNDUE06-00000000 WITH DB2 V9 WHEN MONITORING FROM DB2 QUERY MONITOR R220 | ||||
2008 |
ABEND0C4 RC3B CQMMCL91+E6 WHEN STARTING QUERY MONITOR ON DB2 V9IEW4008I CSV028I CQM239E | ||||
2008 |
THE CURSOR NAME ON PANEL CQM$QLCA 'SQLCA DISPLAY' MAY APPEAR TO BE GARBLED | ||||
2008 |
MESSAGE QMQUERYRESULTTOOLARGEEXCEPTION MAY BE ISSUED AFTER SELECTING 'CLEAR HISTORY' OR CLOSING CAE CLIENT | ||||
2008 |
WINDOWS 2000 CAE SERVER MAY FAIL AFTER APPLYING MAINTENANCE DUE TO DELETED QUERY MONITOR WINDOWS SERVICE | ||||
2008 |
"TEXT NOT AVAILABLE" WHEN VIEWING DYNAMIC TEXT IN DATASHARING WHEN SAME TEXT WAS RUN IN MULTIPLE DB2'S | ||||
2008 |
CAE SERVER DOES NOT RESPOND TO SHUTDOWN COMMAND WHEN CQM_LOCAL_PORTAL_PORT IN USE | ||||
2007 |
DB2 COMMAND TEXT MAY BE INCORRECTLY FORMATTED | ||||
2007 |
ABENDS0C4 IN MODULE CQM#DRVR AT QM COLLECTOR STARTUP | ||||
2007 |
CQM154E RETURN CODE 08 REASON CODE 58 WAS ENCOUNTERED DURING VSAM PROCESSING DURING DYNAMIC ALLOCATION OF QUERY MONITOR DATA |
||||
2007 |
ABEND0C4 AT CQMOXG81+X'256E' AFTER CANCELLING ALLIED AGENT | ||||
2007 |
MESSAGE CQM153E - RETURN CODE 04 REASON CODE 0007 MAY BE INCORRECTLY ISSUED WHEN VIEWING OBJECT DETAILS | ||||
2007 |
CAE AGENT: OUT OF MEMORY PROBLEMS NOT ALWAYS HANDLED CORRECTLY IN CAE IN LARGE REQUESTS FOR SQL TEXT SUMMARIES | ||||
2007 |
CAE CLIENT MAY CAUSE "UNEXPECTED ERROR READING OBJECT" EXCEPTIONAND HANG ATTEMPTING TO LOGIN DURING UPDATE OF SELECTED SERVER | ||||
2007 |
WHEN USING TOPN FEATURE FOR SQL TEXT SUMMARIES IN A DATA SHARINGGROUP THE "NO VALUES FOUND" MESSAGE CAN BE ERRONEOUSLY RETURNED |
||||
2007 |
CAE AGENT MAY CONSUME HIGH CPU AND TEXT PANE MAY SHOW "LOADING..." FOR EXTENDED PERIOD OF TIME | ||||
2007 |
SOME HOST VARIABLES MAY BE INCORRECTLY DISPLAYED | ||||
2007 |
MESSAGE CQM1500E ABNORMAL EOT FOR CQMTTXTW SUBTASK MAY BE INCORRECTLY ISSUED AND THE COLLECTOR MAY ABEND | ||||
2007 |
ALLOW DISPLAY OF THE PLAN AND PACKAGE FOR DYNAMIC SQL AFTER SELECTING THE SQL TEXT FROM THE GUI INTERFACE | ||||
2007 |
IMPROVE PERFORMANCE IN THE GUI INTERFACE WHEN NAVIGATING INFORMATION DIRECTORIES | ||||
2007 |
ADD MESSAGE CQM3553E TO PROVIDE ADDITONAL INFORMATION WHEN A MONITORING AGENT INSTALLATION FAILS | ||||
2007 |
GENERATED E-MAIL MAY INCORRECTLY CONTAIN A NULL TEXT WHEN ALERT BROWSER SHOWS TEXT | ||||
2007 |
EMAIL ALERTS MAY NOT BE GENERATED BECAUSE THE USER INTERFACE ALLOWS MISMATCHES BETWEEN ACTIONS AND RESPONSES | ||||
2007 |
GUI CLIENT ACTIVITY SUMMARIES(OPERATIONAL) PERSPECTIVE TOTAL DELAYS FOR DATA SHARING GROUPS MAY NOT REFLECT FROM ALL MEMBERS |
||||
2007 |
WHEN DISPLAYING THE SQLCODES FOR MULTIPLE INTERVALS, THERE IS NOCONSOLIDATION OF SQLCODE INFORMATION ACROSS INTERVALS | ||||
2007 |
FETCH AND OPEN CALLS MAY BE INCORRECTLY REPORTED FOR DISTRIBUTEDCONNECTIONS | ||||
2007 |
WHEN VIEWING ACTIVITIES SUMMARIES (OPERATIONAL) THE PROGRAM SUB-TREE MAY APPEAR TWICE AND CONTAIN THE SAME DATA | ||||
2007 |
HOST VARIABLES MAY DISPLAY INCORRECTLY IN THE CQM GUI | ||||
2007 |
INFORMATION IN 'TOTAL DELAY TIME' FIELD ON THE CAE CLIENT MAY NOT REFLECT ALL DELAY TIMES | ||||
2007 |
SOME CONDITIONS MAY CAUSE DUPLICATE SYSTEMS TO BE DISPLAYED UNDER DATA SHARING GROUPS. | ||||
2007 |
DATA SHARING GROUP ERRONEOUSLY SHOWN AS A "LEAF" IF A PARTICULARMEMBER IS NOT MONITORED OR HAS NO DATA | ||||
2007 |
STATIC TEXT NOT SUMMARIZED IN DATA SHARING GROUPS | ||||
2007 |
IN CAE, CAN REMOVE ACTIONS STILL BEING USED BY CUSTOM LAUNCH, CAUSING INABILITY TO CLEAR MESSAGES | ||||
2007 |
ALLOW SQL TEXT GREATER THAN 80 CHARACTERS TO BE REFORMATTED WHENSUBMITTING JCL FROM CQM CAE | ||||
2007 |
VISUAL EXPLAIN INTEGRATION DOES NOT WORK IF DB2 CONNECT V9 IS INSTALLED ON THE CLIENT PC | ||||
2007 |
DB2OBJECTUSAGE MONITORING CAN CAUSE "UNEXPECTED OBJECT IN DESTUBIFY" EXCEPTIONS IN SERVER LOG UNDER CERTAIN CONDITIONS | ||||
2007 |
MESSAGE "DB2 SUBSYSTEM IS NOT MONITORED BY CQM SUBSYSTEM" MAY BEINCORRECTLY ISSUED WHEN VIEWING SQL TEXT FROM THE ALERT BROWSER |
||||
2007 |
WINDOWS SERVICE MAY NOT START IF WINDOWS PATH VARIABLE ENDS IN ABACKSLASH AT THE TIME THE WINDOWS SERVICE IS INSTALLED | ||||
2007 |
ALLOW COMMON ACTION DEFINITION FOR A GUI CLIENT ALERT THAT WILL ALLOW DISPLAY OF STATIC OR DYNAMIC SQL TEXT | ||||
2007 |
SORT ORDER MAY BE LOST AFTER DRILLING TO OBJECTS FROM THE 'ACTIVITY BY SQL TEXT' PANEL CQM$SU8J | ||||
2007 |
MESSAGE CQM1153E RETURN CODE 04 REASON CODE 0C MAY BE INCORRECTLY ISSUED WHEN VIEWING OBJECT INFORMATION | ||||
2007 |
ABEND S878 AND/OR ABEND S0C3 MAY OCCUR WHEN MONITORING WORKLOADS CONTAINING DSNTIAUL | ||||
2007 |
MESSAGE ISPP352 ON PANEL CQMHEXCA INCORRECTLY ISSUED WHEN USING PF1 (HELP ) ON THE CQM$EXCA DISPLAY EXCEPTIONS PANEL | ||||
2007 |
CAE DOES NOT CHECK MEMORY LIMITATIONS DURING THE REQUEST OF SQL TEXT | ||||
2007 |
PRIOR INTERVAL DATA MAY NOT BE DISPLAYED IN THE CQM GUI | ||||
2007 |
CAE TOP N FILTERING FOR SQL SUMMARY DATA | ||||
2007 |
SYSTEM ABEND0E0 RC00000029 MAY OCCUR IN THE DB2 DIST ADDRESS SPACE | ||||
2007 |
HIGH CPU DUE TO LOOP IN CQM ADDRESS SPACE | ||||
2007 |
MESSAGE CQM1153E RETURN CODE 04 REASON CODE 0C MAY BE INCORRECTLY ISSUED DURING THE OFFLOAD PROCESS | ||||
2007 |
INCORRECT INTERVAL END DATE / TIME MAY BE DISPLAYED WHEN VIEWING'SQL CODE SUMMARY' INFORMATION FROM MULTIPLE INTERVALS | ||||
2007 |
MISSING HOST VARAIABLES FROM 'DISPLAY EXCEPTIONS' PANEL | ||||
2007 |
ABEND S0C4 IN MODULE COPYMEM IN THE CAE AGENT | ||||
2007 |
ADD DB2 V9 SUPPORT TO DB2 QUERY MONITOR | ||||
2007 |
DB2 WLM ADDRESS SPACE ABEND MAY OCCUR WHEN STOPPING QM COLLECTOR, S0C4, S0C1, U4087 ARE POSSIBLE | ||||
2007 |
HIGH CPU UTILIZATION WHILE QM COLLECTOR IS RUNNING | ||||
2007 |
CHANGE THE DEFAULT FOR GENERATE SQLCODE ALERTS FROM Y TO N ON NEW PROFILE LINES | ||||
2007 |
INCORRECT COLUMN VALUES MAY PREVENT JOINS BETWEEN THE CQM22_SQLCODE_DET AND CQM22_SQLCODE_TEXT TABLES. | ||||
2007 |
MESSAGE CQM8018E MAY BE ISSUED INCORRECTLY WHEN USING OPTION LOAD(RESUME) | ||||
2007 |
RETRIEVAL OF SQL TEXT UNRELIABLE FROM DATA SHARING GROUPS IN SUMMARIES (OPERATIONAL & TRUCTURAL) AND SQLCODES PERSPECTIVES | ||||
2007 |
STATISTICAL SUMMARIZATION FOR DATA SHARING GROUP VIEWS IS INCOMPLETE IN SUMMARIES PERSPECTIVES. | ||||
2007 |
"DB2NOTMONITOREDEXCEPTION" MESSAGE ON CAE GUI CLIENT | ||||
2007 |
MESSAGE CQM251E IS ERRONEOUSLY ISSUED AND ISPF WILL NOT START | ||||
2007 |
CHANGE THE DEFAULT FOR GENERATE SQLCODE ALERTS FROM Y TO N | ||||
2007 |
CHANGE ALLOCATION OF THE TEMPORARY EXPORT DATASET WHEN CALLING SQL PERFORMANCE ANALYZER FROM QUERY MONITOR | ||||
2007 |
MESSAGE CQM3006I MONITORING AGENT ACTIVATED FOR SSID NOT ISSUED | ||||
2007 |
CQM2002E MESSAGE MAY BE ISSUED AFTER AN S878-10 ABEND OCCURS IN THE QM ADDRESS SPACE | ||||
2007 |
MESSAGE 'CLIENT/SERVER BUILDS MISMATCH' MAY BE DISPLAYED UNNECESSARILY | ||||
2007 |
CAE WATCHDOG DOES NOT STOP WHEN USING THE SHUTDOWN COMMAND FROM THE START_CAE_WATCHDOG SCRIPT | ||||
2007 |
WHEN USING THE CAE SERVER BASED ACTIONS, SOME OPTIONS MAY BE HIDDEN: CAE CLIENT DISPLAY MAY CONTAIN INCORRECT DATA | ||||
2007 |
UPGRADE WORKSTATION JAVA SDK/JRE FOR ADJUSTMENTS TO THE US DAYLIGHT SAVINGS CHANGES IN MARCH 2007 | ||||
2007 |
ABEND878-10 IN CQM ADDRESS SPACE AS A RESULT OF SQL WITH A STATEMENT TYPE OF 0 | ||||
2007 |
DB2 CPU TIME IN EXCEPTION PANELS MAY BE INCORRECTLY DISPLAYED INTHE ISPF INTERFACE | ||||
2007 |
ABEND S0C4 MAY OCCUR AT SHUT DOWN OF DATA COLLECTOR STARTED TASK | ||||
2007 |
QM ABEND0C4 RS04 IN CQM#QAPI+X'3DE4' , NO RESPONSE FROM SQL TEXTOPTION ON DRILL DOWN | ||||
2006 |
ABENDS0C4 RD04 MODULE NAME=CQMOINST OFFSET=000014DE IN DATA COLLECTOR STARTED TASK 06/12/04 PTF PECHANGE |
||||
2006 |
INCREASED STORAGE GROWTH IN SP230 KEY7 WITHIN THE QM ADDRESS SPACE ASSOCIATED WITH DISTRIBUTED WORKLOADS | ||||
2006 |
WHEN VIEWING MULTIPLE INTERVALS OF EXCEPTIONS, USER MAY BE INCORRECTLY SENT TO THE MAIN QM PANEL ( CQM$MAIN ) | ||||
2006 |
MESSAGE CQM2604E VSAM LOGIC ERROR VSAMRC=X'08' VSAMRS=X'0020' MAY BE INCORRECTLY ISSUED | ||||
2006 |
DATA COLLECTOR ADDRESS SPACE MAY NOT END AFTER CANCEL | ||||
2006 |
ABENDSC78 RS04 MAY OCCUR IN THE TSO ADDRESS SPACE WHEN VIEWING HOST VARIABLES IN CURRENT ACTIVITY | ||||
2006 |
WHEN VIEWING MULTIPLE PAGES OF EXCEPTIONS (PANEL CQM$EXCA), THE DISPLAY MAY BE INCORRECTLY RETURNED TO THE FIRST PAGE | ||||
2006 |
EVENT COUNTS ON PANEL CQM$LO8X (LOCK RELATED STATS) AND CQM$QR8X(MISCELLANEOUS STATS) MAY BE INCORRECT | ||||
2006 |
COUPLING FACILITY DELAY INFORMATION MAY BE INFLATED | ||||
2006 |
MESSAGE CQM155E MAY BE ISSUED FOR BACK STORE DATASETS DUE TO INCORRECT SHARE OPTIONS | ||||
2006 |
MESSAGE CQM2002E MAY BE ISSUED AFTER THE QM STARTED TASK ABENDS | ||||
2006 |
LOOP CQMOREDC OFFSETS 11BA-11F0 | ||||
2006 |
DECIMAL FIELDS IN THE CQM OFFLOAD TABLES MAY BE INCORRECTLY CALCULATED | ||||
2006 |
ROLL UP APAR | ||||
2006 |
CLONE -ALERTS IN THE CQM CAE CAN INCORRECTLY SHOW DIFFERENT STATEMENT NUMBERS FOR THE SAME EXCEPTION (PK23612) | ||||
2006 |
CLONE -INCREASED STORAGE GROWTH IN SP230 KEY7 WITHIN THE QM ADDRESS SPACE CAN CAUSE ABENDS0C3 (PK25825) | ||||
2006 |
CLONE -QM LOOP IN CQMEXCP AT X'2D92' (PK26168) | ||||
2006 |
CLONE -MSGCQM2001E RECEIVED WHEN ATTEMPTING TO MONITOR A DB2 SUBSYSTEM(PK25835) | ||||
2006 |
CLONE -DB2 THREADS STAY IN CURRENT ACTIVITY AFTER THREAD TERMINATION (PK27444) | ||||
2006 |
CLONE -ADD COMMIT LOGIC TO SQL TEXT OFFLOAD PROCESS FOR QUERY MONTIOR (PK27776) | ||||
2006 |
CLONE -A LOOP CAN OCCUR IN CQMMEXCW (PK28535) | ||||
2006 |
CLONE -HIGH CPU CONSUMPTION IN MODULE CQMMCMON (PK29222) | ||||
2006 |
CLONE S0C4 ABEND IN SUMMARY BY SQLTEXT WHEN ISPF SESSION IS OUT OF MEMORY (PK27699) | ||||