IBM File Manager for z/OS User's Guide and Reference for DB2 Data Ver 14.1

Creating and dropping Db2 objects

You can use the Objects utility to create and drop Db2® objects without needing to know the SQL commands for these operations.

The Db2 Object Functions panel is option 3.2 from the Primary Option Menu panel. From the Db2 Object Functions panel you can select the Db2 object type you want to create or drop:

Specify the relevant number in the Object Type entry field. When you first display the Db2 Object Functions panel, this field is initialized to 3 (Table).
If you intend to drop an object but would like FM/Db2 to display a Drop Confirmation panel before it actually drops the object you have specified, ensure the Confirm object drop option is checked.
To create the specified object type, type C on the command line.
To drop the specified object type, type D on the command line.
Press Enter.

Table 1 shows the Db2 object types you can create or drop.

Table 1. Supported actions for each Db2 object
Object Type	Create	Drop
Database	Yes	Yes
Table space	Yes	Yes
Table	Yes	Yes
View	Yes	Yes
Alias	Yes	Yes
Index	Yes	Yes
Synonym	Yes	Yes
Distinct Type	Yes	Yes
Function	Yes	Yes
Stored Procedure	Yes	Yes
Trigger	Yes	Yes
Auxiliary Table	Yes	No¹
Notes: Use table drop. Populated auxiliary tables can only be dropped by dropping their associated base table. To drop an unpopulated auxiliary table without dropping its base table: Use the drop table function (by selecting Object Type 3 and entering D on the command line on the Db2 Object Functions panel. Specify the auxiliary table as the table to drop.

Related references

Feedback