DB2 graphic QMF Version 8

Additional list filtering

When you enter L (for list) on the Object Manager panel and the Additional List Filtering? flag is set to Y, the List Filter Specification panel is displayed. This panel displays the set of filters that you can use to further qualify the object selection list. An object must pass all of the enabled filters to be included in the selection list.

Table 45. List Filter Specification
  DB2P / DB2PLOCATION -- List Filter Specification--------------- 8.1.0
  Command ===>
 
  Enable? Description
  ------- -----------------------------------------------------------
          Show only queries/procs that ran more than (CPU seconds)...
          Show only queries/procs run more than (number of times)....
          Show only queries/procs that have ever been canceled.
          Show only queries/procs run by user (TSO ID)...............
          Show only queries/procs run by user (SQLID)................
          Show only objects       that have not been used since......
          Show only objects       that have been used on or since....
          Show only queries/procs that have not been run since.......
          Show only queries/procs that have been run on or since.....
          Show only objects       that include the text listed below.
          (Warning: resource intensive filter).......................
 
          Carry filtering through to History panel? (Y/N)....... ===>
 

If you press Enter, all enabled filters will be processed. An object must pass all enabled filters to be included in the selection list. That is, if more than one filter is enabled, these conditions are combined with the 'AND' operator.

If you press PF3, all input fields will be ignored and you will return to the Object Manager panel.

The fields on the panel are:

Show only queries that ran more than * CPU seconds.
Enter Y in the Enable? column to enable this filter. A query must have run for more than the specified number of CPU seconds in order for it to be included in the selection list. This is useful for identifying resource intensive queries. Enter N in the Enable? column to disable this filter.
Show only queries/procs run more than * times.
Enter Y in the Enable? column to enable this filter. A query or proc must have been run more than the specified number of times in order for it to be included in the selection list. This is useful for identifying frequently used queries and procs. Enter N in the Enable? column to disable this filter.
Show only queries/procs that have ever been canceled.
Enter Y in the Enable? column to enable this filter. A query or proc must have been canceled at least once in order for it to be included in the selection list. This is useful for identifying frequently canceled queries and procs. Enter N in the Enable? column to disable this filter.
Show only queries/procs run by user (TSO ID) *.
Enter Y in the Enable? column to enable this filter. This is useful for identifying specific user's actions under QMF. Enter N in the Enable? column to disable this filter.
Show only queries/procs run by user (SQLID) *.
Enter Y in the Enable? column to enable this filter. This is useful for identifying specific user's actions under QMF. Enter N in the Enable? column to disable this filter.
Show only objects that have not been used since YYYY-MM-DD.
Enter Y in the Enable? column to enable this filter. An object must not have been used since the specified date in order for it to be included in the selection list. This is useful for identifying dormant objects. Enter N in the Enable? column to disable this filter.
Show only objects that have been used on or since YYYY-MM-DD.
Enter Y in the Enable? column to enable this filter. An object must have been used on or since the specified date in order for it to be included in the selection list. This is useful for identifying frequently used objects. Enter N in the Enable? column to disable this filter.
Show only queries/procs that have not been run since YYYY-MM-DD.
Enter Y in the Enable? column to enable this filter. A query or proc must not have been run since the specified date in order for it to be included in the selection list. This is useful for identifying dormant queries and procs. Enter N in the Enable? column to disable this filter.
Show only queries/procs that have been run on or since YYYY-MM-DD.
Enter Y in the Enable? column to enable this filter. A query or proc must have been used on or since the specified date in order for it to be included in the selection list. This is useful for identifying frequently used queries and procs. Enter N in the Enable? column to disable this filter.
Show only objects that include the text listed below.
Enter Y in the Enable? column to enable this filter. An object must contain the text that you specify for it to be included in the selection list. This is useful for locating queries that reference a specific table or column. Enter N in the Enable? column to disable this filter.
Note:
It is resource intensive to search queries, forms, and procs for specific text. When you enable this option, expect to wait longer for results to be displayed.
Carry filtering through to History panel?
Enter Y to carry the filter specifications through to the History panel. When you specify an H (history) from the object selection list, the filter specifications will be applied to the historical tracking data before it is displayed. For example, if a date filter is specified, then the tracking data will be compared against the date filter and only that data that passed the filter will be displayed. Enter N to disable this option. If you leave this field blank, Y is assumed.


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