-STOP DYNQUERYCAPTURE command (Db2)

The Db2 command STOP DYNQUERYCAPTURE stops the capture of dynamic SQL statements by the specified monitors.

Abbreviation: -STO DYNQUERY

Authorization

To execute this command, you must use a privilege set of the process that includes one of the following authorities:

SQLADM authority
System DBADM authority
SYSOPR authority
SYSCTRL authority
SYSADM authority

Environment

This command can be issued from the z/OS® console, through a batch job, or the instrumentation facility interface (IFI).

Data sharing scope: Member

Syntax

Option descriptions

CNO(integer)

Stop a particular capture number, a list of capture numbers, or display all capture numbers.

*: Stop all active capture monitors.
integer: Stop the specified active capture monitors.

SCOPE

Specifies the scope of the command.

LOCAL: Stops the capture on the local Db2 system only.
GROUP: Stops the capture on all members of the data sharing group.

Output

Message DSNX224I is issued at successful completion of the STOP DYNQUERYCAPTURE command processing. For example, assume that you issue the following command:

-DB2ASTOP DYNQUERY CNO(1)

The following message is issued:

DSNX224I -DB2A DSNXESPC STOP DYNAMIC QUERY CAPTURE FOR COMMAND 
NUMBER (1) COMPLETED SUCCESSFULLY, WITH 1 QUERY CAPTURES STOPPED.

Similarly, assume that you issue the following command:

-DB2ASTOP DYNQUERY CNO(1)

The following message might be issued:

DSNX224I -DB2A DSNXESPC STOP DYNAMIC QUERY CAPTURE FOR COMMAND
NUMBER (*) COMPLETED SUCCESSFULLY, WITH 2 QUERY CAPTURES STOPPED.

Message DSNX225I is issued if an active monitor process with specified command-number is not found. For example, assume that you issue the following command:

-DB2ASTOP DYNQUERY CNO(43)

If no matching active monitor process is found, the following message is issued:

DSNX225I -DB2A DSNXESPC STOP DYNAMIC QUERY CAPTURE FOR COMMAND
NUMBER (43) FAILED. QUERY CAPTURE NUMBER (43) COULD NOT BE FOUND.