IFCID 001 - Db2 Command Data
This topic shows detailed information about Record Trace - IFCID 001 - Db2 Command
Data
.
Record Trace - IFCID 001 - Db2 Command Data
The field labels shown in the following sample layout of Record Trace - IFCID 001 - Db2
Command Data
are described in the following section.
DB2 COMMAND DATA
DISPLAY DB 0 DISPLAY THRD 2 DISP UTIL 0 DISP TRACE 15 DISPL RLIMIT 0
START DB 10 START TRACE 33 START DB2 1 START RLIM 0 STOP DB 0
STOP TRACE 7 STOP DB2 0 STOP RLIM 0 RECOV BSDS 0 RECOV INDOUBT 0
MODIFY TRACE 0 TERM UTILITY 2 START DDF 0 STOP DDF 0 CANCEL THREAD 0
DISPL LOCATN 0 UNREC CMDS 5 ARCH LOG 0 SET ARCH 0 DISPL ARCH 0
RESET INDOUBT 0 ALTER BUFFER 0 DISP BUF 2 DISP GROUP 2 DISP PROCEDURE 0
RESET GENERIC 0 ALTER GBPOOL 0 DISP GBPOOL 0 START PROC 0 STOP PROCEDURE 0
DISPLAY GROUP 2 ALTER UTILITY 0 DISP FUNC 0 START FUNC 0 STOP FUNCTION 0
SET LOG 0 DISPLAY LOG 0 SET SYSPARM 0 DISPLAY DDF 2 ACCESS DB 0
START PROFILE 0 STOP PROFILE 0 DISP PROFILE 0 DISP ACCEL 0 START ACCEL 0
STOP ACCEL 0 MODIFY DDF 0 START DYNQRY 0 STOP DYNQRY 0 DISP DYNQRY 3
ACTV FUNC LEV 0 DISPLAY ML 0 START ML 4 STOP ML 0 DISP SERVICE 0
START SERVICE 0 STOP SERVICE 0 START CDDS 0 STOP CDDS 0 DISP BLOCKERS 0
RUN MLUTIL 2 DISPLAY STATS 6
- DISPLAY DB
-
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 THRD
-
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
- DISP UTIL
-
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
- DISP 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
- DISPL 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
- START DB
-
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 RLIM
-
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
- STOP DB
-
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 STOP DB2 commands. This includes both normal and abnormal completions.
Field Name: Q9STSCRA
- STOP RLIM
-
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
- RECOV 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
- RECOV 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
- 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
- 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
- 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
- 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
- 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
- DISPL LOCATN
-
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
- UNREC CMDS
-
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
- ARCH LOG
-
The number of Db2 ARCHIVE LOG commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRM
- SET ARCH
-
The number of Db2 SET ARCHIVE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRP
- DISPL ARCH
-
The number of Db2 DISPLAY ARCHIVE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRQ
- RESET INDOUBT
-
The number of Db2 RESET INDOUBT commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRR
- ALTER BUFFER
-
The number of Db2 ALTER BUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRN
- DISP BUF
-
The number of Db2 DISPLAY BUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRO
- DISP GROUP
-
The number of Db2 DISPLAY GROUP commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRX
- DISP PROCEDURE
-
The number of Db2 DISPLAY PROCEDURE commands executed. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRU
- RESET GENERIC
-
The number of Db2 RESET GENERICLU commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRD
- ALTER GBPOOL
-
The number of Db2 ALTER GROUPBUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRS
- DISP GBPOOL
-
The number of Db2 DISPLAY GROUPBUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRT
- START PROC
-
The number of Db2 START PROCEDURE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRV
- STOP PROCEDURE
-
The number of Db2 STOP PROCEDURE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRW
- DISPLAY GROUP
-
The number of Db2 DISPLAY GROUP commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRX
- ALTER UTILITY
-
The number of Db2 ALTER UTILITY commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRY
- DISP FUNC
-
The number of Db2 DISPLAY FUNCTION commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTRZ
- START FUNC
-
The number of Db2 START FUNCTION commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX0
- STOP FUNCTION
-
The number of Db2 STOP FUNCTION commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX1
- SET LOG
-
The number of Db2 SET LOG commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX2
- DISPLAY LOG
-
The number of Db2 DISPLAY LOG commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX3
- SET SYSPARM
-
The number of Db2 SET SYSPARM commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX4
- DISPLAY DDF
-
The number of Db2 DISPLAY DDF commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTX5
- ACCESS DB
-
The number of Db2 ACCESS DATABASE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTAD
- START PROFILE
-
The number of Db2 START PROFILE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTSS
- STOP PROFILE
-
The number of Db2 STOP PROFILE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTST
- DISPLAY PROF
-
The number of Db2 DISPLAY PROFILE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTSD
- DISP PROFILE
-
The number of Db2 DISPLAY PROFILE commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTSD
- DISP ACCEL
-
The number of Db2 DISPLAY ACCEL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTDA
- START ACCEL
-
The number of Db2 START ACCEL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTSA
- STOP ACCEL
-
The number of Db2 STOP ACCEL commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTXA
- MODIFY DDF
-
The number of Db2 MODIFY DDF commands issued. This includes normal and abnormal completion of the command.
Field Name: Q9STCTMD
- START DYNQRY
-
The number of Db2 "-START DYNQUERYCAPTURE" commands.
Field Name: Q9STCTSQ
- STOP DYNQRY
-
The number of STOP DYNQUERYCAPTURE Db2 commands.
Field Name: Q9STCTXQ
- DISP DYNQRY
-
The number of Db2 "-DISPLAY DYNQUERYCAPTURE" commands.
Field Name: Q9STCTDQ
- ACTV FUNC LEV
-
The number of Db2 "-ACTIVATE FUNCTION LEVEL" commands.
Field Name: Q9STCTEN
- DISPLAY ML
-
The number of Db2 "-DISPLAY ML" commands.
Field Name: Q9STCTDM
- START ML
-
The number of Db2 "-START ML" commands.
Field Name: Q9STCTSM
- STOP ML
-
The number of Db2 "-STOP ML" commands
Field Name: Q9STCTPM
- DISP SERVICE
-
The number of Db2 "-DISPLAY RESTSVC" commands.
Field Name: Q9STCTDR
- START SERVICE
-
The number of Db2 "-START RESTSVC" commands.
Field Name: Q9STCTSR
- STOP SERVICE
-
The number of Db2 "-STOP RESTSVC" commands.
Field Name: Q9STCTPR
- START CDDS
-
The number of Db2 "-START CDDS" commands.
Field Name: Q9STCTS1
- STOP CDDS
-
The number of Db2 "-STOP CDDS" commands
Field Name: Q9STCTS2
- DISP BLOCKERS
-
The number of Db2 "-DISPLAY BLOCKERS" commands.
Field Name: Q9STCTBL
- RUN MLUTIL
-
The number of Db2 "-RUN MLUTIL" commands.
Field Name: Q9STCTX6
- DISPLAY STATS
-
The number of Db2 "-DISPLAY STATS" commands.
Field Name: Q9STCTX7