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

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 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 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 you want associated with the tablespace.
8. (Optional) Click the Where Used tab to view where the selected tablespace is used.
9. (Optional) Click the UDP tab to work with user-defined properties for the tablespace.
10. (Optional) Click the Notes tab to view history information and view or edit user notes.
11. 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