DB2® Change Management Expert allows
you to easily identify changes and create more changes throughout your database
environment. DB2 Change Management Expert uses
models to help you transition database structural changes throughout your
database environment.
Instead of making changes directly to the DB2 catalog,
you make changes to models. A model is a representation of the database
catalog. Models can be used to plan changes to a database, analyze the impact
of those changes, and to eventually deploy those changes to the actual database.
On
the Data Models page, you can:
- Organize changes
- Identify and define changes to the target database by comparing your base
and target models in the Comparison Editor
- Identify and merge differences between source and target databases
- Add a source database to the list
- Select the newly added database
- Merge changes from your source model into your target model
- Edit the target model directly
- Automatically apply changes from another deployment script
To work with models from the Deployment Script Editor, complete the
following steps:
- On the Overview page in the Deployment Script Editor, click the Data
Models tab to display the Data Models page.
- In the Define Source Models area, click Add to
display the Source Models selection window.
- Expand your project folder and select the model that you want
to reference.
- Click OK to add this model to your deployment
script.
- Click Edit Target Model to display the Model
Editor and make changes to your target model.
- Click Compare Base and Target Models to
display the Comparison Editor, which you can use to analyze the differences
between your base and target models.
After you have defined your base and target models, proceed to the Change
Commands tab to generate and define your change commands.