Adding a folder in the customized tree
Use the Add folder notebook to specify a group of objects to be contained inside of a generically created folder. You specify criteria and search a database object
for a name within the DB2 subsystem. The criteria that you can specify depend on the object type that you create. If you name a database object, you can search for or create other objects that might be contained in a database object. Then you create a folder
based on this search and it becomes part of your customized tree.
Use the Locate page to specify search criteria and use the Advanced
page to further customize the search and verify your input, unless you have selected the Generic object type.
Authorities
and privileges
To add a folder for your customized tree:
- Open the Add folder notebook.
- In the Folder name field, type a string to identify your new
folder.
- From the object type field,
select the type of database object for which to create a folder.
- On the Locate page, specify the search criteria. If you have chosen a Generic object type, the following fields do not apply:
- Use the Column ,
Comparison , and
Values fields to
specify criteria for up to five different catalog columns. Type some
value in at least one of the Values fields, including a
one-character wild-card (for an inclusive search). 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 macro DSNTIPF.
- 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.
- Click the Clear push button to erase the values you typed.
- Optional: If you have selected an index object type or a table space object type, you also have the further option to define criteria for running utilities at recommended intervals. Your folder then represents objects that match the criteria you defined using those utilities.
- 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.
- Click OK to use the search criteria that you defined.
The result of your search is displayed in a separate window.
- Click the Apply to repeat the search with the same or different criteria.
Related information