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:
- From the main menu bar, click .
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 .
- Complete the steps in the New Physical Data Model wizard to create
a new model:
- Select the destination folder (or project) into which to place
the model.
- Choose to create the model from reverse engineering with database
as the source.
- Select the schemas that you want to include so that you can
narrow the scope of the model that you want to work with.
- Specify the database elements to include in the model.
- 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.