Previous Topic: Define DB2 LUW Permissions at Object LevelNext Topic: Define a DB2 LUW Sequence


Define a DB2 LUW Schema

You can use a schema to create a logical group of named objects. A schema is a database object that can contain tables, views, nicknames, triggers, functions, packages, and other objects. A schema is explicitly created using the CREATE SCHEMA statement, with the current user or a specified authorization ID recorded as the schema owner.

To define a DB2 Schema

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

    The DB2 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.

    Name

    Specifies the name of the schema.

    Owner (DB2 LUW only)

    Specifies the owner for the schema. Select an owner name from the drop-down list. The names displayed here are the user IDs you have created for this database.

    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 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 Schema Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor

Define DB2 LUW Permissions at Object Level

View the Where Used Information for a Physical Object