IBM Support

PI85300: ALLOW BASIC EXPLAIN CAPABILITY FROM SELECTED CLASSIC PANELS WHERE SQL STATEMENT IS DISPLAYED

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Allow customer without SQLPA license to use batch explain to
analyze sql text displayed from classic interface

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM Components     *
*                 Classic Interface                            *
*                 PE Server                                    *
*                 PWH Server                                   *
****************************************************************
* PROBLEM DESCRIPTION: Allow basic EXPLAIN capability from     *
*                      selected Classic panels where SQL       *
*                      statement is displayed if DB2 SQL PA is *
*                      not installed.                          *
****************************************************************
* RECOMMENDATION: Apply the provided PTF.                      *
****************************************************************
Allow basic EXPLAIN capability from selected screens in Classic
user interface.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • Basic EXPLAIN enabled in the Classic user interface

Keywords:
EXPLAIN Classic interface ZSQL ZEDD3 ZHTCALL

    



APAR Information




    

  • APAR number
    PI85300
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    540
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    YesSpecatt / New Function / Xsystem
    • 

  • Submitted date
    2017-08-01
    • 

  • Closed date
    2017-11-06
    • 

  • Last modified date
    2017-12-02
    • 





    

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

    
PI82434
    

    • 

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

    
UI51701
    

    • 



Modules/Macros


    

  •    DGOVMSTR DGOZBEXP DGOZBTCH DGOZCONV DGOZCRDP
DGOZDMDB DGOZDTA1 DGOZDTA2 DGOZDTA3 DGOZDTA4 DGOZDTA5 DGOZDTA6
DGOZDTA7 DGOZLOAD DGOZMT1  DGOZMT1I DGOZMT2  DGOZMT2I DGOZMT2J
DGOZMT2K DGOZMT3  DGOZMT3I DGOZMT4  DGOZMT4I DGOZMT5  DGOZMT5I
DGOZMT5J DGOZPC2  DGOZPC3  DGOZPC4  DGOZPRV1 DGOZPRV2 DGOZSAPI
DGOZSAP2 DGOZSCRD DGOZSP   DGOZSQPA DGOZTBL  DGOZVW1  DGOZVW2
DGOZWSTE HKDB540J KO2ABROW KO2ACAFK KO2ACAFS KO2ACAF2 KO2AHLR
KO2APC3K KO2APC3S KO2APC32 KO2APC6K KO2APC6S KO2APC62 KO2CDCNB
KO2CDFSK KO2CDFSS KO2CDFS2 KO2CIFAB KO2CIFDB KO2CIFIK KO2CIFIS
KO2CIFI2 KO2CIF2K KO2CIF2S KO2CIF22 KO2CIF3K KO2CIF3S KO2CIF32
KO2CIF4K KO2CIF4S KO2CIF42 KO2CLKDK KO2CLKDS KO2CLKD2 KO2CMVSF
KO2CNTPK KO2CNTPS KO2CNTP2 KO2CPUCL KO2CTHBK KO2CTHBS KO2CTHB2
KO2CTHCK KO2CTHCS KO2CTHC2 KO2CTHEK KO2CTHES KO2CTHE2 KO2CTHFK
KO2CTHFS KO2CTHF2 KO2CTHJK KO2CTHJS KO2CTHJ2 KO2CTHKK KO2CTHKS
KO2CTHK2 KO2CTHMK KO2CTHMS KO2CTHM2 KO2CTHNK KO2CTHNS KO2CTHN2
KO2CTHOK KO2CTHOS KO2CTHO2 KO2CTHQK KO2CTHQS KO2CTHQ2 KO2CTHSK
KO2CTHSS KO2CTHS2 KO2CTH3K KO2CTH3S KO2CTH32 KO2CTH6K KO2CTH6S
KO2CTH62 KO2CT2SK KO2CT2SS KO2CT2S2 KO2DB2IB KO2DQPIH KO2DSQPI
KO2ETDBB KO2HMSGB KO2HSQPB KO2HSVIB KO2ICOLK KO2ICOLS KO2ICOL2
KO2MSQPB KO2NCSTB KO2NCS1B KO2NCS6B KO2NCS8B KO2NDRVB KO2OCMCB
KO2ODBGB KO2OED6B KO2OINTB KO2OMGCB KO2OMNUB KO2ORCVB KO2ORLGB
KO2OSBSB KO2OSQPB KO2OSYXB KO2OSY1B KO2OTCIK KO2OTCIS KO2OTCI2
KO2OTHDB KO2OTHJB KO2OTHKB KO2OTHLB KO2OTHMB KO2OTHNB KO2OTHOB
KO2OTHQB KO2OTHSB KO2OTHTB KO2OTHVB KO2OTHXB KO2OTHYB KO2OTH3B
KO2OTH4B KO2OTH7B KO2OTH8B KO2OXSYB KO2OXTHB KO2OZM2B KO2PB00H
KO2PB00I KO2PB02H KO2PB02I KO2PB03H KO2PB03I KO2PWHCB KO2QPB00
KO2QPB02 KO2QPB03 KO2SQPIH KO2SQPLH KO2SQPLI KO2TCALL KO2TQPIH
KO2TSQPI KO2XTHSK KO2XTHSS KO2XTHS2 KO2ZAPI  KO2ZASY  KO2ZDBD
KO2ZEDD3 KO2ZITG  KO2ZMENU KO2ZRTG  KO2ZSQL  KO2ZSQPI KO2ZSQPL

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R540  PSY  UI51701
       UP17/11/08  P  F711
    • 



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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 December 2017
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback