Locating an object

Use the Locate notebook to specify criteria and search a database object for a name within the DB2 subsystem. Depending on where you start your search from, you can find objects that exist across the subsystem (selecting Locate from the subsystem folder), or within a much narrower scope: inside the database, the table space, or across tables and their supporting objects. If you are searching in index or table space objects, you can also set search criteria to help you decide whether to run certain utilities. Use the Locate page to specify search criteria and use the Advanced page to further customize the search.

Authorities and privileges

To locate an object defined within your subsystem:

  1. Open the Locate notebook.

  2. From the object type field, select the type of database object to search. This list of objects available is dependent on the origin of your search. For example, if you select Locate from the subsystem folder, you have all objects available to you in the Object type field. In this case your search would only be limited by the subsystem and the criteria you define on the Locate page. To contrast this broad search, if you originated your search by selecting Locate from the Indexes folder inside the Database object on the tree, your options for Object type are limited to Indexes only. You could only search for another index type in this case.

  3. On the Locate page, specify the search criteria:

    1. Use the Column , Comparison , and Values fields to specify criteria for up to five different catalog columns. You must either type some value in at least one of the Values fields, including a one-character wild-card (for an inclusive search) or specify some criteria to define a needed utility (for index and table space objects only). To search on all objects, type the wild-card % in a field. The strings you type in the values column will be folded to upper case unless delimited. If you want to determine your subsystem's default delimiters, click on your subsystem folder in the Control Center and right-click on Display Subsystem Parameters. Search for the install panel DSNTIPF.

    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: If you specified Index or Table Space in the Object type field, in the Object state filters box:

      1. Specify a filter for the index or table space.
      2. Depending on the type of filter you specified in the above field, you can add further criteria as needed to determine if some utility should be run against the index or table space. Each filter type determines what other parameters you need to provide to define an adequate search. See the example of using the locate window with utility output criteria for more information.

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

  5. Click OK to use the search criteria that you defined. The result of your search is displayed in a separate window.

  6. Click the Apply to repeat the search with the same or different criteria.

Related information

Scenario:

You decide to locate all the table spaces within the DSNDB04 database that have back-ups older than 7 days. You do this to determine which table spaces need to have the COPY utility run on them.

  1. From the Control Center, right-click on the Database object. Select Locate from the pop-up menu. The Locate window opens.
  2. Specify Table Spaces in the object type field. Notice that since you have started your search from the Database folder, your choices in the object type field are:
    1. to search for a particular database among all the databases,
    2. to search for an index within the database,
    3. to search for a table within the database, or
    4. to search for a table space within the database.
  3. Type DSNDB04% in the Values field by the database column to further restrict the search. With a wild-card, use the LIKE comparison operator. If you use the equal '=' sign, do not include a wild-card. If you leave the Values field blank, your search is based on the criteria you establish to determine if any utilities updates need to be made on all table spaces.
  4. Select Backup too old in the Object state filter field.
  5. Choose the kind of Table Space copy on which to search.
  6. Select the Number of days check box to be able to enter an age in the field.
  7. Type a 7 in the field to set the filter to find all table spaces with back-ups older than 7 days.
  8. Click the Apply push button. The output is a list of table spaces in database DSNDB04 that need the utility COPY applied to them because their current back-up copies are greater than seven days old.
  9. From this list, right-click on one or more rows and select Copy from the pop-up menu to update your back-up copies.