Checking the status of all Db2 subsystems

Use the following procedures to access windows mode and get acquainted with the views that are available for monitoring multiple Db2s.

To check the status of all Db2s

Related topic

Checking-Db2-status-and-activity

  1. On EZDSSI, hyperlink on SSI Status - List DB2s.This link takes you to the STDB2 view, maintaining the default context of ALL, which includes all defined Db2s.

    >W1 =STDB2============(ALL======*=======)ddmmmyyyy==11:29:55====MVDB2====D====7
    +  Db2 Status / Statistics                                     + Show Header   
     Db2        Act  Log%  Comm  Getpg  Lockout Total                Dataset  Datas
    Target     Thrd Util  Rate   Rate     Rate Excpt Warning Msg     In-Use     Op
    DEEO          3    0   0.0    0.1      0.0     0                      0       
     DEHF          9    7   0.0    0.1      0.0     1                      0       
     DEHL          4    0   0.0    0.0      0.0     0                      0       
     DEJP          3    3   0.0    0.0      0.0     0                      0       
     DJP1          6   18   0.0    0.0      0.0     1                      0       
     DJP2          6    8   0.0    0.0      0.0     1                      0       
     DLL2          2    0   0.0    0.0      0.0     0                      0

    You can quickly gauge how well each of your Db2 subsystems are performing by reviewing and comparing the number of active threads, key activity rates, a total exception count, and the most critical warning condition that exists right now (if any). The angle bracket (>) preceding W1 in the window information line indicates that you can scroll right for more data.

    You can move view fields around and set thresholds to customize the view to meet your monitoring needs (or even create different views for different conditions). For more information, see Using BMC AMI Ops products.

    A hidden header beneath the window information line provides direct navigation to related views and identifies the row hyperlinks in the view.

  2. Display and review the header options:

    1. Place the cursor on the Show Header field and press Enter.The top of the header provides hyperlinks to all related statistics views. The bottom of the header describes the row hyperlinks within the STDB2 view.

      Several of the column headers are highlighted, indicating that you can choose a row in that column. From each row, you can hyperlink to a view with more detail (related to that column) for the selected Db2.

      If you see a warning message for one Db2, place the cursor on that message and press Enter to list the warning conditions that are tracked per Db2. If multiple conditions exist at the same time, only the most important is shown in STDB2, and the others are set to YES in this view. Press F3 to return to STDB2.

      Important

      You can use this hyperlink to see the list even if the warning message field is blank (in which case the conditions will be set to NO). The view also shows the versions of the Db2 subsystem and BMC AMI Ops Monitor for Db2.

    2. Select Hide Header and press Enter when you are finished.
  3. Hyperlink on the Db2 Target field for an active Db2 to see a detail status view.
  4. Press F3 to return to STDB2.You will return to a detail status view later.

  5. Hyperlink on the Comm Rate field for an active Db2 to see counts and rates of activity in that Db2, both for the current interval (1 to 15 minutes) and for the total session data since Db2 startup.

    >W1 =STDB2====STRATE==(ALL======JXODEEO=)07JUL2016==10:01:51====MVDB2====D====1
    Activity....  Interval    Session  Interval   Session  Interval   Session    I
       Rates.....       Qty        Qty      Rate      Rate   /Thread   /Thread     
                                                                                  
     Commits.....         8        693       0.0       0.0       0.0      53.3     
     Thd Creates.         0         13       0.0       0.0                         
                                                                                  
     Getpages....        93       6361       0.2       0.2       0.0     489.3     
     Page Updates         2        519       0.0       0.0       0.0      39.9     
     Sync I/O....         0        227       0.0       0.0       0.0      17.5     
     Prefetch I/O         0          0       0.0       0.0       0.0       0.0     
     Write I/O...         2        323       0.0       0.0       0.0      24.8     
     DatasetOpens         0         50       0.0       0.0       0.0       3.8     
                                                                                  
     Lockouts....         0          0       0.0       0.0       0.0       0.0     
     LockSuspends         0          5       0.0       0.0       0.0       0.4     
     GBLLockCont.         0          0       0.0       0.0       0.0       0.0     
     Clm/Drn Fls.         0          0       0.0       0.0       0.0       0.0     
     DML SQL.....        32       2748       0.1       0.1       0.0     211.4     
     StProcCalls.         0          0       0.0       0.0       0.0       0.0     
     StProcFails.         0          0       0.0       0.0       0.0       0.0

    Some of these fields are highlighted, indicating that hyperlinks will take you to more detail.

  6. Press F3 until you return to EZDSSI.

  7. Hyperlink on the Db2 Dashboard field to see critical, current interval measurements for all of the Db2 subsystems in the current SSI context.This view can help you quickly gauge the status of all the Db2 subsystems.

    >W1 =STDASHB==========(ALL======*=======)10MAR2011==12:31:24====MVDB2====D====8
     Db2       Db2      Warning       DBM1 Stor System Monitor Thread Suspnds  DDF
     Target    Status   Message       Available Except  Except Except Lock/Lt Actv
     DECE      ACTIVE                      1400      0       2      0       0 ACTV
     DEDM      ACTIVE   RunawayQuery       1372      0       0      2       0 ACTV
     DEEO      INACTIVE                                                           
     DHH1      INACTIVE                                                           
     DHH2      ACTIVE                      1401      0       0      0       0 INAC
     DHW1      INACTIVE                                                           
     DHW2      ACTIVE                      1398      0       1      0       0 ACTV
     DIB2      ACTIVE                      1393      0       2      0       0 ACTV

    The first 10 columns in the view are highlighted in reverse video. Green highlighting indicates acceptable values. Red highlighting indicates values that should be analyzed for potential problems.

  8. Scroll right to see several other key indicators of system health, such as hit ratios and failure counts.
  9. Press F3 to return to EZDSSI.

 

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