Working with models from the Deployment Script Editor

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:
  1. On the Overview page in the Deployment Script Editor, click the Data Models tab to display the Data Models page.
  2. In the Define Source Models area, click Add to display the Source Models selection window.
    1. Expand your project folder and select the model that you want to reference.
    2. Click OK to add this model to your deployment script.
  3. Click Edit Target Model to display the Model Editor and make changes to your target model.
  4. 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.
Related concepts
Models


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.