Previous Topic: Define DB2 z/OS Permissions at Object LevelNext 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 Permission 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 that you want to associate with the object.
  5. (Optional) Click the Where Used tab to view where the object is used within the model.
  6. (Optional) Click the UDP tab to work with user-defined properties for the object.
  7. (Optional) Click the Notes tab to view and edit user notes.
  8. (Optional) Click the Extended Notes tab to view or edit user notes.
  9. 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