Manage DB2 Objects

You can create, template, alter, and drop Db2 objects as part of managing your alteration, migration, and comparison strategies.
carcmdb220
You can create, template, alter, and drop the following Db2 objects as part of managing strategies and then generate DDL when the strategy is analyzed:
  • Storage groups
  • Databases
  • Tablespaces
  • Tables
  • Indexes
  • Views
  • Sequences
  • Synonyms
  • Aliases
  • Triggers
  • Routines (user-defined functions and stored procedures)
You can also define defaults for Db2 object attributes. For information about the Db2 object attributes, Define Defaults for Db2 Object Attributes. For information about the attributes, see the IBM
Db2 SQL Reference Guide
.
The Create option performs all functions of the SQL CREATE statement. The Create panel provides an easy way to supply the information that is necessary to generate the DDL to be used to create the Db2 object. You can create Db2 objects from migration, comparison, and alteration strategies.
The Template option lets you create Db2 objects by using an existing object as a template. The Template panel displays the values that are used to create the object. Dependent objects are not included in the template operation.
The Alter option performs all functions of the SQL ALTER statement. This statement changes the definition of the object. From the Alter panel, you can make changes to the object values. The RC/Alter facility lets you perform a drop and recreate of an object with changes.
If one or more requested drops cannot be completed, none of the drops are committed.
When you press the END key (F3), a confirmation panel appears before the object DDL is executed. From this panel, you can accept, edit, or reject the DDL to be used to complete the request. You can perform a complete analysis of your changes that includes rebuilding the DDL and optionally including utility statements and extended DDL generation and analysis options.