Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

DB2 command definition

This topic describes the DB2 command definition syntax used in the WHERE clause of the LOGSCAN statement.

Use this syntax to select log records based on the DB2 command they reflect.

The DB2 command definition is not valid if your log scan specifies any other type of output. By defining a filter that includes DB2 commands and generating a Commands report, you can select information about changes resulting from DB2 commands.

DB2 Command definition syntax diagram

OptionDescription
DB2Command

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.

Following is a brief description of the available commands:

CommandDescription
ACCESS DATABASE

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.

ALTER BUFFERPOOL

Selects log records based on the ALTER BUFFERPOOL command, which changes attributes for an active or inactive buffer pool.

ALTER GROUPBUFFERPOOL

Selects log records based on the ALTER GROUPBUFFERPOOL command, which changes attributes of group buffer pools.

ALTER UTILITY

Selects log records based on the ALTER UTILITY command, which changes an execution of the REORG or REBUILD utilities.

ARCHIVE LOG

Selects log records based on the ARCHIVE LOG command, which closes a current active log and opens the next available log data set.

CANCEL THREAD

Selects log records based on the CANCEL THREAD command, which cancels processing for specific local or distributed threads.

DISPLAY ARCHIVE

Selects log records based on the DISPLAY ARCHIVE command, which displays input archive log information.

DISPLAY BUFFERPOOL

Selects log records based on the DISPLAY BUFFERPOOL command, which displays the current status of active or inactive buffer pools.

DISPLAY DATABASE

Selects log records based on the DISPLAY DATABASE command, which displays status information about DB2 databases and database objects.

DISPLAY DDF

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.

DISPLAY GROUP

Selects log records based on the DISPLAY GROUP command, which displays information about the data sharing group to which a DB2 subsystem belongs.

DISPLAY GROUPBUFFERPOOL

Selects log records based on the DISPLAY GROUPBUFFERPOOL command, which displays status information about DB2 group buffer pools and related statistics.

DISPLAY LOCATION

Selects log records based on the DISPLAY LOCATION command, which displays dynamic status information about a specified remote location.

DISPLAY LOG

Selects log records based on the DISPLAY LOG command, which displays log information about the offload task and the status of the task.

DISPLAY PROCEDURE

Selects log records based on the DISPLAY PROCEDURE command, which displays statistics about stored procedures that DB2 applications access.

DISPLAY PROFILE

Selects log records based on the DISPLAY PROFILE command, which displays whether profiling is active or inactive.

DISPLAY RLIMIT

Selects log records based on the DISPLAY RLIMIT command, which displays the current status of the resource limit facility.

DISPLAY THREAD

Selects log records based on the DISPLAY THREAD command, which displays current status information about DB2 threads.

DISPLAY TRACE

Selects log records based on the DISPLAY TRACE command, which displays a list of active traces.

DISPLAY UTILITY

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.

MODIFY TRACE

Selects log records based on the MODIFY TRACE command, which changes the trace events (IFCID) associated with an active trace.

RECOVER BSDS

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.

RECOVER INDOUBT

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.

RECOVER POSTPONED

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.

RESET GENERICLU

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.

RESET INDOUBT

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.

SET ARCHIVE

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

SET LOG

Selects log records based on the SET LOG command, which modifies the checkpoint frequency that is specified during installation.

SET SYSPARM

Selects log records based on the SET SYSPARM command, which enables you to change subsystem parameters while DB2 is up.

START DATABASE

Selects log records based on the START DATABASE command, which makes a specified database available for processing.

START DB2

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.

START DDF

Selects log records based on the START DDF command, which starts the distributed data facility (DDF).

START FUNCTION SPECIFIC

Selects log records based on the START FUNCTION SPECIFIC command, which starts an eligible external function that is stopped.

START PROCEDURE

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

START PROFILE

Selects log records based on the START PROFILE command, which loads or reloads the profile table into a data structure in memory.

START RLIMIT

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.

START TRACE

Selects log records based on the START TRACE command, which starts DB2 traces.

STOP DATABASE

Selects log records based on the STOP DATABASE command, which makes specified objects unavailable for applications and closes their data sets.

STOP DB2

Selects log records based on the STOP DB2 command, which stops the DB2 subsystem.

STOP DDF

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.

STOP FUNCTION SPECIFIC

Selects log records based on the STOP FUNCTION SPECIFIC command, which prevents DB2 from accepting SQL statements with invocations of the specified functions.

STOP PROCEDURE

Selects log records based on the STOP PROCEDURE command, which prevents DB2 from accepting SQL CALL statements for stored procedures.

STOP PROFILE

Selects log records based on the STOP PROFILE command, which stops or disables the profile function.

STOP RLIMIT

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

STOP TRACE

Selects log records based on the STOP TRACE command, which stops tracing.

TERM UTILITY

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.

IN (DB2Command)

Log Master can select log records based on whether they resulted from a single DB2 command or a set of commands. The IN keyword indicates a set of multiple DB2 commands. Enclose the set of commands within parentheses and separate multiple commands with commas.

Example

IN (STOP DB2, START DB2)
NOT

Specifies that log records are selected when the DB2 command reflected in them does not match any member of a set of multiple DB2 commands.

Example

NOT IN (STOP DATABASE, START DATABASE)


Was this page helpful? Yes No Submitting... Thank you

Comments