DB2 graphic QMF Version 8

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."


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004