IBM Support

PI82434: 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                            *
*                 PWH Server                                   *
****************************************************************
* PROBLEM DESCRIPTION: Allow basic Explain capability from     *
*                      selected Classic panels where SQL       *
*                      statement is displayed.                 *
****************************************************************
* 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
    PI82434
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    530
    • 

  • Status
    CLOSED  UR1
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2017-06-01
    • 

  • Closed date
    2017-07-19
    • 

  • Last modified date
    2017-08-02
    • 





    

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

    • 

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

    
UI48933 PI85300
    

    • 



Modules/Macros


    

  •    DGO@BEXP DGO@BTCH DGO@CONV DGO@CRDP DGO@DTA1
DGO@DTA2 DGO@DTA3 DGO@DTA4 DGO@DTA5 DGO@DTA6 DGO@DTA7 DGO@LOAD
DGO@MT1  DGO@MT1I DGO@MT2  DGO@MT2I DGO@MT2J DGO@MT2K DGO@MT3
DGO@MT3I DGO@MT4  DGO@MT4I DGO@MT5  DGO@MT5I DGO@MT5J DGO@PC2
DGO@PC3  DGO@PC4  DGO@PRV1 DGO@PRV2 DGO@SAPI DGO@SAP2 DGO@SCRD
DGO@SP   DGO@SQPA DGO@TBL  DGO@VW1  DGO@VW2  DGO@WSTE 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 HKDB530J KO2ACAFA
KO2ACAFK KO2ACAFS KO2APC3A KO2APC3K KO2APC3S KO2APC6A KO2APC6K
KO2APC6S KO2CDCNB KO2CDFSA KO2CDFSK KO2CDFSS KO2CIFAB KO2CIFDB
KO2CIFIA KO2CIFIK KO2CIFIS KO2CIF2A KO2CIF2K KO2CIF2S KO2CIF3A
KO2CIF3K KO2CIF3S KO2CIF4A KO2CIF4K KO2CIF4S KO2CLKDA KO2CLKDK
KO2CLKDS KO2CMVSF KO2CNTPA KO2CNTPK KO2CNTPS KO2CPUCL KO2CTHBA
KO2CTHBK KO2CTHBS KO2CTHCA KO2CTHCK KO2CTHCS KO2CTHEA KO2CTHEK
KO2CTHES KO2CTHFA KO2CTHFK KO2CTHFS KO2CTHJA KO2CTHJK KO2CTHJS
KO2CTHKA KO2CTHKK KO2CTHKS KO2CTHMA KO2CTHMK KO2CTHMS KO2CTHNA
KO2CTHNK KO2CTHNS KO2CTHOA KO2CTHOK KO2CTHOS KO2CTHQA KO2CTHQK
KO2CTHQS KO2CTHSA KO2CTHSK KO2CTHSS KO2CTH3A KO2CTH3K KO2CTH3S
KO2CTH6A KO2CTH6K KO2CTH6S KO2CT2SA KO2CT2SK KO2CT2SS KO2DB2IB
KO2DQPIH KO2DSQPI KO2ETDBB KO2HSQPB KO2HSVIB KO2ICOLA KO2ICOLK
KO2ICOLS KO2MSQPB KO2NCSTB KO2NCS1B KO2NCS6B KO2NCS8B KO2NDRVB
KO2OCMCB KO2ODBGB KO2OED6B KO2OINTB KO2OMNUB KO2ORCVB KO2ORLGB
KO2OSBSB KO2OSQPB KO2OSYXB KO2OSY1B KO2OTCIA KO2OTCIK KO2OTCIS
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 KO2XTHSA KO2XTHSK KO2XTHSS KO2ZAPI  KO2ZASY  KO2ZDBD
KO2ZEDD3 KO2ZITG  KO2ZMENU KO2ZRTG  KO2ZSQL  KO2ZSQPI KO2ZSQPL
KO2ZSTLA KO2ZSTLK KO2ZSTLS

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R530  PSY  UI48933
       UP17/07/25  P  F707
    • 



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.3.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.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 August 2017
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback