Tablespaces Editor (IBM DB2 Z/OS)

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
Properties	Lets you work with properties in the following categories:
	Bufferpool	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.
Partitions	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.
Status	Lets you display CLAIMERS, LOCKS, LPL, USE, or WEPR status details
Space	Lets you view space usage and allocation details for the tablespace.
Objects	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.
Permissions	For details on using this tab, see Working with Privileges and Permissions.
DDL	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.