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

File-AID for DB2 ------------- Object List Utility ----------------
COMMAND ===>                                        SCROLL ===> CSR
                                                      SSID ===> DSN

Enter both of the parameters below:

   Object Name ===>              (* for all)
   Object Type ===>              (*=All or use S to select from list)

    Table            _ View              _ Synonym         _ Alias
  _ Index            _ Tablespace        _ Plan            _ Package
  _ Temporary Table _ Auxiliary Table   _ Trigger         _ User Defined Function
  _ Distinct Type    _ Stored Procedure _ MQT             _ Clone Table
  _ History Table    _ IDAA Table

Specify Selection Criteria:
   Object Creator ===>       (For all except Tbsp,Pkg,Trigger & SP)
   Database Name   ===>       (For Tablespace only)
   Collection ID   ===>       (For Package only)
   Schema Name     ===>       (For Triggers,SP,UDF & Distinct type)

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

Important

You can also select an object to model, alter, drop from the Objects utility. Refer to Object-Administration-and-Objects-Utilities for more information.

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

Object List Selection Screen

File-AID for DB2 ----------- Object List Selection -------- Row 1 to 5 of 5
COMMAND ===>                                               SCROLL ===> PAGE
                                                                  SSID: DSN

E - Edit   B - Browse   L - Load   X - Extract   I - Info   G - Grant   R - Revoke
M - Model A - Alter    D - Drop   T - Truncate GD - DDL   P - Privileges

Cmd   Name        Creator    Type     Message
---   ------------------------------------------------------------------
__    EMPBROWN    TSOID01    TABLE
__    EMP1        TSOID01    TABLE
__    ORG         TSOID01    TABLE
__    ORG2        TSOID01    TABLE
__    PROJ        TSOID01    TABLE

*************************** Bottom of data ***************************

Important

Object Administration is displayed when you execute the following commands: G, R, M, A, D, T, GD, or P. Refer to File-AID for Db2 Object Administration User Reference for more information.

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.