Spotlight on SAP ASE 2.12 - Getting Started Guide

Criteria Tab for Drilldowns

As you view drilldowns, you can filter them based on criteria specified in the Criteria tab. This is available for the following drilldowns: Database Analysis, Tablespace Analysis, Buffer Pool Analysis, Client Application Analysis, and Diagnostic Log.

Filtering lets you narrow the scope of the list shown in a drilldown. You can use it to focus on objects with a certain level of activity, certain attributes, or a certain current state. For example, you might filter a drilldown to see databases with the greatest I/O, tablespaces with the most direct writes, buffer pools with the lowest hit ratio, or applications that are currently connected.  

Criteria for a drilldown can include multiple filters. The more filters you create, the narrower the scope of the drilldown list. Only items that meet filter criteria are shown. All others are filtered out. If no objects meet filter criteria, "No Data" is shown in the drilldown.

Filtering applies to the current database and current session. It is not saved when the session ends.

Note: When filtering is in use, an asterisk is shown beside the name of a drilldown's list tab. For example, when filtering is in use for the Tablespace Analysis drilldown, Tablespaces* is shown at the top of the Tablespaces tab.

Using the Criteria tab

Follow the procedure below to specify filter criteria. Before you create or modify filters, review the columns shown in the drilldown. The columns you can select for a filter are the ones currently displayed. If you want to filter on columns that are not currently displayed, select those columns in the Column Organizer. To open this window, right click any column header and select Organize Columns... from the right-click menu.

Note: The first filter you create determines which values are shown in the Value list box for the next filter. For example, if your first filter specifies "Content = Large" and you select the Extent Size column for the next filter, the Value list box shows extent sizes for tablespaces with the Large content type. If you want to use an extent size that is not listed, enter it in the Value list box.

To specify filter criteria

1. Click the Criteria tab for a drilldown.

2. If you plan to use multiple filters in criteria, select an option from the Result Set will include list box as follows:

3. Specify criteria for a filter as follows:

4. Click Add to add the filter to the Active Filters list.

5. Repeat steps 3 and 4 for each filter you want to create.

6. To remove a filter from the Active Filters list, select it in the list, then click Remove. To remove all filters from the list, click Remove All.

Tip: To change the value for an active filter, remove the filter from the Active Filters list. Then create a new filter with the same column but a different value.

7. When you finish specifying filter criteria, click the information tab for a drilldown. The tab lists objects that meet filter criteria.