Skip to Content
Information
Limited support BMC 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 .

Checking current group activity

Use the following procedure to check the health of each member of your data sharing group and their activity levels. The previous dialogs covered multiple Db2 subsystems and their active threads. For data sharing, you focus on a data sharing group, instead of the default SSI context of ALL (which earlier procedures used).

Warning

Note

You must set the context when checking group activity. The context should be set already (set in the previous procedure). For future reference, you can set the context by typing CON context (for example, CON DBGHC to set the context to the DBGHC group).

To view activity for a data sharing group

  1. Select options from the EZDSSI menu to look at only this group:
    • Select SSI Status - List DB2s to view a list of the Db2s in the data sharing group. This version of the STDB2 view is a good place to see how each Db2 member is performing. You can also drill down into details about a member.
    • Select Current Threads (Elap) to view all threads in the data sharing group, sorted by elapsed time.
  2. Press F3 to return to EZDSSI .

  3. Select the Data Sharing Wizard option.

    W1 =WZDSHAR==========(ALL======DB2K====)ddmmmyyyy==15:52:00====MVDB2====D====1
     ** DATA SHARING WIZARD **         Group Name......... DBGK               
                                       #DB2s..............        2           
     . >> Set Context to Group                                                
                                                         Interval  Session
    Look at all Members?              Changed Page Writes        0        0
    . Review Group (Session)          Read Hits..........        0        0
    Narrow Focus from Session/Now?
    . Review History and Set TIME
    Global Locking                    (Tgt) Lockouts.....        0        0
    . Lock Contention Wizard          (Tgt) % Global Cont      0.0      0.0
    . CF Structures (MVMVS)
    GBPs Right Size/Ratio?            Read Hit Ratio.....      0.0      0.0
    . Check GBPs                      XIs-Dir. Reclaims..        0        0
                                      Write Failures.....        0        0
    Page Set Considerations?
    . Check GBP-DEP by GBP/PS         (Tgt) GBP-Dep......                 0
    . Check GBP-DEP by Member
    . Check I/O per Volume (SSI)
    Castout/Checkpoints Effective?    Pages Castout......        0        0
    . Check Thresholds & Activity
    All OK?  Congratulations!
      (PF3 to Exit Wizard)

    This wizard collects the most used options for data sharing in one place. You can access group buffer pool activity and status, global lock contention, and page set analysis that summarizes activity from all members. You will return here later.

    Warning

    Note

    The rest of this exercise covers use of the wizards, but you also have direct access to some detailed data views here.

  4. To find information quickly about data sharing, use the topic index to look up relevant Db2 terms, such as 'Group Buffer Pools' and 'GBP-Dependent' in the TOPIC G view or 'Locks-Global' in the TOPICL view.

    Success

    Tip

    At any point when looking at another view, you can enter view name TOPICx to directly access topics starting with that letter; for example, type TOPIC L for lock information.

     W1 =TOPICL===========(ALL======*=======)ddmmmyyyy==16:19:45====MVDB2====D===
    DB2 Topic Index - L         View     SSI Monitor ZPARM    Acctg  Trac
    Latch Waits                  -        -   -       -        -     DTL
    List Prefetch               BFRPL     Y  PFL*     -       TSTAT   -
    LOBs
     Access                      -        -   -       -       HT     SUM
     Storage                    STDBSYSD  Y  LOBMX   ZPSTGD    -      -
    Local SQL Cache             STCACHED  Y   -      ZPTHDD    -      -
    Locks
     Activity                   STLOCKD   Y   -      ZPIRLMLD HT      -
     Avoidance(Commit LSN)       -        -   -       -        -     DTL
     Contention                 WZLOCK    Y   -      ZPIRLMLD  -      -
     Current Held               LOCKU     -   -       -        -      -
     Current Object             LOCKD     -   -       -        -      -
     Current Susp. Threads      THDACTV   Y   -       -        -      -
     Escalations                STLOCKD   Y  LESCL    -       HT(X)  DTL
     Global Suspends            STGBLLKD  Y  GSUSP    -       TSTAT   -
     Maximums-NUMLKUS/TS         -        -   -      ZPIRLMLD  -      -
     Physical                   STGBLLKD  Y   -       -        -     LOCK
     Suspends                   STLOCKD   Y  IN(*)   ZPIRLMLD HT     DTL
     Timeout Factors             -        -   -      ZPIRLMLD  -      -
     Waits                       -        -   -       -       TSTAT  SUM
     Global                     STGBLLKD  Y   -       -       TSTAT   -
     IRLM Definitions            -        -   -      ZPIRLMDD  -      -
    Lockouts                    STLOCKD   Y  IN(*)   ZPIRLMLD HT(X)  EV/D
    LOCK TABLE Statements       STSQLD    Y   -       -       TSTAT  SUM
    Logging
     Buffers                    STLOGD    Y   -      ZPLOGD    -      -
     Buffer Waits               STLOGD    Y  LOGWT    -        -      -
     Reads                      STLOGD    Y  LOGRD    -        -      -
     Writes                     STLOGD    Y  LOGWR    -        -      -
     Write Waits                 -        -   -       -       TSTAT  SUM
    Logical Locks               STLOCKD   Y   -       -       HT      -
    . Link to next page
  5. Press F3 until you return to EZDSSI.

Related topic

Monitoring-a-Db2-data-sharing-group

 

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

BMC AMI Ops Monitor for Db2 12.2