IBM Support

PI93652: MISSING STATEMENTS FROM STATIC PACKAGE EXPLAIN WHEN QUERYNO CLAUSE DOES NOT MATCH STMTNOI

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

  • Missing statements from static package EXPLAIN when QUERYNO
clause does not match STMTNOI

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of IBM Db2 SQL Performance Analyzer    *
*                 z/OS.                                        *
****************************************************************
* PROBLEM DESCRIPTION: Missing statements from static          *
*                      package EXPLAIN when QUERYNO clause     *
*                      does not match STMTNOI                  *
****************************************************************
* RECOMMENDATION: APPLY the PTF.                               *
****************************************************************
Code has been changed to correct this condition.

    



Problem conclusion


    

  • APPLY the PTF.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI93652
    • 

  • 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
    2018-02-12
    • 

  • Closed date
    2018-04-16
    • 

  • Last modified date
    2018-05-01
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    
UI55250
    

    • 



Modules/Macros


    

  • ANLCRNE1 ANLCRNT1 ANLEEE   ANLH11   ANLH12
ANLH13   ANLMAIN  ANLPBTCH ANLPCOLL ANLPCOL2 ANLPCVFP ANLPDBRM
ANLPDYNE ANLPFILE ANLPHDYN ANLPHI01 ANLPH210 ANLPH211 ANLPH212
ANLPH213 ANLPH214 ANLPH215 ANLPH216 ANLPH217 ANLPH218 ANLPH220
ANLPH310 ANLPH311 ANLPH312 ANLPH313 ANLPH315 ANLPH410 ANLPH411
ANLPH412 ANLPH500 ANLPH510 ANLPH511 ANLPH600 ANLPH610 ANLPH611
ANLPH612 ANLPH700 ANLPH701 ANLPH710 ANLPH711 ANLPH712 ANLPIDX1
ANLPIDX2 ANLPNUXV ANLPPKGE ANLPPRMU ANLPQMF  ANLPQNO  ANLPRCR
ANLPRER  ANLPSDQ  ANLPSPA  ANLPSRCE ANLPTAB1 ANLPTAB2 ANLPWRKP
ANLQMF   ANLSQLPA ANLTSO

    



Fix information


    

  • Fixed component name
    DB2 SQL PERF AN
    • 

  • Fixed component ID
    5697F5701
    • 



Applicable component levels


    

  • R510  PSY  UI55250
       UP18/04/20  P  F804
    • 



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