IBM Support

PI63501: SQLCODE -305 ON DB2 11 PLAN_TABLE MIGRATED FROM DB2 10

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

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

    




Publications Referenced


SC27677100    





Fix information


    

  • Fixed component name
    DB2 SQL PERF AN
    • 

  • Fixed component ID
    5697F5701
    • 



Applicable component levels


    

  • R420  PSY  UI44308
       UP17/02/04  P  F702
    • 

  • R510  PSY  UI44309
       UP17/02/04  P  F702
    • 



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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback