Tablespaces Editor (IBM DB2 LUW)

From DBArtisan
Jump to: navigation, search

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


Lets you work with settings in the following categories:


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.


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.


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.


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.


Lets you view the Nodegroup and specify a Bufferpool.


For details on using this tab, see Adding a Comment to an object.


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.


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.


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.