DB2 Command Statistics

This panel shows information about current DB2® command activity.

 ________________ ZCMDS    VTM     O2       V540./C SE11 07/30/13  1:50:15   2  
>        Help PF1          Back PF3            Up PF7          Down PF8         
> R.L                                                                           
>                                                                               
> H-HISTORICAL                                                                  
=============================================================================== 
>                          DB2 COMMANDS STATISTICS                              
                                                                                
 CMDS                                                                           
+ Collection Interval:  REALTIME                         Start:  07/30 01:49:09 
+ Report Interval:       1 min                             End:  07/30 01:50:15 
+                                                                               
+                                              TOTAL  INTERVAL  /SECOND    % OF 
+ DB2 Command                               QUANTITY  QUANTITY  (   66)   TOTAL 
+ ----------------------------------------  --------  --------  -------  ------ 
+ ALTER BUFFERPOOL                                 0         0      .00      .0 
+ ALTER GROUPBUFFERPOOL                            0         0      .00      .0 
+ ALTER UTILITY                                    0         0      .00      .0 
+ ARCHIVE LOG                                      0         0      .00      .0 
+ CANCEL (DDF) THREAD                              0         0      .00      .0 
+ DISPLAY ARCHIVE                                  0         0      .00      .0 
+ DISPLAY BUFFERPOOL                               0         0      .00      .0 
+ DISPLAY DATABASE                                 1         0      .00      .0 
+ DISPLAY GROUP                                  260         0      .00      .0 
+ DISPLAY GROUPBUFFERPOOL                          0         0      .00      .0 
+ DISPLAY LOCATION                                 0         0      .00      .0 
+ DISPLAY PROCEDURE                                0         0      .00      .0 
+ DISPLAY RLIMIT                                   0         0      .00      .0 
+ DISPLAY THREAD                                   0         0      .00      .0 
+ DISPLAY TRACE                                    0         0      .00      .0 
+ DISPLAY UTILITY                                  0         0      .00      .0 
+ DISPLAY FUNCTION                                 0         0      .00      .0 
+ DISPLAY LOG                                      0         0      .00      .0 
+ MODIFY TRACE                                     0         0      .00      .0 
+ RECOVER BSDS                                     0         0      .00      .0 
+ RECOVER INDOUBT                                  0         0      .00      .0 
+ RESET INDOUBT                                    0         0      .00      .0 
+ RESET GENERICLU                                  0         0      .00      .0 
+ SET ARCHIVE                                      0         0      .00      .0 
+ START DATABASE                                   0         0      .00      .0 
+ START DB2                                        1         0      .00      .0 
+ START DDF                                        0         0      .00      .0 
+ START PROCEDURE                                  0         0      .00      .0
+ START RLIMIT                                     0         0      .00      .0
+ START TRACE                                     55         0      .00      .0

+ START FUNCTION                                   0         0      .00      .0
+ STOP DATABASE                                    0         0      .00      .0
+ STOP DB2                                         0         0      .00      .0
+ STOP DDF                                         0         0      .00      .0
+ STOP PROCEDURE                                   0         0      .00      .0
+ STOP RLIMIT                                      0         0      .00      .0
+ STOP TRACE                                      39         0      .00      .0
+ STOP FUNCTION                                    0         0      .00      .0
+ TERM UTILITY                                     0         0      .00      .0
+ SET LOG                                          0         0      .00      .0
+ DISPLAY ACCEL                                    1         1      .02    10.0
+ START ACCEL                                      1         1      .02    10.0
+ STOP ACCEL                                       1         1      .02    10.0
+ SET SYSPARM                                      0         0      .00      .0
+ DISPLAY DDF                                      1         1      .02    10.0
+ ACCESS DATABASE                                  0         0      .00      .0
+ START PROFILE                                    1         1      .02    10.0
+ STOP PROFILE                                     1         1      .02    10.0
+ DISPLAY PROFILE                                  3         3      .05    30.0
+ MODIFY DDF                                       1         1      .02    10.0
+ ACTIVATE FUNCTION LEVEL                          1         0      .00      .0 
+ START DYNQUERYCAPTURE                            3         0      .00      .0 
+ STOP DYNQUERYCAPTURE                             2         0      .00      .0 
+ DISPLAY DYNQUERYCAPTURE                         10         0      .00      .0 
+ UNRECOGNIZED COMMAND                             1         0      .00      .0
+                          Total                 367        10      .15   100.0
===============================================================================

Navigation

For additional information about

Near-term history activity, select option H-HISTORICAL at the top of the panel.
other topics, use the PF keys.

Fields

Total Quantity - activity since DB2 was started.
Interval Quantity - activity during the last cycle.
Rate per second during the last cycle.
Percentage of total commands since DB2 was started.

