Objects - Create, Model, Drop, Alter

The Objects utility lets you create, model, drop, or alter Db2 objects, including tables, tablespaces, indexes, views, synonyms, aliases, distinct types, User Defined Functions (UDF), stored procedures, triggers, and Materialized Query Tables (MQT). The screens are discussed in the order displayed on the Object Selection menu.

The Objects utility uses the File-AID for Db2 display (traditional ISPF interface), as long as you are selecting or navigating. However, once you have selected a function, Object Administration is displayed, which presents a window-like interface within ISPF. For information on Object Administration, refer to the File-AID for Db2 Object Administration User Reference manual.

Enter option 2 on the Utility Selection Menu for the Create, Model, Drop, Alter Db2 Objects utility. The Object Selection menu displays, as in the following figure.

Object Selection Menu