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.
