Previous Topic: Define a DB2 z/OS Storage GroupNext Topic: Define DB2 z/OS Tablespace Partition Elements


Define a DB2 z/OS Tablespace

Use the Tablespace editor to specify parameters for a DB2 z/OS tablespace.

To define a DB2 z/OS tablespace

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

    The DB2 for z/OS Tablespace Editor opens.

  2. Select a tablespace 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 tablespace. Use the Enter filter text text box to filter a large list of tablespaces to locate the one you want to work with.

    Name

    Specifies the name of the tablespace.

    Storage Type

    Specifies the tablespace storage type. Valid Values are: Large or LOB. Your choice affects the display of the parameters below.

    Database

    Specifies the database in which to store the tablespace.

    Generate

    Specifies whether or not to generate DDL for this object during Forward Engineering.

  3. Work with the following properties on the General tab:
    Define Data Sets

    Specifies that the data sets are created when the tablespace is created. Clear the check box to indicate DEFINE NO.

    Suppress Logging

    Indicates that changes to a LOB column in the tablespace are written to the log. Clear the check box to not write changes to the log.

    Data Set Size (LOB only)

    Indicates the value, in gigabytes, for the maximum size for data sets. Select a data set size from the drop-down list.

    Use Bufferpool

    Indicates the bufferpool to be used for the tablespace. Select a bufferpool name from the drop-down list.

    Close

    Indicates that, when the limit on the number of open data sets is reached, the tablespace is eligible for closing before CLOSE NO data sets. Clear the check box to indicate CLOSE NO.

    Lock Max

    Specifies the maximum number of page, row, or LOB locks an application process can hold simultaneously in the tablespace.

    Lock Size

    Specifies the size of locks used within the tablespace. Select a lock size from the drop-down list. Valid Values are: Any, Table, TableSpace, Page, Row, LOB.

    Track Modified Pages

    Indicates that modified pages in the space map pages are tracked for the partition. Clear the check box to indicate TRACKMOD NO.

    CCSId

    Specifies the encoding scheme for table stored in the tablespace. Select a value from the drop-down list. Valid values are: ASCII, EBCDIC, or UNICODE.

    Is Compressed

    Indicates that data compression applies to the rows of the tablespace or partition. Clear the check box to indicate COMPRESS NO.

    Max Rows

    Specifies the maximum number of rows (indicated as an integer) to place on each data page.

    Segment Size

    Specifies how many pages (indicated as an integer) are to be assigned to each segment.

  4. Click the Partitions tab and work with the following options:
    Maximum Partitions

    Indicates the maximum number of partitions to which the tablespace can grow. Enter an integer in the text box.

    Member Cluster

    Indicates that data is not clustered. Clear the check box to allow DB2 to locate the data in the tablespace based on available space.

    Partitions Count

    Specifies the number of partitions in the tablespace.

    Name

    Specifies a name for the partition.

    Note: Click New New icon in property editors to create a new object to create a partition element.

    Partition Number

    Specifies the partition element number. Click the Partition Element Editor icon to define a new partition and its properties.

  5. Click the Using Clause tab and work with the following options:
    Volume Catalog

    Specifies that the first data set of the index is managed by the user. Catalog Name identifies the linear VSAM data sets that are cataloged in an integrated catalog facility catalog.

    Storage Group

    Specifies that DB2 manages the data set.

    Primary Space Allocation

    Specifies the minimum primary space allocated to a DB2-managed data set. If you do not specify any value, DB2 uses a default value.

    Secondary Space Allocation

    Specifies the minimum secondary space allocated to a DB2-managed data set. If you do not specify any value, DB2 uses a formula to calculate the value. For more information, refer to IBM DB2 for z/OS documentation.

    Erase When Deleted

    Specifies whether or not to delete the DB2-managed data sets when the index is dropped while executing a utility or an SQL statement.

    Free Page Interval

    Specifies the frequency at which you want to leave a page of free space when you create index entries while executing a DB2 utility or when you create an index for a table with existing rows.

    Percent Free

    Specifies the percentage of free space you want to leave in each nonleaf page and leaf page when you add entries to an index or index partition while executing a DB2 utility or when you create an index for a table with existing rows.

    Group Bufferpool

    Specifies the index pages that are written to the group buffer pool and applies to the data sharing environment. Select from the drop-down list; valid values are: Changed, All, None, and System.

  6. Click the Permission tab to add and define permissions.
  7. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  8. (Optional) Click the Where Used tab to view where the object is used within the model.
  9. (Optional) Click the UDP tab to work with user-defined properties for the object.
  10. (Optional) Click the Notes tab to view and edit user notes.
  11. (Optional) Click the Extended Notes tab to view or edit user notes.
  12. Click Close.

    The DB2 for z/OS Tablespace Editor closes.

More information:

Specify DB2 z/OS Using Clause Parameters

Define DB2 z/OS Permissions at Database Level

Define DB2 z/OS Table Partition Elements

Define DB2 z/OS Table or Index Partitions

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor