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: 6 July 2023
DB2 Path Checker Version 3.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PM42613
10_Aug
2011
UK70691


PATH CHECKER PGM CKPPTHCK CARD COLUMN
PM08254
28_Jul
2010
UK59238


PANEL CKPP0005 INCORRECTLY GENERATES MSG CKP1016I
PM10971
28_Jul
2010
UK59238


REPORT COMMAND FAILS WHEN PLAN TABLE OWNER NAME HAS SPECIAL CHARACTERS
PM03876
19_Jan
2010
UK53667


PERFORMANCE ISSUE WHEN PATH CHECKER USES EXPLAIN OR TEST AND THEPACKAGE IS BOUND AS DEGREE ANY.
PM03261
12_Jan
2010
UK53512


GETTING MESSAGE CEE0813S WHEN RUNNING A COMPARE.
PM01569
30_Nov
2009
UK52399


MSG CKP047E DDF CONNECT TO ANOTHER SSID
PM01268
19_Nov
2009
UK52130


INCORRECT RESULTS RUNNING TEST PACKAGE
PM00839
18_Nov
2009
UK52078


PATH CHECKER ABEND806
PK75400
16_Oct
2009
UK51127


PATH CHECKER SHOWS DIFFERENT RESULTS IN INTERACTIVE MODE THAN INBATCH MODE R310 ONLY.
PK95457
16_Oct
2009
UK51127


ACCESS PATH DIFFERENCES BETWEEN DETAIL AND SUMMARY REPORTS
PK95639
16_Oct
2009
UK51127


TEST WITH OPTIONS CPUPCT 00 WRITES INCORRECT REBIND CARDS TO RBINDOUT
PK89651
7_Jul
2009
UK48149


CLARIFY SUMMARY REPORT INCLUDING DSN_STATEMNT COST
PK88040
25_Jun
2009
UK47783


CKP043E WHEN EXECUTING PROGRAM CKPPTHCK.
PK81855
15_May
2009
UK46664


PATH CHECKER FAILS WITH RC=16
PK83049
15_May
2009
UK46664


CREATE AN OPTION CPUPCT2 N FOR PATH CHECKER
PK69719
18_Sep
2008
UK40011


PATH CHECKER OUTPUT MAY INCORRECTLY INDICATE THAT SQL STATEMENTSHAVE BEEN DELETED WHEN IN FACT THEY HAVE NOT.
PK66297
6_Jun
2008
UK37148


ADDITIONAL INTERNAL DIAGNOSTICS TO BE IMPLEMENTED FOR THE SYSDIAGN DD CARD.
PK65415
6_Jun
2008
UK37148


IN PATH CHECKER REPORT OUTPUT THE SVC UNITS FIELD IS LIMITED TO 7 DIGITS, BUT DB2 DEFINES THE SVC UNITS FIELD AS UP TO 10
DIGITS
PK64152
2_May
2008
UK36148


UNUSUAL RESULTS USING THE TEST COMMAND
PK62805
4_Apr
2008
UK35256


WHEN PATH CHECKER MESSAGE CKP044E IS ISSUED COMPLETION CODE IS SET TO CC=00.
PK58650
25_Feb
2008
UK34036


NO MEMBERS FOUND
PK59019
25_Feb
2008
UK34036


INCORRECT OUTPUT IN THE PLAN TABLE WHEN RUNNING A WILDCARDED EXPLAIN AGAINST THE DB2 CATALOG.
PK60712
25_Feb
2008
UK34036


PATH CHECKER TERMINATES WITH MSGCKP202E WITH ERROR CODE = 1,009.THE MSG EXPLANATION NEEDS TO BE ENHANCED AND PGM NOT
TERMINATE.
PK58006
9_Jan
2008
UK32854


PROVIDE NEW CLIST AND INSTRUCTIONS FOR STARTING PATH CHECKER FROM LAUNCHPAD AND ADMIN TOOL.
PK50777
6_Sep
2007
UK28942


PATH CHECKER CKPBIND MUST SPECIFY ENCODING(EBCDIC) TO PROCESS ON VERSION 9 DB2.
PK50769
24_Aug
2007
UK28554


IN THE PATH CHECKER ISPF INTERFACE THE DEFAULT_AUTHID ENTERED BYTHE USER ON THE SETTINGS PANEL IS IGNORED, LEADS TO SQLCODE
-204
PK48840
27_Jul
2007
UK27563


INCONSISTENT RESULTS USING BINDIN DD STATEMENT
PK45319
21_Jun
2007
UK26378


PATH CHECKER ABEND0C4 WHEN DBRMOUT IS NOT LRECL 80 RECFM FB.
PK44196
30_May
2007
UK25652


PROVIDE OPTION TO START PATH CHECKER FROM THE LAUNCHPAD.
PK42301
26_Apr
2007
UK24469


THIS APAR TO SATISFY MARKETING REQUIREMENT MR0323064741. PATH CHECKER TO ISSUE REBIND COMMANDS FOR PACKAGES W/NO PATH
CHANGE.
PK43413
26_Apr
2007
UK24469


SQLCODE418 -418 ON EXPLAIN SET WITH SQL WITH CONCATENATED RANGE TESTING.
PK41435
28_Mar
2007
UK23448


MESSAGE CKP045E OCCURRED AND PATH CHECKER JOB ENDS WITH RC=0.
PK41123
15_Mar
2007
UK23062

HIPER

ABEND04E WITH 00E7000C ON COMPARE COMMANDS FOR PLANS WITH OPTIONSCATALOGSQL OR ANLOUT AND PATH CHECKER R310 W/ DB2 V9.
PK40644
9_Mar
2007
UK22881


SQLCODE -312 WITH MSGCKP214I EXPLAIN FAILED FOR STATEMENT
PK40414
9_Mar
2007
UK22881


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.
PK38143
26_Feb
2007
UK22496


SQLCODE -417 FROM PATH CHECKER.
PK38108
22_Feb
2007
UK22433


PATH CHECKER COMPARE TO X.X BEFORE 'TIMESTAMP VALUE' RESULT IN WHERE PREVIOUS VERSION AND BINDTIME ARE GREATER THAN THE
BEFORE
PK37376
9_Feb
2007
UK21999


PATHCHECKER TEST & EXPLAIN COMMANDS FAIL W/ SQLCODE=-104 FOR UPDATE STATEMENTS AS UPDATE TABLE SET COL = COL + :HV WHERE
PK37591
9_Feb
2007
UK21999


PATH CHECKER WITH EXPLAIN DBRM AND MSGCKP217I MAY REPORT COST INCREASES WHEN THERE SHOULD BE NONE.
PK37132
11_Jan
2007
UK21187


CORRECT GRAMMAR ERROR IN HELP PANEL CKPH003
PK35241
19_Dec
2006
UK20768


MSGCKP206I IS ISSUED WITH TWO SLIGHTLY DIFFERENT TEXTS DEPENDINGON IF THERE IS AN 'OLD' ACCESS PATH OR NOT.
PK33886
8_Dec
2006
UK20457


PATH CHECKER FAILS TO MATCH SOME EXISTING SQL WHEN USING THE OPTION MATCHSQL.
PK33428
10_Nov
2006
UK19611


APAR FOR PATH CHECKER R310 TO INCLUDE THE FIXES FOR R220 APARS PK32052, PK29523, PK28959, AND PK29523 ( FORWARD FIT ).

Top of page