Filtering objects

Use the Filter window to define a set of criteria for displaying a list of objects in the Control Center. You can limit the number of objects that are displayed by creating filters for one or more objects. Once you set the filter for an object, you must explicitly clear the filter to display all elements in an object, or all objects in the tree. The control center will display only those objects meeting the specified filter criteria.

When you use a filter, the control center searches the DB2 catalog looking for a particular type of DB2 object requested by the user and matching the user's filter criteria. The result of the search can return from 0 to all the objects of that type.

Authorities and privileges

To define a filter:

  1. Open the Filter window.

  2. On the Locate page, specify the name of an object in the Control Center that you want to filter.

  3. Specify a set of search criteria that are active during the life of this object until explicitly modified or cleared. The result of your search is the current list of objects in the contents pane of the control center.

    1. Use the Column, Comparison, and Values fields to specify criteria for up to five different catalog columns.

    2. Select a radio button to specify whether to meet all the conditions selected in the fields on the Locate page, or meet at least one of the conditions. Meet all conditions is equivalent to adding an and between the search criteria, and Meet any conditions is equivalent to adding an or between the search criteria.

    3. Optional: Customize your search. Select the Advanced tab to change the WHERE clause generated from your choices on the Locate page. You can derive your own WHERE clause, or add more predicate columns to the existing clause.

  4. Click OK to use the search criteria that you selected and close the filter notebook. The result of filtering is a subset of the list of objects that can be displayed.

Related information