View Query History panel
Query history is displayed on this panel.
Table 53. Query History
DB2P / DB2PLOCATION -- Query QMFUSER.QUERY1 ------------------- 8.1.0
Command ===> Scroll ===> PAGE
Valid Actions Are...
B Browse SQL Text
Total number of times run............:
Rows: Minimum : Average : Maximum :
CPU : Minimum : Average : Maximum :
M
A E O C S
C Start Elapsed N D A Q
T Date Time Time TSOID SQLID Rows CPU V E N L
----- ----- ----- ----- ----- ---- --- - - - -
****************************BOTTOM OF DATA****************************
|
If you press Enter, all rows that are selected
with an action code of B (to browse query text) will be processed.
If there is no query text to browse for the selected row, the row
will be bypassed. After all selected rows are processed, the panel will
be redisplayed.
If you press PF3, all input fields will
be ignored and you will return to the previous panel.
If you press PF8 or PF7,
the panel will scroll forward or backward after all selected rows
have been processed.
The fields on the panel are:
- Total number of times run
- This field indicates the number of times this query has been
run. If additional list filtering has been carried forward, the
number of detail records displayed on this panel may be less than
this value. If additional list filtering has been carried forward,
an information message will be displayed on the panel's
message line.
- ACT
- (Action): Set this field to B to browse SQL text.
- ENV
- (Environment): This column indicates the environment under
which the object was run. T indicates TSO, C indicates CICS, and O or H indicates the action was performed in HPO Object Manager.
- MODE
- This column indicates the mode under which the object was
run. O indicates online and B indicates batch.
- CAN
- (Cancel code): This column indicates whether or not the query
was canceled. If it was not canceled, a zero will be displayed.
If it was canceled, a one character code will be displayed. See
"HPO/Governor module cancel codes" for a discussion of the values
that can appear in this column.
- SQL
- (SQL text indicator): This column indicates whether or not
there is any SQL text available for browsing. If SQL text is available,
this flag is set to Y. If no text is available, this flag is set to N. SQL text is only available for queries in which CPU consumption
exceeds an installation-defined threshold. For more information
about this threshold and SQL text tracking, see "Step 12f. Set HPO/Governor
module configuration parameters."
