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
- Open an editor on the tablespace. For details, see Opening an Object Editor.
- 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.