|
DB2 Path Checker Version 2.2
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2007 |
MESSAGE CKP045E OCCURRED AND PATH CHECKER JOB ENDS WITH RC=0. | ||||
2007 |
SQLCODE -312 WITH MSGCKP214I EXPLAIN FAILED FOR STATEMENT | ||||
2007 |
PATH CHECKER SQLCODE -180 IF EITHER PLAN_TABLE DOES NOT HAVE THE COLUMN OR ROWS IN PLAN_TABLE DON'T HAVE A NOT NULL BINDTIME. |
||||
2007 |
SQLCODE -417 FROM PATH CHECKER. | ||||
2007 |
PATH CHECKER COMPARE TO X.X BEFORE 'TIMESTAMP VALUE' RESULT IN WHERE PREVIOUS VERSION AND BINDTIME ARE GREATER THAN THE BEFORE |
||||
2007 |
PATHCHECKER TEST & EXPLAIN COMMANDS FAIL W/ SQLCODE=-104 FOR UPDATE STATEMENTS AS UPDATE TABLE SET COL = COL + :HV WHERE | ||||
2007 |
PATH CHECKER WITH EXPLAIN DBRM AND MSGCKP217I MAY REPORT COST INCREASES WHEN THERE SHOULD BE NONE. | ||||
2006 |
MSGCKP206I IS ISSUED WITH TWO SLIGHTLY DIFFERENT TEXTS DEPENDINGON IF THERE IS AN 'OLD' ACCESS PATH OR NOT. | ||||
2006 |
PATH CHECKER FAILS TO MATCH SOME EXISTING SQL WHEN USING THE OPTION MATCHSQL. | ||||
2006 |
THIS APAR TAKEN TO PROVIDE ENHANCED DIAGNOSTICS, MESSAGES AND CODES FOR PATH CHECKER ERROR SITUATIONS. | ||||
2006 |
COMPARE PLAN DOES NOT REPORT ALL ACCESSPATHS IN SYSEXPLN. | ||||
2006 |
PATH CHECKER SYSEXPLN OUTPUT DOES NOT REFELCT SWEDISH LANGUAGE NATIONAL CHARACTERS ( UNICODE ) CORRECTLY. | ||||
2006 |
BATCH RUN GETS LE RUNTIME OPTION MESSAGES CEE3627I, CEE3612I AND CEE3626I. | ||||
2006 |
DB2 PATH CHECKER ABENDS WITH U4039 MEMORY SHORTAGE ERRORS. | ||||
2006 |
MSGCKP220I LISTS INCORRECT COLUMN IDENTIFICATION IN SYSEXPLN. | ||||
2006 |
REPORTALL DOESN'T SHOW OLD ACCESS PATH PLAN | ||||
2006 |
PATH CHECKER INSTALLATION VERIFICATION PROGRAM CKPIVP RECEIVES ABEND U4039 IN MODULE CEEPLPKA. ( 59838 ) | ||||
2006 |
RUNNING PATH CHECKER REPORT WITH RELEASE R220 AND DB2 V8 NFM USING COMPARE, THE SQL DISPLAYED IS IN UNICODE FORMAT. | ||||
2006 |
USING DB2 PATH CHECKER OPTION CATALOGSQL NO SQL IS GENERATED EVEN THO PLAN_TABLE & XXXX.SYSPACKSTMT HAVE RIGHT STMT NUMBERS. |
||||
2006 |
FIELDS SQLID AND OLD_PLAN_TABLE IN THE SYSEXPLN HEADER CONTAIN X'00' S RATHER THAN REAL VALUES. | ||||
2006 |
TEST OR EXPLAIN COMMAND STOPS PROCESSING. | ||||
2006 |
WHILE RUNNING DB2 PATH CHECKER ON Z/OS, GETTING SDQLCODE -311 ONCOMPARE | ||||
2006 |
OPTIONS CREATE TABLES | ||||
2006 |
DISPLAY OF V8 DBRM WITH UNICODE FOR OPTION CATALOGSQL IS NOT DISPLAYED CORRECTLY FOR REMOTE DBRMS AFTER PK15343 / UK10237. | ||||
2006 |
RUNNING THE EXPLAIN REPORT AGAINST A QUERY THAT HAS A GROUP BY, THE PATH CHECKER REPORT IS PLACING A 'Y' IN THE ORDER BY COLUMN. |
||||
2006 |
SPECIFY DIFFERENT TABLE QUALIFIERS FOR SQL STATEMENTS IMBEDDED IN PROGRAMS FROM PLAN_TABLE QUALIFIERS | ||||
2005 |
PATH CHECKER JOB STOPS WITH DSNT418I WHEN THE INPUT IS IN ERROR. | ||||
2005 |
USING REPORTCOSTGT PATH CHECKER COMPARE REPORTS ONLY AN ACCESSPATH CHANGE, NOT A COST CHANGE. | ||||
2005 |
PATH CHECKER SYSCHG OUTPUT WRITTEN ONLY W/ACCESS PATH CHANGE TO REPORT BUT DB2 V8 CAUSE COST INCREASE EVEN WITH NO ACCESS CHANGE |
||||
2005 |
DISPLAY OF V8 DBRM WITH UNICODE FOR OPTION CATALOGSQL IS NOT DISPLAYED CORRECTLY. | ||||
2005 |
PROVIDE A REVISED FORMAT TO THE SYSPRINT REPORT BASED UPON MARKETING REQUIREMENTS MR1020053933 AND MR1025057404. | ||||
2005 |
INSERTS THE MATCHING DATA TO DSN_STATEMNT_TABLE WHEN EXPLAIN DBRM TO PACKAGE TESTCOLLX IN USER.PLAN_TABLE IS PROCESSED. | ||||
2005 |
ABEND80A OR ABEND878 CAUSED BY A STORAGE LEAK | ||||
2005 |
UNDER CERTAIN CIRCUMSTANCES PATH CHECKER DISPLAYS AN INCORRECT VALUE FOR THE CLUSTER RATIO IN ITS SYSEXPLN OUTPUT. | ||||