-DISPLAY DYNQUERYCAPTURE command (Db2)

The Db2 command DISPLAY DYNQUERYCAPTURE displays all currently active dynamic query capture monitors.

Abbreviation: -DIS DYNQUERY

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

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

Syntax

Option descriptions

CNO(integer)

Limit display to a particular capture monitor, a list of capture monitors, or display all capture monitors.

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

Example: displaying all active capture monitors for dynamic queries

Suppose that you issue the following command:

-DISPLAY DYNQUERYCAPTURE CNO (*)

The output is similar to the following output:


DSNX250I -DB2A DSNXEDQC 215
*** BEGIN DISPLAY DYNAMIC QUERY CAPTURE CNO(*)
====================================================================
CNO : 1
STBLGRP : GRP1
SQLID : APPL01
THRESHOLD : 10
STABILIZED : 156
--------------------------------------------------------------------
CNO : 5
STBLGRP : GRP2
SQLID : APPL02
THRESHOLD : 30
STABILIZED : 47
--------------------------------------------------------------------
...
CNO : 51
STBLGRP : GRP126
SQLID : APPL126
THRESHOLD : 9
>>> MORE TO DISPLAY ...
DSNX260I -DB2A DISPLAY DYNAMIC QUERY CAPTURE CONTINUES
STABILIZED : 13
--------------------------------------------------------------------
CNO : 52
STBLGRP : GRP127
SQLID : APPL127
THRESHOLD : 50
STABILIZED : 2
====================================================================
*** END DISPLAY DYNAMIC QUERY CAPTURE
DSN9022I -DB2A DSNXEDQC 'DISPLAY DYNQUERYCAPTURE' NORMAL COMPLETION

Output

Message DSNX250I indicates the beginning of the output of the command.

Message DSNX260I indicates that a long display output continues from the previous output.

Message DSN9022I indicates successful completion of processing for the DISPLAY DYNQUERYRCAPTURE command.

Message DSN9023I indicates that processing for the DISPLAY DYNQUERYCAPTURE did not complete successfully.