Previous Topic: Define a DB2 z/OS Database RoleNext Topic: Define a DB2 z/OS File


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 New icon in property editors to create a new object 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 that you want to associate with the object.
  6. (Optional) Click the Where Used tab to view where the object is used within the model.
  7. (Optional) Click the UDP tab to work with user-defined properties for the object.
  8. (Optional) Click the Notes tab to view and edit user notes.
  9. (Optional) Click the Extended Notes tab to view or edit user notes.
  10. 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