Tablespaces Editor (IBM DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for z/OS Object Editors

The Tablespaces Editor lets you work with the basic properties and partitions for a tablespace as well as view space details, status, and objects stored on the tablespace.

To edit a tablespace

  1. Open an editor on the tablespace. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you work with properties in the following categories:


Buffer Pool

Partitions and size

Number of partitions, Partition size (DSSIZE), Segment size, and Max rows per page

Other parameters

GBPCACHE, Compress, Track modified pages, Encoding scheme, Log, Define, Member Cluster, Close rule, Lock Size, and Maximum locks

For more information on these properties, see Tablespaces (DB2 z/OS) - Properties.


Displays a list of partitions for the tablespace. Details for each partition include the storage group, VCAT, primary and secondary space allocations, the free space portion of each page and free page frequency, the group buffer cache scheme, and whether modifications are tracked. Optionally, you can:

Select a partition and click Edit to open a dialog that lets you modify properties for that partition.

Select a partition and click Clone to open a dialog that lets you apply the attributes of the selected partition to another partition.


Lets you display CLAIMERS, LOCKS, LPL, USE, or WEPR status details


Lets you view space usage and allocation details for the tablespace.


Displays the objects stored on the tablespace. Objects are organized in a tree structure with folders containing the objects. Optionally, you can:

Select an object and click Edit to open an object editor on that object.

Select an object and click Drop to initiate dropping that object.


For details on using this tab, see Working with Privileges and Permissions.


For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.