.
DB2 commands (BSTATDR)
This topic describes the DB2 commands section of the DB2 statistics detail report (BSTATDR).
-------------------------- -------- -------
DISPLAY DATABASE 0 0.00
DISPLAY THREAD 0 0.00
DISPLAY UTILITY 0 0.00
DISPLAY TRACE 0 0.00
DISPLAY RLIMIT 0 0.00
DISPLAY LOCATION 0 0.00
DISPLAY ARCHIVE 0 0.00
DISPLAY BUFFERPOOL 0 0.00
DISPLAY GROUPBUFFERPOOL 0 0.00
DISPLAY GROUP 0 0.00
DISPLAY PROCEDURE 0 0.00
DISPLAY DDF 0 0.00
ALTER BUFFERPOOL 0 0.00
ALTER GROUPBUFFERPOOL 0 0.00
START DATABASE 0 0.00
START TRACE 2 0.07
START DB2 0 0.00
START RLIMIT 0 0.00
START DDF 0 0.00
START PROCEDURE 0 0.00
STOP DATABASE 0 0.00
STOP TRACE 2 0.07
STOP DB2 0 0.00
MODIFY TRACE 4 0.13
CANCEL DDF THREAD 0 0.00
TERM UTILITY 0 0.00
RECOVER BSDS 0 0.00
RECOVER INDOUBT 0 0.00
RESET INDOUBT 0 0.00
RESET GENERICLU 0 0.00
ARCHIVE LOG 0 0.00
SET ARCHIVE 0 0.00
UNRECOGNIZED CMDS 0 0.00
NUMBER START PROFILE CMDS 0 0.00
NUMBER STOP PROFILE CMDS 0 0.00
NUMBER ACCESS DB CMDS 0 0.00
TOTAL 8 0.27
The following table describes the fields in the DB2 commands section.
Field | Description |
|---|---|
DISPLAY DATABASE | Number of -DISPLAY DATABASE commands issued (Q9STCTR0) |
DISPLAY THREAD | Number of -DISPLAY THREAD commands issued (Q9STCTR1) |
DISPLAY UTILITY | Number of -DISPLAY UTILITY commands issued (Q9STCTR2) |
DISPLAY TRACE | Number of -DISPLAY TRACE commands issued (Q9STCTRC) |
DISPLAY RLIMIT | Number of -DISPLAY RLIMIT commands issued (Q9STCTRG) |
DISPLAY LOCATION | Number of -DISPLAY LOCATION commands issued (Q9STCTRL) |
DISPLAY ARCHIVE | Number of -DISPLAY ARCHIVE commands issued (Q9STCTRQ) |
DISPLAY BUFFERPOOL | Number of -DISPLAY BUFFERPOOL commands issued (Q9STCTRO) |
DISPLAY GROUPBUFFERPOOL | Number of -DISPLAY GROUPBUFFERPOOL commands issued (Q9STCTRT) |
DISPLAY GROUP | Number of -DISPLAY GROUP commands issued (Q9STCTRX) |
DISPLAY PROCEDURE | Number of -DISPLAY PROCEDURE commands issued (Q9STCTRU) |
DISPLAY DDF | Number of -DISPLAY DDF commands issued (Q9STCTX5) |
DISPLAY FUNCTION | Number of -DISPLAY FUNCTION commands issued (Q9STCTRZ) |
DISPLAY LOG | Number of -DISPLAY LOG commands issued (Q9STCTX3) |
ALTER BUFFERPOOL | Number of -ALTER BUFFERPOOL commands issued (Q9STCTRN) |
ALTER GROUPBUFFERPOOL | Number of -ALTER GROUPBUFFERPOOL commands issued (Q9STCTRS) |
START DATABASE | Number of -START DATABASE commands issued (Q9STCTR5) |
START TRACE | Number of -START TRACE commands issued (Q9STCTR6) |
START DB2 | Number of -START DB2 commands issued (Q9STCTR7) |
START RLIMIT | Number of -START RLIMIT commands issued (Q9STCTRE) |
START DDF | Number of -START DDF commands issued (Q9STCTRI) |
START PROCEDURE | Number of -START PROCEDURE commands issued (Q9STCTRV) |
START FUNCTION | Number of -START FUNCTION commands issued (Q9STCTX0) |
STOP DATABASE | Number of -STOP DATABASE commands issued (Q9STCTR8) |
STOP TRACE | Number of -STOP TRACE commands issued (Q9STCTR9) |
STOP DB2 | Number of -STOP DB2 commands issued (Q9STCTRA) |
STOP FUNCTION | Number of -STOP FUNCTION commands issued (Q9STCTX1) |
STOP PROCEDURE | Number of -STOP PROCEDURE commands issued (Q9STCTRW) |
STOP RLIMIT | Number of -STOP RLIMIT commands issued (Q9STCTRF) |
STOP DDF | Number of -STOP DDF commands issued (Q9STCTRJ) |
MODIFY TRACE | Number of -MODIFY TRACE commands issued (Q9STCTRH) |
CANCEL DDF THREAD | Number of -CANCEL THREAD commands issued (Q9STCTRK) |
TERM UTILITY | Number of -TERM UTILITY commands issued (Q9STCTRB) |
RECOVER BSDS | Number of -RECOVER BSDS commands issued (Q9STCTR3) |
RECOVER INDOUBT | Number of -RECOVER INDOUBT commands issued (Q9STCTR4) |
RESET INDOUBT | Number of -RESET INDOUBT commands issued (Q9STCTRR) |
RESET GENERICLU | Number of -RESET GENERICLU commands issued (Q9STCTRD) |
ARCHIVE LOG | Number of -ARCHIVE LOG commands issued (Q9STCTRM) |
SET ARCHIVE | Number of -SET ARCHIVE commands issued (Q9STCTRP) |
SET LOG | Number of -SET LOG commands issued (Q9STCTX2) |
UNRECOGNIZED CMDS | Number of unrecognized Db2 commands issued (Q9STEROR) |
NUMBER START PROFILE CMDS | Number of -START PROFILE commands issued (Q9STCTSS) |
NUMBER STOP PROFILE CMDS | Number of -STOP PROFILE commands issued (Q9STCTST) |
NUMBER ACCESS DB CMDS | Number of -ACCESS DATABASE commands issued (Q9STCTAD) |
TOTAL | Total number of Db2 commands issued |
Related topic