DB2 Command Statistics Detail
This panel provides detailed statistics about DB2® command activity during a selected report interval.
________________ ZHCMD VTM O2 V540./C SE11 07/30/13 1:47:48 2
> A-SUBSYSTEM SUPPORT B-BIND C-BUFFER POOL D-GROUP BP
> E-DISTRIBUTED DATABASE F-EDM POOL G-LOG MANAGER H-OPEN/CLOSE
> I-SQL/RID/PARALLEL/PROC J-LOCK/CLAIM/DRAIN K-GLOBAL LOCK *-DB2 COMMANDS
> M-THREAD HISTORY
===============================================================================
> DB2 COMMAND STATISTICS DETAIL
HCMD
+ Collection Interval: 1 min Start: 07/30 01:46
+ Report Interval: 2 min Combine Level: NONE End: 07/30 01:47
+
+ INTERVAL /MINUTE % OF
+ DB2 Command QUANTITY ( 2) TOTAL
+ ---------------------------------------- -------- ------- ------
+ ALTER BUFFERPOOL 0 .00 .0
+ ALTER GROUPBUFFERPOOL 0 .00 .0
+ ALTER UTILITY 0 .00 .0
+ ARCHIVE LOG 0 .00 .0
+ CANCEL (DDF) THREAD 0 .00 .0
+ DISPLAY ARCHIVE 0 .00 .0
+ DISPLAY BUFFERPOOL 0 .00 .0
+ DISPLAY DATABASE 0 .00 .0
+ DISPLAY GROUP 0 .00 .0
+ DISPLAY GROUPBUFFERPOOL 0 .00 .0
+ DISPLAY LOCATION 0 .00 .0
+ DISPLAY PROCEDURE 0 .00 .0
+ DISPLAY RLIMIT 0 .00 .0
+ DISPLAY THREAD 0 .00 .0
+ DISPLAY TRACE 0 .00 .0
+ DISPLAY UTILITY 0 .00 .0
+ DISPLAY FUNCTION 0 .00 .0
+ DISPLAY LOG 0 .00 .0
+ MODIFY TRACE 0 .00 .0
+ RECOVER BSDS 0 .00 .0
+ RECOVER INDOUBT 0 .00 .0
+ RESET INDOUBT 0 .00 .0
+ RESET GENERICLU 0 .00 .0
+ SET ARCHIVE 0 .00 .0
+ START DATABASE 0 .00 .0
+ START DB2 0 .00 .0
+ START DDF 0 .00 .0
+ START PROCEDURE 0 .00 .0
+ START RLIMIT 0 .00 .0
+ START TRACE 0 .00 .0
+ START FUNCTION 0 .00 .0
+ STOP DATABASE 0 .00 .0
+ STOP DB2 0 .00 .0
+ STOP DDF 0 .00 .0
+ STOP PROCEDURE 0 .00 .0
+ STOP RLIMIT 0 .00 .0
+ STOP TRACE 0 .00 .0
+ STOP FUNCTION 0 .00 .0
+ TERM UTILITY 0 .00 .0
+ SET LOG 0 .00 .0
+ DISPLAY ACCEL 0 .00 .0
+ START ACCEL 0 .00 .0
+ STOP ACCEL 0 .00 .0
+ SET SYSPARM 0 .00 .0
+ DISPLAY DDF 0 .00 .0
+ ACCESS DATABASE 0 .00 .0
+ START PROFILE 0 .00 .0
+ STOP PROFILE 0 .00 .0
+ DISPLAY PROFILE 0 .00 .0
+ MODIFY DDF 0 .00 .0
+ ACTIVATE FUNCTION LEVEL 0 .00 .0
+ START DYNQUERYCAPTURE 0 .00 .0
+ STOP DYNQUERYCAPTURE 0 .00 .0
+ DISPLAY DYNQUERYCAPTURE 0 .00 .0
+ UNRECOGNIZED COMMAND 0 .00 .0
+ Total 0 .00 .0
===============================================================================
Navigation
For additional information about
- related topics, select one of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- Collection Interval
- The time interval specified for the collection of near-term history data. This unit of time was specified when the Near-Term History Data Collector was started.
- Start
- The start time of the interval currently displayed.
- Report Interval
- This field determines the report interval. It is set on the Near-Term History Report Option panel.
- Combine Level
- This field reflects the selected combine level.
If Combine Level is NONE, the report interval is the same as the collection
interval. Possible values:
- HOURLY
- Data will be reported in hourly intervals.
- NONE
- Data will be reported in the time unit specified by the collection interval.
- End
- The end time of the interval currently displayed.
For each field described below the following statistics are provided:
- Interval quantity, which is the activity during the interval.
- Rate per minute during the interval.
- Percentage of total commands during the interval.
- ALTER BUFFERPOOL
- ALTER BUFFERPOOL commands executed to alter attributes for active or inactive buffer pools.
- ALTER GROUPBUFFERPOOL
- ALTER GROUPBUFFERPOOL commands executed to alter attributes for group buffer pools.
- ALTER UTILITY
- ALTER UTILITY commands executed to change the values of certain parameters of an execution of the REORG utility that uses SHRLEVEL REFERENCE or CHANGE.
- ARCHIVE LOG
- ARCHIVE LOG commands executed to initiate a DB2 active log switch.
- CANCEL (DDF) THREAD
- CANCEL DDF THREAD commands executed to cancel a distributed 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 GROUPBUFFERPOOL
- DISPLAY GROUPBUFFERPOOL commands executed to display attributes of group buffer pools.
- DISPLAY LOCATION
- DISPLAY LOCATION commands executed to display statistics of threads with distributed relationships.
- DISPLAY PROCEDURE
- DISPLAY PROCEDURE commands execute 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.
- DISPLAY FUNCTION
- DISPLAY FUNCTION specific commands executed to display statistics about external user-defined functions accessed by DB2 applications.
- DISPLAY LOG
- DISPLAY LOG commands executed to display log information and the status of the offload task.
- 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 deallocation 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 is stopped, or which 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.
- START FUNCTION
- START FUNCTION specific commands executed to activate an external function that is stopped. Built-in functions or user-defined functions that are sourced on another function cannot be started.
- 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 procedures.
- 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.
- STOP FUNCTION
- STOP FUNCTION specific commands executed to prevent DB2 from accepting SQL statements with invocations of the specified functions. You cannot stop built-in functions or user-defined functions that are sourced on another function.
- TERM UTILITY
- TERM UTILITY commands executed to terminate execution of a utility job.
- SET LOG
- SET LOG commands executed to modify the checkpoint frequency 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.