-DISPLAY DYNQUERYCAPTURE command (Db2)
The -DISPLAY DYNQUERYCAPTURE command displays all currently active dynamic query capture monitors.
Environment for -DISPLAY DYNQUERYCAPTURE
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 for -DISPLAY DYNQUERYCAPTURE
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 for -DISPLAY DYNQUERYCAPTURE
Option descriptions for -DISPLAY DYNQUERYCAPTURE
- 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.
Output for -DISPLAY DYNQUERYCAPTURE
The DSNX250I message displays output from the DISPLAY DYNQUERYCAPTURE command.
- csect-name
- The name of the control section that issued the message.
The output from the command consists of one or more of the following sections, in the indicated order:
- Output heading
- The name of the control section is followed by heading information for the output:
*** BEGIN DISPLAY DYNAMIC QUERY CAPTURE CNO(num) ====================================================================- CNO(num)
- The number of CNO specified for the DISPLAY command.
- Dynamic query capture information
- The output heading is followed by a section that contains information about the capture of dynamic queries.
CNO : num STBLGRP : text SQLID : text THRESHOLD : num STABILIZED : num --------------------------------------------------------------------- CNO : num
- The command number.
- STBLGRP : text
- The stabilization group name.
- SQLID : text
- The SQLID value.
- THRESHOLD : num
- The threshold value
- STABILIZED : num
- The number of statements stabilized by this START DYNAMICQUERYCAPTURE command. This value does not decrease when statements are freed using FREE STABILIZED DYNAMIC QUERY commands.
- End of output
- The output ends with the following message:
==================================================================== *** END DISPLAY DYNAMIC QUERY CAPTURE
Message DSNX260I indicates that a long display output continues from the previous output.
DISPLAY DYNAMIC QUERY CAPTURE CONTINUES ...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.
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