IFCID 001 - Db2 Command Data
The IFCID 001 record block provides detailed information about the Db2 command data.
Record trace - IFCID 001 - DB2 Command Data
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
The fields shown in this record block are described below. Db2 field names are shown in brackets next to each report field.
- DISPLAY DB [Q9STCTR0]
-
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.
- DISPLAY THRD [Q9STCTR1]
-
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.
- DISP UTIL [Q9STCTR2]
-
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.
- DISP TRACE [Q9STCTRC]
-
The number of DB2 DISPLAY TRACE commands issued to determine the currently active Db2 traces. This includes normal and abnormal completion of the command.
- DISPL RLIMIT [Q9STCTRG]
-
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.
- START DB [Q9STCTR5]
-
The number of DB2 START DATABASE commands issued to make a database available for use. This includes normal and abnormal completion of the command.
- START TRACE [Q9STCTR6]
-
The number of DB2 START TRACE commands issued to initiate a Db2 trace. This includes normal and abnormal completion of the command.
- START DB2 [Q9STCTR7]
-
The number of DB2 START DB2 commands issued to bring up a Db2 subsystem. This includes normal and abnormal completion of the command.
- START RLIM [Q9STCTRE]
-
The number of DB2 START RLIMIT commands issued to enable the Db2 resource limit facility. This includes normal and abnormal completion of the command.
- STOP DB [Q9STCTR8]
-
The number of DB2 STOP DATABASE commands issued to prevent access to a Db2 database. This includes normal and abnormal completion of the command.
- STOP TRACE [Q9STCTR9]
-
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.
- STOP DB2 [Q9STSCRA]
-
The number of STOP DB2 commands. This includes both normal and abnormal completions.
- STOP RLIM [Q9STCTRF]
-
The number of DB2 STOP RLIMIT commands issued to disable the Db2 resource limit facility. This includes normal and abnormal completion of the command.
- RECOV BSDS [Q9STCTR3]
-
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.
- RECOV INDOUBT [Q9STCTR4]
-
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.
- MODIFY TRACE [Q9STCTRH]
-
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.
- TERM UTILITY [Q9STCTRB]
-
The number of DB2 TERM UTILITY commands issued to stop execution of a Db2 utility. This includes normal and abnormal completion of the command.
- START DDF [Q9STCTRI]
-
The number of DB2 START DDF commands issued to enable the Db2 distributed data facility. This includes normal and abnormal completion of the command.
- STOP DDF [Q9STCTRJ]
-
The number of DB2 STOP DDF commands issued to disable the Db2 distributed data facility. This includes normal and abnormal completion of the command.
- CANCEL THREAD [Q9STCTRK]
-
The number of DB2 CANCEL THREAD commands issued to cancel a thread. This includes normal and abnormal completion of the command.
- DISPL LOCATN [Q9STCTRL]
-
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.
- UNREC CMDS [Q9STEROR]
-
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.
- ARCH LOG [Q9STCTRM]
-
The number of DB2 ARCHIVE LOG commands issued. This includes normal and abnormal completion of the command.
- SET ARCH [Q9STCTRP]
-
The number of DB2 SET ARCHIVE commands issued. This includes normal and abnormal completion of the command.
- DISPL ARCH [Q9STCTRQ]
-
The number of DB2 DISPLAY ARCHIVE commands issued. This includes normal and abnormal completion of the command.
- RESET INDOUBT [Q9STCTRR]
-
The number of DB2 RESET INDOUBT commands issued. This includes normal and abnormal completion of the command.
- ALTER BUFFER [Q9STCTRN]
-
The number of DB2 ALTER BUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
- DISP BUF [Q9STCTRO]
-
The number of DB2 DISPLAY BUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
- DISP GROUP [Q9STCTRX]
-
The number of DB2 DISPLAY GROUP commands issued. This includes normal and abnormal completion of the command.
- DISP PROCEDURE [Q9STCTRU]
-
The number of DB2 DISPLAY PROCEDURE commands executed. This includes normal and abnormal completion of the command.
- RESET GENERIC [Q9STCTRD]
-
The number of DB2 RESET GENERICLU commands issued. This includes normal and abnormal completion of the command.
- ALTER GBPOOL [Q9STCTRS]
-
The number of DB2 ALTER GROUPBUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
- DISP GBPOOL [Q9STCTRT]
-
The number of DB2 DISPLAY GROUPBUFFERPOOL commands issued. This includes normal and abnormal completion of the command.
- START PROC [Q9STCTRV]
-
The number of DB2 START PROCEDURE commands issued. This includes normal and abnormal completion of the command.
- STOP PROCEDURE [Q9STCTRW]
-
The number of DB2 STOP PROCEDURE commands issued. This includes normal and abnormal completion of the command.
- DISPLAY GROUP [Q9STCTRX]
-
The number of DB2 DISPLAY GROUP commands issued. This includes normal and abnormal completion of the command.
- ALTER UTILITY [Q9STCTRY]
-
The number of DB2 ALTER UTILITY commands issued. This includes normal and abnormal completion of the command.
- DISP FUNC [Q9STCTRZ]
-
The number of DB2 DISPLAY FUNCTION commands issued. This includes normal and abnormal completion of the command.
- START FUNC [Q9STCTX0]
-
The number of DB2 START FUNCTION commands issued. This includes normal and abnormal completion of the command.
- STOP FUNCTION [Q9STCTX1]
-
The number of DB2 STOP FUNCTION commands issued. This includes normal and abnormal completion of the command.
- SET LOG [Q9STCTX2]
-
The number of DB2 SET LOG commands issued. This includes normal and abnormal completion of the command.
- DISPLAY LOG [Q9STCTX3]
-
The number of DB2 DISPLAY LOG commands issued. This includes normal and abnormal completion of the command.
- SET SYSPARM [Q9STCTX4]
-
The number of DB2 SET SYSPARM commands issued. This includes normal and abnormal completion of the command.
- DISPLAY DDF [Q9STCTX5]
-
The number of DB2 DISPLAY DDF commands issued. This includes normal and abnormal completion of the command.
- ACCESS DB [Q9STCTAD]
-
The number of DB2 ACCESS DATABASE commands issued. This includes normal and abnormal completion of the command.
- START PROFILE [Q9STCTSS]
-
The number of DB2 START PROFILE commands issued. This includes normal and abnormal completion of the command.
- STOP PROFILE [Q9STCTST]
-
The number of DB2 STOP PROFILE commands issued. This includes normal and abnormal completion of the command.
- DISPLAY PROF [Q9STCTSD]
-
The number of DB2 DISPLAY PROFILE commands issued. This includes normal and abnormal completion of the command.
- DISP PROFILE [Q9STCTSD]
-
The number of DB2 DISPLAY PROFILE commands issued. This includes normal and abnormal completion of the command.
- DISP ACCEL [Q9STCTDA]
-
The number of DB2 DISPLAY ACCEL commands issued. This includes normal and abnormal completion of the command.
- START ACCEL [Q9STCTSA]
-
The number of DB2 START ACCEL commands issued. This includes normal and abnormal completion of the command.
- STOP ACCEL [Q9STCTXA]
-
The number of DB2 STOP ACCEL commands issued. This includes normal and abnormal completion of the command.
- MODIFY DDF [Q9STCTMD]
-
The number of DB2 MODIFY DDF commands issued. This includes normal and abnormal completion of the command.
- START DYNQRY [Q9STCTSQ]
-
The number of START DYNQUERYCAPTURE Db2 commands.
- STOP DYNQRY [Q9STCTXQ]
-
The number of STOP DYNQUERYCAPTURE Db2 commands.
- DISP DYNQRY [Q9STCTDQ]
-
The number of DISPLAY DYNQUERYCAPTURE Db2 commands.