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

Define a DB2 z/OS Database

Use the Database editor to define the parameters for a DB2 z/OS database. In DB2, a database is a set of tablespaces and index spaces.

To define a DB2 z/OS database

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

   The DB2 z/OS Database Editor opens.

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

   Note: Click New on the toolbar to create a database. Use the Enter filter text text box to filter a very large list of databases to locate the one you want to work with.

   Name

   Specifies the name of the database.

   Is Workfile Database

   Specifies the database type. Select the check box to choose workfile.

   Is Temp Database

   Specifies the database type. Indicates that the database is for declared temporary tables only. This is valid for DB2 zOS version 8.1 only.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Work with the following fields on the General tab:

   Storage Group

   Specifies the storage group to use to support DASD space requirements for table spaces and indexes within the database.

   Default: SYSDEFLT

   Use Bufferpool

   Specifies the default bufferpool name to use for tablespaces created within the database. Select a bufferpool from the drop-down list.

   Index in Bufferpool

   Specifies the bufferpool name to use for the indexes created within the database. Select a bufferpool from the drop-down list.

   CCSID

   Specifies the default encoding scheme for data stored in the database. Select from the drop-down list; valid values are ASCII, EBCDIC, and UNICODE.

   Database Member Name

   When you indicate the database is a work file database, this field specifies the member for which this database is to be created.

4. Click the Permission tab to work with database permissions.
5. (Optional) Click the Comment tab and enter any comments you want associated with the database.
6. (Optional) Click the Where Used tab to view which components use the database.
7. (Optional) Click the UDP tab to work with user-defined properties for the database.
8. (Optional) Click the Notes tab to view history information and view or edit user notes.
9. Click Close.

   The DB2 for z/OS Database Editor closes.

More information:

Define DB2 z/OS Permissions at Database Level

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor