Db2 Commands
This topic shows detailed information about Statistics - Db2 Commands
.
Statistics - Db2 Commands
The field labels shown in the following sample layout of Statistics - Db2 Commands
are
described in the following section.
DB2 COMMANDS QUANTITY /SECOND
--------------------------- -------- -------
DISPLAY DATABASE 0.00 0.00
DISPLAY THREAD 0.00 0.00
DISPLAY UTILITY 0.00 0.00
DISPLAY TRACE 0.00 0.00
DISPLAY RLIMIT 0.00 0.00
DISPLAY LOCATION 0.00 0.00
DISPLAY ARCHIVE 0.00 0.00
DISPLAY BUFFERPOOL 0.00 0.00
DISPLAY GROUPBUFFERPOOL 0.00 0.00
DISPLAY GROUP 0.00 0.00
DISPLAY PROCEDURE 0.00 0.00
DISPLAY FUNCTION 0.00 0.00
DISPLAY LOG 0.00 0.00
DISPLAY DDF 0.00 0.00
DISPLAY PROFILE 0.00 0.00
DISPLAY ACCEL 0.00 0.00
DISPLAY DYNQUERYCAPTURE 0.00 0.00
DISPLAY ML 0.00 0.00
DISPLAY SERVICE 0.00 0.00
DISPLAY BLOCKERS 0.00 0.00
DISPLAY STATS 0.00 0.00
ALTER BUFFERPOOL 0.00 0.00
ALTER GROUPBUFFERPOOL 0.00 0.00
ALTER UTILITY 0.00 0.00
START DATABASE 0.00 0.00
START TRACE 1.00 0.01
START DB2 0.00 0.00
START RLIMIT 0.00 0.00
START DDF 0.00 0.00
START PROCEDURE 0.00 0.00
START FUNCTION 0.00 0.00
START PROFILE 0.00 0.00
START ACCEL 0.00 0.00
START DYNQUERYCAPTURE 0.00 0.00
START ML 0.00 0.00
START SERVICE 0.00 0.00
START CDDS 0.00 0.00
STOP DATABASE 0.00 0.00
STOP TRACE 0.00 0.00
STOP DB2 0.00 0.00
STOP RLIMIT 0.00 0.00
STOP DDF 0.00 0.00
STOP PROCEDURE 0.00 0.00
STOP FUNCTION 0.00 0.00
STOP PROFILE 0.00 0.00
STOP ACCEL 0.00 0.00
STOP DYNQUERYCAPTURE 0.00 0.00
STOP ML 0.00 0.00
STOP SERVICE 0.00 0.00
STOP CDDS 0.00 0.00
DB2 COMMANDS CONTINUED QUANTITY /SECOND
--------------------------- -------- -------
MODIFY TRACE 1.00 0.01
MODIFY DDF 0.00 0.00
CANCEL THREAD 0.00 0.00
TERM UTILITY 0.00 0.00
RUN MLUTIL 0.00 0.00
RECOVER BSDS 0.00 0.00
RECOVER INDOUBT 0.00 0.00
RESET INDOUBT 0.00 0.00
RESET GENERICLU 0.00 0.00
ARCHIVE LOG 0.00 0.00
SET ARCHIVE 0.00 0.00
SET LOG 0.00 0.00
SET SYSPARM 0.00 0.00
ACCESS DATABASE 0.00 0.00
ACTIVATE FUNCTION LEV 0.00 0.00
UNRECOGNIZED COMMANDS 0.00 0.00
TOTAL 2.00 0.01- DISPLAY DATABASE
-
The number of Db2 DISPLAY DATABASE commands issued to view objects within one or more Db2 databases. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR0
- DISPLAY THREAD
-
The number of Db2 DISPLAY THREAD commands issued to view threads active within the Db2 subsystem. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR1
- DISPLAY UTILITY
-
The number of Db2 DISPLAY UTILITY commands issued to view the status of one or more Db2 utilities. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR2
- DISPLAY TRACE
-
The number of Db2 DISPLAY TRACE commands issued to determine the currently active Db2 traces. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRC
- DISPLAY RLIMIT
-
The number of Db2 DISPLAY RLIMIT commands issued to view the current status of the Db2 resource limit facility. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRG
- DISPLAY LOCATION
-
The number of Db2 DISPLAY LOCATION commands issued to display statistics about threads with a distributed relationship. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRL
- DISPLAY ARCHIVE
-
The number of Db2 DISPLAY ARCHIVE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRQ
- DISPLAY BUFFERPOOL
-
The number of Db2 DISPLAY BUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRO
- DISPLAY GROUPBUFFERPOOL
-
The number of Db2 DISPLAY GROUPBUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRT
- DISPLAY GROUP
-
The number of Db2 DISPLAY GROUP commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRX
- DISPLAY PROCEDURE
-
The number of Db2 DISPLAY PROCEDURE commands executed. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRU
- DISPLAY FUNCTION
-
The number of Db2 DISPLAY FUNCTION commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRZ
- DISPLAY LOG
-
The number of Db2 DISPLAY LOG commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX3
- DISPLAY DDF
-
The number of Db2 DISPLAY DDF commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX5
- DISPLAY PROFILE
-
The number of Db2 DISPLAY PROFILE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTSD
- DISPLAY ACCEL
-
The number of Db2 DISPLAY ACCEL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTDA
- DISPLAY DYNQUERYCAPTURE
-
The number of Db2 "-DISPLAY DYNQUERYCAPTURE" commands.
Field Name: Q9STCTDQ
- DISPLAY ML
-
The number of Db2 "-DISPLAY ML" commands.
Field Name: Q9STCTDM
- DISPLAY SERVICE
-
The number of Db2 "-DISPLAY RESTSVC" commands.
Field Name: Q9STCTDR
- DISPLAY BLOCKERS
-
The number of Db2 "-DISPLAY BLOCKERS" commands.
Field Name: Q9STCTBL
- DISPLAY STATS
-
The number of Db2 "-DISPLAY STATS" commands.
Field Name: Q9STCTX7
- ALTER BUFFERPOOL
-
The number of Db2 ALTER BUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRN
- ALTER GROUPBUFFERPOOL
-
The number of Db2 ALTER GROUPBUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRS
- ALTER UTILITY
-
The number of Db2 ALTER UTILITY commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRY
- START DATABASE
-
The number of Db2 START DATABASE commands issued to make a database available for use. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR5
- START TRACE
-
The number of Db2 START TRACE commands issued to initiate a Db2 trace. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR6
- START DB2
-
The number of Db2 START DB2 commands issued to bring up a Db2 subsystem. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR7
- START RLIMIT
-
The number of Db2 START RLIMIT commands issued to enable the Db2 resource limit facility. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRE
- START DDF
-
The number of Db2 START DDF commands issued to enable the Db2 distributed data facility. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRI
- START PROCEDURE
-
The number of Db2 START PROCEDURE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRV
- START FUNCTION
-
The number of Db2 START FUNCTION commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX0
- START PROFILE
-
The number of Db2 START PROFILE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTSS
- START ACCEL
-
The number of Db2 START ACCEL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTSA
- START DYNQUERYCAPTURE
-
The number of Db2 "-START DYNQUERYCAPTURE" commands.
Field Name: Q9STCTSQ
- START ML
-
The number of Db2 "-START ML" commands.
Field Name: Q9STCTSM
- START SERVICE
-
The number of Db2 "-START RESTSVC" commands.
Field Name: Q9STCTSR
- START CDDS
-
The number of Db2 "-START CDDS" commands.
Field Name: Q9STCTS1
- STOP DATABASE
-
The number of Db2 STOP DATABASE commands issued to prevent access to a Db2 database. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR8
- STOP TRACE
-
The number of Db2 STOP TRACE commands issued to terminate one or more active Db2 traces. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR9
- STOP DB2
-
The number of Db2 STOP DB2 commands issued to terminate the Db2 subsystem. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRA
- STOP RLIMIT
-
The number of Db2 STOP RLIMIT commands issued to disable the Db2 resource limit facility. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRF
- STOP DDF
-
The number of Db2 STOP DDF commands issued to disable the Db2 distributed data facility. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRJ
- STOP PROCEDURE
-
The number of Db2 STOP PROCEDURE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRW
- STOP FUNCTION
-
The number of Db2 STOP FUNCTION commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX1
- STOP PROFILE
-
The number of Db2 STOP PROFILE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTST
- STOP ACCEL
-
The number of Db2 STOP ACCEL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTXA
- STOP DYNQUERYCAPTURE
-
The number of STOP DYNQUERYCAPTURE Db2 commands.
Field Name: Q9STCTXQ
- STOP ML
-
The number of Db2 "-STOP ML" commands
Field Name: Q9STCTPM
- STOP SERVICE
-
The number of Db2 "-STOP RESTSVC" commands.
Field Name: Q9STCTPR
- STOP CDDS
-
The number of Db2 "-STOP CDDS" commands
Field Name: Q9STCTS2
- MODIFY TRACE
-
The number of Db2 MODIFY TRACE commands issued to alter trace events (IFCIDs) for an active trace. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRH
- MODIFY DDF
-
The number of Db2 MODIFY DDF commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTMD
- CANCEL THREAD
-
The number of Db2 CANCEL THREAD commands issued to cancel a thread. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRK
- TERM UTILITY
-
The number of Db2 TERM UTILITY commands issued to stop execution of a Db2 utility. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRB
- RUN MLUTIL
-
The number of Db2 "-RUN MLUTIL" commands.
Field Name: Q9STCTX6
- RECOVER BSDS
-
The number of Db2 RECOVER BSDS commands issued to reestablish dual bootstrap data sets after one has been disabled by a data set error. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR3
- RECOVER INDOUBT
-
The number of Db2 RECOVER INDOUBT commands issued to recover threads left indoubt because Db2 or a transaction manager could not automatically recover them. This includes normal and abnormal completion of the command.
Field Name: Q9STCTR4
- RESET INDOUBT
-
The number of Db2 RESET INDOUBT commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRR
- RESET GENERICLU
-
The number of Db2 RESET GENERICLU commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRD
- ARCHIVE LOG
-
The number of Db2 ARCHIVE LOG commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRM
- SET ARCHIVE
-
The number of Db2 SET ARCHIVE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRP
- SET LOG
-
The number of Db2 SET LOG commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX2
- SET SYSPARM
-
The number of Db2 SET SYSPARM commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX4
- ACCESS DATABASE
-
The number of Db2 ACCESS DATABASE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTAD
- ACTIVATE FUNCTION LEV
-
The number of Db2 "-ACTIVATE FUNCTION LEVEL" commands.
Field Name: Q9STCTEN
- UNRECOGNIZED COMMANDS
-
The number of commands not recognized by Db2. The number is incremented if the command verb or primary keyword cannot be determined. For example:
- "-DISPLOX DATABASE(*)" is an unknown verb.
- "-DISPLAY FATAFASE(*)" is an unknown primary keyword.
Field Name: Q9STEROR
- TOTAL
-
The total number of Db2 commands that were issued.
Field Name: SDSTTOTL