Tablespaces Wizard (DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for z/OS Object Wizards

Tablespaces establish connections between the physical storage devices of your database system and the logical containers or tables being used to store data. In essence, a tablespace is a storage structure that can hold tables, indexes, large objects, and long data.

Note: To change the encoding scheme for a database after it is created to utilize a different coded character set identifier (CCSID) that supports the Euro symbol, all data must be unloaded and reloaded. For more information regarding the encoding scheme, contact your System administrator.

To Open the Tablespace Wizard

  1. On the Navigator/Explorer, find the datasource where you want to add the new Tablespace.
  2. Expand the Storage branch, right-click Tablespaces, and select New.
  3. Use the following table as a guide to setting properties and performing tasks as you pass through the wizard panels:
  4. Finally, use the Execute button to create the object.

Tablespaces (DB2 z/OS) - Properties

When creating or editing a tablespace, this tab/panel lets you work with the following settings:

Group Settings Description


Name and Database

Provide a name and select an assocaited database.

Database type

Lets you select a REGULAR or WORKFILE database type.

Creation type

Lets you select among PARTITIONED, SEGMENTED, RANGE-PARTITIONED UNIVERSAL, PARTITION-BY-GROWTH UNIVERSAL, and LOB options. Refer to DB2 z/OS product documentation for detailed information on these types and other required settings. For more information, see Accessing Third Party Documentation.

Tablespace management

Management type

Lets you select how you want the tablespace managed: DEFAULT STORAGE GROUP, STORAGE GROUP, or VCAT CATALOG-NAME.

Storage group, Minimum primary space allocation, Minimum secondary space allocation, and Erase rule

If you selected a Management type of STORAGE GROUP, select a storage group, specify minimum space allocations, and specify whether data sets are to be erased when the tablespace is dropped.


If you selected a Management type of VCAT catalog-name, select a catalog name.


Buffer Pool

Select the buffer pool where the tablespace is to reside.

Partitions and size

Number of partitions

If you selected a Creation Type of PARTITIONED or RANGE-PARTITIONED UNIVERSAL, specify the number of partitions.

Partition size (DSSIZE)

If you did not select a Creation Type of SEGMENTED, select a partition size.

Segment size

If you selected a Creation Type of SEGMENTED, PARTITION-BY GROWTH, or RANGE-PARTITIONED UNIVERSAL, select the number of pages that are to be assigned to each segment of the tablespace.

Max rows per page

Specify the number of rows (1-255) that can be placed on each data page.

Space Management

Free space portion of each page (%)

If you did not select a Creation Type of LOB, specify the percentage of each page to be left as free space when a tablespace is reloaded or reorganized.

Free page frequency

If you did not select a Creation Type of LOB, specify how often to leave a free page when a tablespace is reloaded or reorganized.

Other parameters


Select a group buffer pool cache scheme of CHANGED, ALL, SYSTEM, or NONE.


Enable this setting to allow compression.

Track modified pages

Enable this setting to track modified pages in the space map pages.

Encoding scheme

Select an encoding scheme of EBCDIC, UNICODE, ASCII, or NONE.


Enabling this check box specifies that changes to a LOB column are to be written to the log.


Enabling this check box specifies that tablespace data sets are defined when the tablespace is created. Otherwise, data sets are not created until data is inserted.

Member Cluster

Enable this setting to manage space for inserts on a member-by-member basis.

Close rule

Enable this setting to specify CLOSE YES, dictating the data set close priority.

Lock Size

Specify a lock size of ANY, TABLESPACE, PAGE, or ROW.

Maximum locks

Specify the number of locks that are allowed before escalating.