Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Using the Db2 topic index menu

Instead of always using the menu navigation, you can quickly find the views that you want through topic index views. For this practice procedure, assume that you want to investigate a Db2 performance issue, specifically, data set open and close activity.

To use the Db2 topic index menu

  1. On EZDB2, hyperlink on DB2 Topic Index to access the DB2 Topic Index menu, which provides alphabetic access to the defined topics.

  2. To investigate data set open/close activity, type TOPICD on the COMMAND line to access a list of Db2 topics that start with the letter D.

    Note

    You can complete this action in any BMC AMI Ops Monitor for Db2 view.

     W1 =TOPICD===========DEDM=====*========ddmmmyyyy==16:50:48====MVDB2====D====1
                                                                                  
      DB2 Topic Index - D          View      SSI  Monitor  ZPARM     Acctg   Trace
      Data Base Descriptors (DBD)  STEDMPD    Y    -        -         -       -    
      Data Capture(IFI)            STCHKPD    Y    -       ZPSYSD     -       -    
      Data Definition Control       -         -    -       ZPDDLCTD   -       -    
      Data Manager Crit.Threshold  BFRPL      Y   BPUTL     -         -       -    
      Data Sets                                                                    
       Activity                    STDSAD     Y    -        -         -       -    
       Current Open                STDSAD     Y   DSOPN     -         -       -    
       Deferred (Pseudo) Close     STDSAD     Y    -       ZPDSETD    -       -    
       Management                   -         -    -       ZPDSETD    -       -    
       Migrations                  STDSAD     Y   MIGDS     -         -       -    
       Migrations - by BPool       BFRPL      Y    -        -         -       -    
       Open Requests               STDSAD     Y   DSOPR     -         -      EV/DTL
       Opens - by Buffer Pool      BFRPL      Y    -        -         -       -    
       Recall Timeouts             STDSAD     Y   RTO      ZPDSETD    -       -    
       Recall Timeouts-by Bpool    BFRPLD     Y   RTO      ZPDSETD    -       -    
       Utilization                 STDB2D     -   DSUTL    ZPDSETD    -       -    
      Data Sharing                 EZDSHAR    Y    -       ZPDSHRD    -       -    
       Castout Definitions          -         -    -       ZPBFMGRD   -       -    
       GBP Data-Group              STGBFRPD   Y    -        -         -       -    
       Locking                     STGBLLKD   Y    -       ZPDSHRD    -       -    
       Wizard- Data Sharing        WZDSHAR    Y    -        -         -       -    
      DBAS CPU                     STDBSYSD   Y    -        -         -       -    
      DB2 Definitions               -         -    -       ZPDB2D     -       -    
      DB2 Statistics               EZDSTATD   Y    -        -         -       -    
      DB2 Status                   STDB2D     Y    -        -         -       -    
      DB2 System Definitions        -         -    -       ZPSYSD     -       -    
      DBATs - Activity             THDDBAT    Y    -        -        HT      SUM   
       Active / Pooled             STDISTD    Y   THDAC     -         -       -    
       Queued                      STDISTD    Y   DBTQD    ZPTHDD     -       -    
       Thread Control ZPARMs        -         -    -       ZPDDFD     -       -    
                                                                                  
      . Link to next page (D2)
  3. In the resulting list of topics, locate Data Sets.Several entries appear under this topic, including several for open/close activity. The first hyperlink column is usually the one you want to take when looking at a single Db2, but you can also access similar SSI views, access related monitors and ZPARMs, and identify relevant trace data.
  4. Hyperlink on STDSAD to see the view of that name, which shows the statistics that you need.
  5. Press F3 until you return to EZDB2.

Related topic

Analyzing-a-specific-Db2

 

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