Creating a deployment script

You need to create a deployment script to deploy your changes to your target database.
To create a new deployment script, complete the following steps:
  1. Click File > New > Deployment Script to start the Deployment Script wizard.

    You can also create a Deployment Script by using the following methods:

    • Click the down arrow for the New icon and click Deployment Script to start the New Deployment Script wizard.
    • Right-click in the Data Project Explorer, and select New > Deployment Script to start the New Deployment Script wizard.
  2. Complete the steps in the New Deployment Script wizard to create a new deployment script.

    DB2® Change Management Expert creates the base and target models for you. You can filter by schema name so that you can narrow the scope of the two models that you want to work with.

    Tip: DB2 Change Management Expert uses the base model to ensure the database has not changed between the time that the change was created, defined, and deployed. Always check to see that the base model matches the catalog when deploying a script. However, never refresh the base model without forward fitting changes to the target model because the deployment script might backout changes from another change.

    Start of changeIf you have DB2 Grouper installed, DB2 Change Management Expert checks for your Grouper groups and allows you to use those groups when you create a new deployment script. When you create a new deployment script, the New Deployment Script wizard will display your Grouper set names on the Select Setname page. Select the Grouper group that you want to include in your deployment script and click Next. The schemas that belong to those Grouper groups will be preselected on the Select Schema page of the wizard.End of change

    Start of changeFor more information about installing and using DB2 Grouper, see the DB2 Grouper User's Guide.End of change

  3. The Deployment Script Overview page is displayed after you complete the steps in the Deployment Script wizard.
From the Deployment Script Overview page, you can manage most of your change management operations. Click the Data Models tab and the Change Commands tab to work with your deployment script.
Tip: The DB2 instance name of the database must be correct in the New Deployment Script wizard. With DB2 version 8.1 fix pack 9 and above, DB2 Change Management Expert can detect the DB2 instance name. If DB2 Change Management Expert is unable to detect the instance name, then DB2 Change Management Expert will use DB2 as the default instance name. You can edit the instance name on the Overview page of the Deployment Script Editor.
Related concepts
Methods of creating a model
Change commands
Impact analysis
Related tasks
Creating a project
Refreshing a base model
Deploying change commands
Deploying undo commands


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.