Guided Tours › New Database Support › DB2 Table Support - New Model

DB2 Table Support - New Model

Use the following steps to become familiar with DB2 table support in a new model.

1. Create a new DB2 (z/OS or LUW) v9.x model.
2. Add several entities to the model and populate with attributes using on-screen editing. Connect with relationships as needed.
3. Open the Entity, Attribute, and Key Group editors. Review and familiarize yourself with the layout of information available on all of the tabs in these editors.
4. Create a definition in one of these editors and check the spelling of your entered text.
5. Create one or more note entries.
6. Press F1 or the Help icon to access the context-level help for any of these editors. Review the help text and then close the online help.
7. Access the physical side of your model (if you created a Logical/Physical model) or derive a physical model (if you created a Logical-only model).
8. Open the Table Editor and review and familiarize yourself with the physical properties available on all of the tabs.
9. Assign your tables to different tablespaces (you will have to create the tablespaces first).
10. From within the Table Editor, access the Permission Editor (click the Permission Editor icon on the Permission tab).
11. Create several new permissions and close the Permission Editor.
12. Associate one or more of your permissions to one or more of your tables, and close the Table Editor, but do not save the model just yet.