Specifies the Db2 command. You can use the full command name or a Db2-supported synonym. For more information about the Db2 commands, see the IBM documentation.
| |
|---|
| Selects log records based on the ACCESS DATABASE command, which forces a physical open of or removes the group buffer pool (GBP) dependent status for a table space, index space, or partition. |
| Selects log records based on the ALTER BUFFERPOOL command, which changes attributes for an active or inactive buffer pool. |
| Selects log records based on the ALTER GROUPBUFFERPOOL command, which changes attributes of group buffer pools. |
| Selects log records based on the ALTER UTILITY command, which changes an execution of the REORG or REBUILD utilities. |
| Selects log records based on the ARCHIVE LOG command, which closes a current active log and opens the next available log data set. |
| Selects log records based on the CANCEL THREAD command, which cancels processing for specific local or distributed threads. |
| Selects log records based on the DISPLAY ARCHIVE command, which displays input archive log information. |
| Selects log records based on the DISPLAY BUFFERPOOL command, which displays the current status of active or inactive buffer pools. |
| Selects log records based on the DISPLAY DATABASE command, which displays status information about Db2 databases and database objects. |
| Selects log records based on the DISPLAY DDF command, which displays status and configuration information for the distributed data facility (DDF) and connections or threads controlled by DDF. |
DISPLAY FUNCTION SPECIFIC | Selects log records based on the DISPLAY FUNCTION SPECIFIC command, which displays statistics about external user-defined functions accessed by Db2 applications. |
| Selects log records based on the DISPLAY GROUP command, which displays information about the data sharing group to which a Db2 subsystem belongs. |
| Selects log records based on the DISPLAY GROUPBUFFERPOOL command, which displays status information about Db2 group buffer pools and related statistics. |
| Selects log records based on the DISPLAY LOCATION command, which displays dynamic status information about a specified remote location. |
| Selects log records based on the DISPLAY LOG command, which displays log information about the offload task and the status of the task. |
| Selects log records based on the DISPLAY PROCEDURE command, which displays statistics about stored procedures that Db2 applications access. |
| Selects log records based on the DISPLAY PROFILE command, which displays whether profiling is active or inactive. |
| Selects log records based on the DISPLAY RLIMIT command, which displays the current status of the resource limit facility. |
| Selects log records based on the DISPLAY THREAD command, which displays current status information about Db2 threads. |
| Selects log records based on the DISPLAY TRACE command, which displays a list of active traces. |
| Selects log records based on the DISPLAY UTILITY command, which displays the status of utility jobs, including jobs that are in a data sharing group. |
| Selects log records based on the MODIFY TRACE command, which changes the trace events (IFCID) associated with an active trace. |
| Selects log records based on the RECOVER BSDS command, which reestablishes dual bootstrap data sets (BSDS) after one BSDS has been disabled by a data set error. |
| Selects log records based on the RECOVER INDOUBT command, which recovers threads that are in an indoubt state because Db2 or a transaction manager could not automatically resolve the indoubt status with the commit coordinator. |
| Selects log records based on the RECOVER POSTPONED command, which completes back-out processing for units of recovery that are left incomplete during an earlier restart. |
| Selects log records based on the RESET GENERICLU command, which enables you to purge information VTAM stores in the coupling facility for partners of a Db2 subsystem. |
| Selects log records based on the RESET INDOUBT command, which purges the information that the indoubt thread report (generated by the DISPLAY THREAD command) displays. |
| Selects log records based on the SET ARCHIVE command, which sets the following maximums for the archive log: - Number of tape units
- Deallocation time of tape units
|
| Selects log records based on the SET LOG command, which modifies the checkpoint frequency that is specified during installation. |
| Selects log records based on the SET SYSPARM command, which enables you to change subsystem parameters while Db2 is up. |
| Selects log records based on the START DATABASE command, which makes a specified database available for processing. |
| Selects log records based on the START Db2 command, which initializes the Db2 subsystem and makes it available to TSO applications and to other subsystems. |
| Selects log records based on the START DDF command, which starts the distributed data facility (DDF). |
| Selects log records based on the START FUNCTION SPECIFIC command, which starts an eligible external function that is stopped. |
| Selects log records based on the START PROCEDURE command, which - Activates the definition of a stored procedure that is stopped
- Refreshes a stored procedure that is stored in the cache
|
| Selects log records based on the START PROFILE command, which loads or reloads the profile table into a data structure in memory. |
| Selects log records based on the START RLIMIT command, which starts the resource limit facility and specifies a resource limit specification table for the facility to use. |
| Selects log records based on the START TRACE command, which starts Db2 traces. |
| Selects log records based on the STOP DATABASE command, which makes specified objects unavailable for applications and closes their data sets. |
| Selects log records based on the STOP Db2 command, which stops the Db2 subsystem. |
| Selects log records based on the STOP DDF command, which stops the distributed data facility (DDF) if it has been started and terminates the DDF interface to VTAM or TCP/IP. |
| Selects log records based on the STOP FUNCTION SPECIFIC command, which prevents Db2 from accepting SQL statements with invocations of the specified functions. |
| Selects log records based on the STOP PROCEDURE command, which prevents Db2 from accepting SQL CALL statements for stored procedures. |
| Selects log records based on the STOP PROFILE command, which stops or disables the profile function. |
| Selects log records based on the STOP RLIMIT command, which - Stops the resource limit facility
- Resets all previously set limits to infinity
- Resets the accumulated time to zero
|
| Selects log records based on the STOP TRACE command, which stops tracing. |
| Selects log records based on the TERM UTILITY command, which terminates the execution of a Db2 utility job step and releases resources associated with that step. |
