Physical Modeling › DB2 z/OS Property Editors › Define a DB2 z/OS Schema

Previous Topic: Define DB2 z/OS Permissions at Object Level

Next Topic: Define a DB2 z/OS Sequence

Define a DB2 z/OS Schema

A schema provides a logical classification of objects in a database. The schema name is used as the qualifier for SQL object names such as tables, views, indexes, and triggers.

To define a DB2 for z/OS Schema

  1. Right-click a Schema in the Model Explorer and select Properties.

    The DB2 for z/OS Schema Editor opens.

  2. Select a schema and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a schema. Use the Enter filter text text box to filter a large list of schemas to locate the one you want to work with.

    Name

    Specifies the name of the schema.

    Generate

    Specifies whether or not to generate DDL for this object during Forward Engineering.

  3. Click the Permissions tab and select a permission to associate with the schema. You can create a permission or click the Permissions Editor icon to open the DB2 for z/OS Permissions Editor.
  4. (Optional) Click the Comment tab and enter any comments you want associated with the schema.
  5. (Optional) Click the Where Used tab to view where the schema is used in the model.
  6. (Optional) Click the UDP tab to work with user-defined properties for the schema.
  7. (Optional) Click the Notes tab to view history information and view or edit user notes.
  8. Click Close.

    The schema is saved and the DB2 for z/OS Schema Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor

Define DB2 z/OS Permissions at Object Level

View the Where Used Information for a Physical Object

Edit User Notes or View Object History