Default language.

Checking Db2 status

Use the following procedure to check the status of the target Db2.

To check the status of the target Db2

Related topic

Analyzing-a-specific-Db2

  1. From EZDB2, hyperlink on Db2 Status Summary.This link takes you to the STDB2 view (Checking-the-status-of-all-Db2-subsystems), but only one Db2 is displayed.
  2. To review recent history, on the COMMAND line type TIME * * 2H to see the last 2 hours by 15-minute intervals.

  3. Type INCLUDE TIME to see the times (the Intvl Time column is added to the view).

    >W1 =STDB2=============DEEO=====*========05JUL2016==11:38:34====MVDB2====D====1
    +  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.0      0.0     0                      0

    Tip

    If you needed to analyze a time period further, you could hyperlink on that period (although doing so is not recommended for this practice session).

  4. Reset to current time by typing TIME * * 1I and then EXCLUDE TIME.

  5. Hyperlink on Db2 Target to see a detail status view.

    Important

    You can also access the STDB2D view by selecting one Db2 from STDB2 in SSI mode.

    >W1=STDB2====STDB2D===DB2HC====*========10MAR2011==16:57:54====MVDB2====D====1
     Db2 Status                                                                   
    > EZDB2       .STDB2DS              >EZDSTATD  .Threads   .Threads   .Thd    
    .THDACTV      Connect    Active     In Db2     Queued     Suspended   CPU%   
    TSO........         0           0        0            0           0       0.0
                                                                                
    Batch......         4           4        0            0           0       0.0
    --BATCH....         0           0        0            0           0       0.0
    --CAF......         4           4        0            0           0       0.0
    --Utility..         0           0        0            0           0       0.0
                                                                                
    IMS........         0           0        0            0           0       0.0
    CICS.......         0           0        0            0           0       0.0
    DBAT.......         0           0        0            0           0       0.0
    RRSAF......         0           0        0            0           0       0.0
    SYS THRDS..       213           0        0            0           0       0.0
    *Total*....       217           4        0            0           0       0.0
    Actv S-Proc                     0        0                                   
                                                                                
                             0..50.100             0..50.100                     
                  EDM Pool              Db2 CPU%                                 
                  EDM Fail          0   BP Thresh         0                      
                  RLF:       INACTIVE   DDF:       ACTIVE                        
    DBM1 Stor:.   Available   1379.11   In Use        60.00   Total MVS    128.89
    BP Rates:..   Getpage         0.1   Reads             0   Writes          0.0
    Locking:...   Suspend           0   Deadlocks         0   Timeouts          0
    Exceptions:   Monitor           0   System            0   User Thrd         0
    Data Sets:.   Open            124   Open HWM        124   In-use            5
    Parallel:..   Maximum           0   Groups            0   Fallback          0
    Routine:...   Calls             0   Abends            0   Timeouts          0
    GBP Rates..   Reads           0.0   Writes          0.0   Failures        0.0
    Paging:....   Db2             0.0   System          0.0              
    Db2 Start:.   Date       24JUN200   Time       07:09:30              
    Traces        Ifibuff      262144   Monsize      262144

    This view shows an overview of current thread activity per attach type, and key indicators of recent performance:

    • The top of the view includes several hyperlinks.
    • The middle includes hyperlinks to threads of different connect types.
    • The bottom includes hyperlinks in the key indicators.

    There are several hyperlinks at the top of the view, in addition to hyperlinks to threads of different connect types in the middle of the view, and others in the key indicators shown at the bottom of the view.

  6. Use the STDB2DS hyperlink at the top of the view to see totals since Db2 startup instead of current interval values in the key indicator fields.
  7. Use the >EZDSTATD option at the top of STDB2D to see the Db2 Stats Detail easy menu.This easy menu resembles the Db2 Status easy menu, EZDSTAT, that you saw earlier, but the hyperlinks here take you directly to detailed statistics views for this Db2.

  8. From EZDSTATD, hyperlink on SQL Counts to see STSQLD as an example of these detailed statistics views.

     W1 =EZDSTATD=STSQLD===DEEO=====*========05JUL2016==11:42:48====MVDB2====D====1
    SQL Counts Detail.........                                                    
                                Interval   Session                                 
     Data Manipulation Language                                                    
      SELECT...................        0         0                                 
      INSERT...................        0         0                                 
      UPDATE...................        0         0                                 
      DELETE...................        0         0                                 
      DESCRIBE.................        0         0                                 
      PREPARE..................        0         0                                 
      OPEN.....................        0         0                                 
      FETCH....................        0         0                                 
      CLOSE....................        0         0                                 
      DECLARE GLOBAL TEMP TABLE        0         0                                 
      MERGE....................        0         0                                 
      RENAME INDEX.............        0         0                                 
      TRUNCATE TABLE...........        0         0                                 
     Data Definition Language..                                                    
      CREATE TABLE.............        0         0                                 
             INDEX.............        0         0                                 
             TABLESPACE........        0         0
  9. Press F3 to return to EZDSTATD.
  10. Press F3 to return to STDB2D.
  11. Hyperlink on TSO to see a tabular view of current TSO users.You have stepped through several status views now. However, some information is not available in windows mode. Examples are information about IBM CICS connections, IBM Db2 logging, DSNZPARM values, and so on.
  12. Press F3 to return to EZDB2.
  13. Hyperlink on Exception Menu.In addition to access to the exception displays that you have seen before, the Exception Menu also has a hyperlink to the  ALERTS view. This view consolidates monitor exceptions and those produced by alarms defined in . The view also contains hyperlinks to the Alerts Menu and to .
  14. Press F3 to return to EZDB2.

 

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