How to perform graphic explain in new BMC Workbench for Db2

Version 4
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Workbench for DB2


    APPLIES TO:

    BMC Wokrbech for Db2 with BQU1678 applied



    QUESTION:

    How to perform graphic explain in New workbench for Db2


    ANSWER:

     

    BMC Workbench is currently being converted from Adobe flash to HTML5. Classic workbench functionality is being added to New Workbench in a phased implementation, and new functionality is only being implemented in New Workbench.
     
     
    During the conversion phase, both the Classic Workbench and the New Workbench are available, and can be launched from different URLs
     

         

     
    In the New Workbench the SQL Analysis app (PTF BQU1678 applied) displays the top 100 SQL statements for a subsystem that use the most CPU time.  The selected SQL statement can then be explained and the explain tree is displayed in text format. However the graphical representation of the explain is available in classic but not the new workbench.
    To create the graphical explain until the conversion is complete, it is necessary to:

     

      
       
    • Launch Classic Workbench

    •  
    • Open the performance perspective

    •  
    • Add a new SQL statement view

    •  
    • Cut and paste the SQL text from the New workbench

    •  
    • Click the lightbulb to explain the SQL as usual

      

     

     


    Article Number:

    000211373


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles