Db2 Command Information attributes
Use these attributes to view Db2 command information.
Data Sharing Group The Data Sharing Group Name (Field name: GROUP).
Data Sharing Member The Data Sharing Group Member Name (Field name: MEMBER).
DB2 Subsystem The Db2 subsystem ID (Field name: DB2ID).
DB2 Version The DB2 Version (Field name: DB2VER).
Delta Value
The change since last sample (Field name: DELTA):
- N/A=-193
- N/C=-195
- N/P=-215
Field Name The Data Field Name (Field name: FIELDNAME).
Field Value
The Data Value (Field name: VALUE):
- N/A=-193
- N/C=-195
- N/P=-215
Interval Start The start time of this interval (Field name: TIMESTAMP).
Interval Time The collection interval time (Field name: INTRVAL).
MVS System ID The MVS identifier (Field name: MVSID).
Originating System ID The managed system name of the agent. Valid format is alphanumeric, with a maximum of 32 characters; example, DB91:SYS1:DB2. (Field name: ORIGINNODE).
Rate
The amount over last sampling interval (Field name: RATE):
- N/A=-193
- N/C=-195
- N/P=-215
Sequence Number The Data Field Description (Field name: SEQUENCE).
| Db2 command | Description |
|---|---|
| ACCESS DATABASE (Q9STCTAD) | The number of DB2 ACCESS DATABASE commands issued. This includes normal and abnormal completion of the command. |
| ACTIVATE FUNCTION LEVEL (Q9STCTEN) | The number of DB2 ACTIVATE FUNCTION LEVEL commands issued. This includes normal and abnormal completion of the command. This field is only shown for Db2 12 and above. |
| ALTER BUFFERPOOL (Q9STCTRN) | Alter Bufferpool commands executed to alter attributes for active or inactive buffer pools. |
| ALTER GROUPBUFFERPOOL (Q9STCTRS) | Alter Groupbufferpool commands executed to alter attributes for group buffer pools. |
| ALTER UTILITY (Q9STCTRY) | Alter Utility commands executed to change the values of certain parameters of an execution of the REORG utility that uses SHRLEVEL REFERENCE or CHANGE. |
| ARCHIVE LOG (Q9STCTRM) | Archive Log commands executed to initiate a DB2 active log switch. |
| CANCEL (DDF) THREAD (Q9STCTRK) | Cancel (DDF) Thread commands executed to cancel a thread. |
| DISPLAY GROUP (Q9STCTRX) | Display Group commands executed to display statistics about the data sharing group to which the Db2 subsystem belongs. |
| DISPLAY ACCEL (Q9STCTDA) | Display Accelerator commands executed to display details about Accelerators that are connected to current subsystem. |
| DISPLAY ARCHIVE (Q9STCTRQ) | Display Archive commands executed to display input archive log information. |
| DISPLAY BLOCKERS (Q9STCTBL) | NUMBER OF DISPLAY BLOCKERS COMMANDS. This field is only shown for Db2 12 and above. |
| DISPLAY BUFFERPOOL (Q9STCTRO) | Display Bufferpool commands executed to display statistics for active or inactive buffer pools. |
| DISPLAY DATABASE (Q9STCTR0) | Display Database commands executed to display status information about tablespaces and indexspaces within a database. |
| DISPLAY DDF (Q9STCTX5) | The number of DB2 DISPLAY DDF commands issued. This includes normal and abnormal completion of the command. |
| DISPLAY DYNQUERYCAPTURE (Q9STCTDQ) | The number of DB2 DISPLAY DYNQUERYCAPTURE commands issued. This includes normal and abnormal completion of the command. This field is only shown for Db2 12 and above. |
| DISPLAY FUNCTION (Q9STCTRZ) | Display Function Specific commands executed to display statistics about external user-defined functions accessed by Db2 applications. |
| DISPLAY GROUPBUFFERPOOL (Q9STCTRT) | Display Groupbufferpool commands executed to display attributes of group pools. |
| DISPLAY LOCATION (Q9STCTRL) | Display Location commands executed to display statistics of threads with distributed relationships. |
| DISPLAY LOG (Q9STCTX3) | Display Log commands executed to display log information and the status of the offload task. |
| DISPLAY ML (Q9STCTDM) | NUMBER OF DISPLAY ML COMMANDS ISSUED. This field is only shown for Db2 12 and above. |
| DISPLAY PROCEDURE (Q9STCTRU) | Display Procedure commands executed to display statistics about stored procedures. |
| DISPLAY PROFILE (Q9STCTSD) | The number of DB2 DISPLAY PROFILE commands issued. This includes normal and abnormal completion of the command. |
| DISPLAY RESTSVC (Q9STCTDR) | NUMBER OF DISPLAY RESTSVC COMMANDS. This field is only shown for Db2 12 and above. |
| DISPLAY RLIMIT (Q9STCTRG) | Display Rlimit commands executed to display the current status of the resource limit facility. |
| DISPLAY STATS (Q9STCTX7) | NUMBER OF DISPLAY STATS COMMANDS. This field is only shown for Db2 13 and above. |
| DISPLAY THREAD (Q9STCTR1) | Display Thread commands executed to display status information about Db2 threads. |
| DISPLAY TRACE (Q9STCTRC) | Display Trace commands executed to display a list of active traces. |
| DISPLAY UTILITY (Q9STCTR2) | Display Utility commands executed to display status information about Db2 utility jobs. |
| MODIFY DDF (Q9STCDMD) | The number of DB2 MODIFY DDF commands issued. This includes normal and abnormal completion of the command. |
| MODIFY TRACE (Q9STCTRH) | Modify Trace commands executed to change the IFCIDs being traced for an active trace. |
| RECOVER BSDS (Q9STCTR3) | Recover BSDS commands executed to recover a boot strap dataset that has been disabled by an error. |
| RECOVER INDOUBT (Q9STCTR4) | Recover Indoubt commands executed to recover threads left in the indoubt status. |
| RESET GENERICLU (Q9STCTRD) | Reset Genericlu commands executed to purge information stored by VTAM in the coupling facility for one or more partners of a particular Db2 subsystem. |
| RESET INDOUBT (Q9STCTRR) | Reset Indoubt commands executed to purge indoubt thread information. |
| RUN MLUTIL (Q9STCTX6) | NUMBER OF RUN MLUTIL COMMANDS. This field is only shown for Db2 13 and above. |
| SET ARCHIVE (Q9STCTRP) | Set Archive commands executed to change the maximum tape units and the de-allocation time parameters originally set in the installation parameters. |
| SET LOG (Q9STCTX2) | Set Log commands executed to modify the checkpoint frequency specified during installation. |
| SET SYSPARM (Q9STCTX4) | The number of DB2 SET SYSPARM commands issued. This includes normal and abnormal completion of the command. |
| START ACCEL (Q9STCTSA) | Start Accelerator commands executed to activate an Accelerator. |
| START CDDS (Q9STCTS1) | NUMBER OF START CDDS COMMANDS. This field is only shown for Db2 12 and above. |
| START DATABASE (Q9STCTR5) | Start Database commands executed to make stopped databases available for use. |
| START DB2 (Q9STCTR7) | Start Db2 commands executed. |
| START DDF (Q9STCTRI) | Start DDF commands executed to start the distributed data facility. |
| START DYNQUERYCAPTURE (Q9STCTSQ) | The number of DB2 START DYNQUERYCAPTURE commands issued. This includes normal and abnormal completion of the command. This field is only shown for Db2 12 and above. |
| START FUNCTION (Q9STCTX0) | Start Function Specific commands executed to activate an external function that is stopped. Built-in functions or user-defined functions that are sourced on another function cannot be started. |
| START ML (Q9STCTSM) | NUMBER OF START ML COMMANDS. This field is only shown for Db2 12 and above. |
| START PROCEDURE (Q9STCTRV) | Start Procedure commands executed to activate the definition of a stored procedure that is stopped, or refreshes one that is cached. |
| START PROFILE (Q9STCTSS) | The number of DB2 START PROFILE commands issued. This includes normal and abnormal completion of the command. |
| START RESTSVC (Q9STCTSR) | NUMBER OF START RESTSVC COMMANDS. This field is only shown for Db2 12 and above. |
| START RLIMIT (Q9STCTRE) | Start Rlimit commands executed to start the resource limit facility. |
| START TRACE (Q9STCTR6) | Start Trace commands executed to begin collection of Db2 trace records. |
| STOP ACCEL (Q9STCTXA) | Stop Accelerator commands executed to deactivate an Accelerator. |
| STOP CDDS (Q9STCTS2) | NUMBER OF STOP CDDS COMMANDS. This field is only shown for Db2 12 and above. |
| STOP DATABASE (Q9STCTR8) | Stop Database commands executed to make specified databases unavailable for use. |
| STOP DB2 (Q9STCTRA) | Stop Db2 commands executed. |
| STOP DDF (Q9STCTRJ) | Stop DDF commands executed to stop the distributed data facility. |
| STOP DYNQUERYCAPTURE (Q9STCTXQ) | The number of DB2 STOP DYNQUERYCAPTURE commands issued. This includes normal and abnormal completion of the command. This field is only shown for Db2 12 and above. |
| STOP FUNCTION (Q9STCTX1) | Stop Function Specific commands executed to prevent Db2 from accepting SQL statements with invocations of the specified functions. You cannot stop built-in functions or user-defined functions that are sourced to another function. |
| STOP ML (Q9STCTPM) | NUMBER OF STOP ML COMMANDS. This field is only shown for Db2 12 and above. |
| STOP PROCEDURE (Q9STCTRW) | Stop Procedure commands executed to prevent Db2 from accepting SQL CALL statements for one or more stored procedures. |
| STOP PROFILE (Q9STCTST) | The number of DB2 STOP PROFILE commands issued. This includes normal and abnormal completion of the command. |
| STOP RESTSVC (Q9STCTPR) | NUMBER OF STOP RESTSVC COMMANDS. This field is only shown for Db2 12 and above. |
| STOP RLIMIT (Q9STCTRF) | Stop Rlimit commands executed to stop the resource limit facility. |
| STOP TRACE (Q9STCTR9) | Stop Trace commands executed to stop collection of Db2 trace records. |
| TERM UTILITY (Q9STCTRB) | Term Utility commands to terminate execution of a utility job. |
| UNRECOGNIZED COMMANDS (Q9STEROR) | The number of unrecognized commands. |