BMC Software, Inc., Confidential and Proprietary Information
5-2 Administrative Products for DB2 Installation Guide
Overview
Overview
This chapter provides information about how to prepare to install the BMC
Software ALTER for DB2 product. The ALTER product provides both
management of application structures within a DB2 subsystem and a means
of migrating application structures from one DB2 subsystem to another.
ALTER performs the following major functions:
• changes data structures
• migrates data structures and their associated data
ALTER automates the task of changing data structures. It determines the
impact of the changes across the DB2 subsystem and prepares the most
efficient strategy for implementation. ALTER also performs extensive error
checking to ensure that the changes are correct before execution.
ALTER provides full management support for the following DB2 data
structures:
• storage group
• database
• table space
• table
• check constraint (DB2 Version 4.1 or later)
• foreign key
• index
• view
• trigger (DB2 Version 6.1 or later)
• alias
• synonym
When you use ALTER to specify any of these objects for change, ALTER
automatically propagates the change as needed for any dependent objects.
ALTER restores all data, dependencies, and authorizations, and supports a
large number of data-type conversions.
ALTER is able to use the BMC Software LOADPLUS, UNLOAD PLUS
®
,
REORG PLUS, CHECK PLUS, RECOVER PLUS, and COPY PLUS
utilities to speed up the execution of structure changes and migrations. In
addition, ALTER can be upgraded to the CHANGE MANAGER product
easily.
For information about ALTER, read the ALTER and CHANGE MANAGER
for DB2 User Guide.
