Tablespaces Editor (IBM DB2 LUW)

Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors

The Tablespaces Editor lets you manage containers, basic properties, performance, space usage, and associated objects for a 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 settings in the following categories:
	Tablespace	Lets you view the Type (REGULAR, LARGE, TEMPORARY, or USER TEMPORARY), Use Automatic Storage, Managed By, and Database Partition Group properties. Lets you modify the Buffer Pool and Drop Recovery properties.
	Performance	Lets you view the Page SIze and Extent Size properties. Lets you specify or select the Prefetch Automatic, Overhead, Transfer Rate, and File System Caching properties.
	Automatic Storage	Lets you work with the AutoResize (enables following size settings), Initial Size, Increase Size, Max Size Unlimited, and Max Size (enabled if Max Size Unlimited is not set) attributes. The Initial Size and Max Size values can be provided as kB, mB, or gB values.
Container	This option is only available for database managed tablespaces. This tab lets you add or delete containers of a tablespace.
		Select an existing container and in the Property/Value list, use the Size controls to RESIZE, EXTEND, or REDUCE the container.
		Add a container by clicking New, and then in the Property/Value list, provide Name, number of Database Partitions, Type (DEVICE, FILE) and original Size.
		Click Delete to remove a container.
Performance	Lets you manage settings in the following categories:
	Page Setting	Lets you view Page SIze and Extent Size settings and modify the Prefetch Size setting.
	I/O Setting	Let you modify the Overhead and Transfer Rate settings.
	Dropped Table Settings	Lets you view the Recovery Status.
	Defaults	Lets you view the Nodegroup and specify a Bufferpool.
Comment	For details on using this tab, see Adding a Comment to an object.
Space	Lets you view the table usage and the distribution of space for a tablespace. Specific statistics include Free Pages, Used Pages, Reserved Pages, and Total Pages.
Objects	Lets you manage database objects associated with the tablespace. Objects are organized in a tree structure with folders containing the objects. Optionally, take one of the following actions:
		Select an object and click Edit to open an object editor on the selected object.
		Select an object and click Drop to initiate dropping the selected object.
Privileges	For details on using this tab, see Working with Privileges and Permissions.
DDL View	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.