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.