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