Default language.

DB2 commands (BSTATDR)


This topic describes the DB2 commands section of the DB2 statistics detail report (BSTATDR).

DB2 COMMANDS                QUANTITY  /MINUTE
--------------------------  --------  -------
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

 

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