Analyzing a specific Db2

Use the following procedures to analyze detailed data about a specific Db2.

To view detailed data about a specific Db2

From EZDSSI, select the easy menu EZDB2.

The EZDB2 easy menu is designed to analyze one Db2 at a time. This method selects one Db2 from the context of ALL. (If you select the SSI Status - List Db2s hyperlink, the STDB2 view provides a drill down on the target to STDB2D, and from there to EZDB2.)

Related topic

Isolating-Db2-performance-problems


Tip

Alternatively, you could access the detailed data by selecting any view from the Db2 SSI easy menu (EZDSSI). From the list of available Db2 targets, you can hyperlink to another view with more information about the selected Db2.

 W1 =EZDB2============(ALL======*=======)07JUL2016==10:32:26====MVDB2====D====1
                                 Db2 Easy Menu                                 
    Db2 Status                                          Thread Activity        
  . Db2 Status Summary      +----------------------+  . Current Threads (Elap)
  . Db2 Health Dashboard    |   Place cursor on    |  > Active Thread Menu     
  . Current Exceptions      |    menu item and     |  . Thrd Workload History  
  . Activity Rates          |     press ENTER      |  . Current Traces         
  > Stats Menu              +----------------------+  . Graphic THRDHIST       
    System Resources          Monitors                . Summary by Accelerator
  > Locking Menu            . In Warning                Component Features     
  . Buffer Pools            . Active / Admin          > Db2 Event Traces       
  . EDM Pool                . Summary By Area         . Db2 IFCID Traces       
  . Dynamic SQL Cache       . Workload Objectives     . MVDb2/DC Admin/Archive
  > Static SQL Cache          Db2 System              . CATALOG MANAGER Local  
  . RID Pool                > ZPARM Menu              . CATALOG MANAGER-Remote
  . Logging                 > Db2 Topic Index         * Pool Advisor           
  > DDF Menu                > FullScreen Menu           Tools And Menus        
  . Page Set Status         . Db2 Storage Use         . Set Target Context     
  . Volume I/O Summary      . IRLM Storage Use(V11+)  > SSI Easy Menu          
  > Page Set Menu           . Journal Log             > DBA Easy Menu          
  > Tuning Wizards                                    > MAIN Menu              
  > Tuning Wizards                                    > MAIN Menu           
                                                      . BBI-SS PAS Info     
                                                      . BBI-SS Parm Info    
                                                      . Return...           
                                                      > What's New

To select the target Db2 that you want to analyze

Use one of the following methods:

  • Hyperlink on Set Target Context to see a list of targets; then, place your cursor in the Target column and press Enter to hyperlink to a different target.
  • Type CON target on the COMMAND line, where CON target is the name of the Db2 target that you want.

Notice that the Tools And Menus section provides hyperlinks to several other easy menus.

This section contains the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*