Object Administration and Objects Utilities
This section describes the two File-AID for Db2 utilities, Object Administration and Objects, which allow you to create, model, drop, or alter Db2 objects.
Enter option 3 (Utilities) on the Primary Option Menu to access the Utility Selection Menu (see the following figure). From this menu, all of the utilities are available for selection.
Utility Selection Menu
File-AID for DB2 ------------------- Utility Selection Menu -------------------
OPTION ===> SSID ===> DSN
1 OBJECT ADMIN - Object Administration
2 OBJECTS - Create, Model, Drop, Alter
TABLE, TABLESPACE, INDEX, VIEW, SYNONYM, ALIAS,
DISTINCT TYPE, USER DEFINED FUNCTION,
STORED PROCEDURE, TRIGGER, MATERIALIZED QUERY TABLE
3 COPY - COPY Rows Between TABLES
Copy Entire TABLES or Rows/Columns Selectively
4 OBJECT LIST - Process DB2 Object Lists
5 SQL MGR - SQL Command Manager / SPUFI Connection
6 PRIVILEGES - Display, Grant, or Revoke DB2 Privileges
7 EXTRACT, LOAD - Extract and Load Tables
8 IMPACT ANALYSIS - Identify DB2 objects affected by a column change
9 BATCH FACILITY - Batch Execute SQL with Auto-COMMIT Processing
OPTION ===> SSID ===> DSN
1 OBJECT ADMIN - Object Administration
2 OBJECTS - Create, Model, Drop, Alter
TABLE, TABLESPACE, INDEX, VIEW, SYNONYM, ALIAS,
DISTINCT TYPE, USER DEFINED FUNCTION,
STORED PROCEDURE, TRIGGER, MATERIALIZED QUERY TABLE
3 COPY - COPY Rows Between TABLES
Copy Entire TABLES or Rows/Columns Selectively
4 OBJECT LIST - Process DB2 Object Lists
5 SQL MGR - SQL Command Manager / SPUFI Connection
6 PRIVILEGES - Display, Grant, or Revoke DB2 Privileges
7 EXTRACT, LOAD - Extract and Load Tables
8 IMPACT ANALYSIS - Identify DB2 objects affected by a column change
9 BATCH FACILITY - Batch Execute SQL with Auto-COMMIT Processing
This section provides information about the following topics:
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*