Access Object List Utility

When you select option 4 from the Utility Selection Menu, the Object List Utility screen appears (see the following figure). You can select multiple objects at once. After you press Enter, the requested objects appear; page through to see all of them.

Object List Utility Screen

Object Name

Name of the objects you want listed. Wild card characters are allowed. See Wildcard-Characters for more information.

Object Type

Enter an asterisk (*) to select all objects, or leave blank and use an S to select specific objects from those listed on the screen.

Object Creator

ID of person who created the objects you want to list. Does not apply to tablespaces, packages, triggers, stored procedures, distinct types, or user defined functions.

Database Name

Name of the database that contains the tablespaces you want to list. Required for an object type of Tablespace.

Collection ID

Name of the collection ID that contains the packages you want to list.

Schema Name

Schema or authid for triggers, stored procedures, UDF or distinct type you want to list.

When you have entered the name and type of object you want to see, File-AID for Db2 returns a list of those objects. You can change the order in which they are displayed by using the SORT command (see SORT for details).

The following figure shows a sample Object List Selection screen for a list of tables.

Object List Selection Screen

CMD

Specify the line command you want to invoke for an object. Valid commands are listed across the top of the screen.

NAME

Names of the objects in the list.

CREATOR

ID of person who created the listed objects.

TYPE

Type of the listed objects. For stored procedure, includes both language and SP (right justified). When sorting on stored procedures, the sort goes first by SP, then by the language.

MESSAGE

Messages (if any) for the listed objects. Indicates last action. For UDFs, displays the specific name of the function.