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
- 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 START DYNQUERYCAPTURE DB2 commands.
Field Name: Q9STCTSQ
- STOP DYNQRY
The number of STOP DYNQUERYCAPTURE DB2 commands.
Field Name: Q9STCTXQ
- DISP DYNQRY
The number of DISPLAY DYNQUERYCAPTURE DB2 commands.
Field Name: Q9STCTDQ