Creating a model from a DB2 catalog

You can create a model by extracting information from a DB2 catalog and importing the information into DB2® Change Management Expert.
Prerequisites: You must have a project in the Data Project Explorer view before creating a model.
To create a model from a DB2 catalog, complete the following steps:
  1. From the main menu bar, click File > New > Physical Data Model. The New Physical Data Model wizard starts.
    You can also invoke the New Physical Data Model wizard by using either of the following methods:
    • Click the down arrow on the New button on the main menu bar, and click Physical Data Model.
    • Right-click a project in the Data Project Explorer view, and click New > Physical Data Model.
  2. Complete the steps in the New Physical Data Model wizard to create a new model:
    1. Select the destination folder (or project) into which to place the model.
    2. Choose to create the model from reverse engineering with database as the source.
    3. Select the schemas that you want to include so that you can narrow the scope of the model that you want to work with.
    4. Specify the database elements to include in the model.
    5. Evaluate whether you want to select the options to infer implicit relationships or infer implicit primary keys on the last page of the wizard. In many cases, you do not want the model to include the implicit objects that were created by DB2.
The model is added to your project, and it is displayed in the navigation tree. You are now ready to work with the model.


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.