A fix is available
APAR status
Closed as program error.
Error description
SQLCODE -305 on DB2 11 PLAN_TABLE migrated from DB2 10
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 SQL Performance Analyzer * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE -305 on DB2 11 PLAN_TABLE * * migrated from DB2 10. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI63501
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-06-02
Closed date
2017-01-30
Last modified date
2017-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI44308 UI44309
Modules/Macros
ANL$$PRM ANLCBTCH ANLCCV2 ANLCDBRM ANLCFILA ANLCFILE ANLCGETP ANLCHECK ANLCIGO ANLCKDSN ANLCKTBL ANLCMACR ANLCMIGR ANLCMIG1 ANLCMP ANLCNOT2 ANLCNOT3 ANLCNOT8 ANLCORPT ANLCPARM ANLCPRNT ANLCPUTP ANLCRGID ANLCRNE1 ANLCRNS1 ANLCRNS2 ANLCRNT1 ANLCRNT2 ANLCSPA1 ANLCSQLI ANLCSRCE ANLCSTA1 ANLCSYST ANLCS2E ANLCVSET ANLCWIF1 ANLCWIF2 ANLDPRM ANLEEE ANLGPRM ANLH09 ANLICRE8 ANLMAIN ANLNUXD ANLPAPPL ANLPBRWS ANLPBTCH ANLPCOLL ANLPCOL2 ANLPCONT ANLPCVFP ANLPCV1 ANLPCV2 ANLPDBRM ANLPDLST ANLPDRIX ANLPDYNE ANLPFILE ANLPHA12 ANLPHA14 ANLPHA16 ANLPHA17 ANLPHA18 ANLPHA19 ANLPHA22 ANLPHA23 ANLPHA24 ANLPHA26 ANLPHA28 ANLPHD10 ANLPHD22 ANLPHG70 ANLPHG71 ANLPHG72 ANLPHR16 ANLPHV03 ANLPH020 ANLPH027 ANLPH028 ANLPH83B ANLPH83D ANLPH83E ANLPH83F ANLPH911 ANLPH920 ANLPICP ANLPIDD ANLPIDX1 ANLPIDX2 ANLPIQLR ANLPITP ANLPIXAI ANLPIXDI ANLPJCL ANLPLIM1 ANLPLIM2 ANLPMAIN ANLPMAN1 ANLPMAN2 ANLPMAN3 ANLPMIGR ANLPNOTB ANLPNUXR ANLPNUXV ANLPNUX1 ANLPNUX2 ANLPORPT ANLPPARM ANLPPKGE ANLPPRMS ANLPPRMU ANLPQBR1 ANLPQMF ANLPQNO ANLPRCR ANLPREPT ANLPRER ANLPREST ANLPSPA ANLPSQL ANLPSQLD ANLPSRCE ANLPSTAT ANLPSYST ANLPTABL ANLPTAB1 ANLPTAB2 ANLPTBDI ANLPTBLF ANLPTCMP ANLPTTST ANLPUPRM ANLPVIEW ANLPWRKP ANLQMF ANLQMONC ANLSQLPA ANLTSO ANL05 ANL13
SC27677100 |
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"5.1.0"}]
Document Information
Modified date:
04 January 2021