Tablespaces Editor (IBM DB2 LUW)

From RapidSQL
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

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.
Personal tools