Physical Modeling › DB2 LUW Property Editors › Define a DB2 LUW Schema

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 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 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 Permissions Editor.
4. Click the Comment tab and enter any comments you want to associate with the schema.
5. Click the Where Used tab to view where the schema is used in the model.
6. Click the UDP tab to work with user-defined properties for the schema.
7. Click the Notes tab to view history information and view or edit user notes.
8. 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

Edit User Notes or View Object History