ALTER BUFFERPOOL: ALTER BUFFERPOOL commands executed to alter attributes for active or inactive buffer pools.
ALTER GROUP BUFFERPOOL: ALTER GROUPBUFFERPOOL commands executed to alter attributes of group buffer pools.
ARCHIVE LOG: ARCHIVE LOG commands executed to initiate a DB2 active log switch.
CANCEL DDF THREAD: CANCEL DDF THREAD commands executed to cancel a thread.
DISPLAY ARCHIVE: DISPLAY ARCHIVE commands executed to display input archive log information.
DISPLAY BUFFERPOOL: DISPLAY BUFFERPOOL commands executed to display statistics for active or inactive buffer pools.
DISPLAY DATABASE: DISPLAY DATABASE commands executed to display status information about tablespaces and indexspaces within a database.
DISPLAY GROUP: DISPLAY GROUP commands executed to display statistics about the data sharing group to which the DB2 subsystem belongs.
DISPLAY GROUP BUFFERPOOL: DISPLAY GROUPBUFFERPOOL commands executed to display attributes of group buffer pools.
DISPLAY LOCATION: DISPLAY LOCATION commands executed to display statistics about threads with distributed relationships.
DISPLAY PROCEDURE: DISPLAY PROCEDURE commands executed to display statistics about stored procedures.
DISPLAY RLIMIT: DISPLAY RLIMIT commands executed to display the current status of the resource limit facility.
DISPLAY THREAD: DISPLAY THREAD commands executed to display status information about DB2 threads.
DISPLAY TRACE: DISPLAY TRACE commands executed to display a list of active traces.
DISPLAY UTILITY: DISPLAY UTILITY commands executed to display status information about DB2 utility jobs.
MODIFY TRACE: MODIFY TRACE commands executed to change the IFCIDs being traced for an active trace.
RECOVER BSDS: RECOVER BSDS commands executed to recover a boot strap data set that has been disabled by an error.
RECOVER INDOUBT: RECOVER INDOUBT commands executed to recover threads left in the indoubt status.
RESET GENERICLU: RESET GENERICLU commands executed to purge information stored by VTAM® in the coupling facility for one or more partners of a particular DB2 subsystem.
RESET INDOUBT: RESET INDOUBT commands executed to purge indoubt thread information.
SET ARCHIVE: SET ARCHIVE commands executed to change the maximum tape units and the de-allocation time parameters originally set in the installation parameters.
START DATABASE: START DATABASE commands executed to make stopped databases available for use.
START DB2: START DB2 commands executed.
START DDF: START DDF commands executed to start the distributed data facility.
START PROCEDURE: START PROCEDURE commands executed to activate the definition of a stored procedure which was stopped, or refreshes a stored procedure that is cached.
START RLIMIT: START RLIMIT commands executed to start the resource limit facility.
START TRACE: START TRACE commands executed to begin collection of DB2 trace records.
STOP DATABASE: STOP DATABASE commands executed to make specified databases unavailable for use.
STOP DB2: STOP DB2 commands executed.
STOP DDF: STOP DDF commands executed to stop the distributed data facility.
STOP PROCEDURE: STOP PROCEDURE commands executed to prevent DB2 from accepting SQL CALL statements for one or more stored procedure.
STOP RLIMIT: STOP RLIMIT commands executed to stop the resource limit facility.
STOP TRACE: STOP TRACE commands executed to stop collection of DB2 trace records.
TERM UTILITY: TERM UTILITY commands executed to terminate execution of a utility job.
SET LOG: Set Log commands that are executed to modify the checkpoint frequency that are specified during installation.

DISPLAY ACCEL: Display Accelerator commands that are executed to display details about accelerators that are connected to the current subsystem.
START ACCEL: Start Accelerator commands that are executed to activate an accelerator.
STOP ACCEL: Stop Accelerator commands that are executed to deactivate an accelerator.
SET SYSPARM: The number of DB2 SET SYSPARM commands that are issued. This includes normal and abnormal completion of the command.
DISPLAY DDF: The number of DB2 DISPLAY DDF commands that are issued. This includes normal and abnormal completion of the command.
ACCESS DATABASE: The number of DB2 ACCESS DATABASE commands that are issued. This includes normal and abnormal completion of the command.
START PROFILE: The number of DB2 START PROFILE commands that are issued. This includes normal and abnormal completion of the command.
STOP PROFILE: The number of DB2 STOP PROFILE commands that are issued. This includes normal and abnormal completion of the command.
DISPLAY PROFILE: The number of DB2 DISPLAY PROFILE commands that are issued. This includes normal and abnormal completion of the command.
MODIFY DDF: The number of DB2 MODIFY DDF commands that are issued. This includes normal and abnormal completion of the command.; This field is only displayed for DB2 10 or above.
ACTIVATE FUNCTION LEVEL (Q9STCTEN): The number of DB2 ACTIVATE FUNCTION LEVEL commands issued. This includes normal and abnormal completion of the command. DB2 12 and later.
START DYNQUERYCAPTURE (Q9STCTSQ): The number of DB2 START DYNQUERYCAPTURE commands issued. This includes normal and abnormal completion of the command. DB2 12 and later.
STOP DYNQUERYCAPTURE (QSTCTXQ): The number of DB2 STOP DYNQUERYCAPTURE commands issued. This includes normal and abnormal completion of the command. DB2 12 and later.
DISPLAY DYNQUERYCAPTURE (Q9STCTDQ): The number of DB2 DISPLAY DYNQUERYCAPTURE commands issued. This includes normal and abnormal completion of the command. This field only shown for DB2 12 and later.

UNRECOGNIZED COMMAND: Number of unrecognized commands.
Total: All DB2 commands.

Feedback