Tablespaces Wizard (DB2 LUW)
Go Up to IBM DB2 for Linux, Unix, and Windows Object Wizards
Tablespaces establish connections between the physical storage devices of your database system and the logical containers or tables being use to store data. In essence, a tablespace is a storage structure that can hold tables, indexes, large objects, and long data. The Tablespace Wizard lets you create a tablespace without knowing the underlying commands.
To create a new tablespace using a wizard:
- Open a creation wizard for a tablespace. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Tablespaces (DB2 LUW) - Properties.
- Container panel - for details, see Tablespaces (DB2 LUW) - Container.
- Comment panel - for details, see Adding a Comment to an Object.
- Permissions panel - Setting Permissions or Privileges for an Object
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Tablespaces (DB2 LUW) - Properties
When creating or editing a tablespace, this tab/panel lets you work with the following settings:
| Setting | Description |
|---|---|
|
Tablespace properties |
Type - Select REGULAR, LARGE, TEMPORARY, or USER TEMPORARY. Use Automatic Storage and Managed By let you specify whether storage is managed automatically, by the database, or by the system. Database Partition Group - lets you select a database partition group. Buffer Pool - lets you select a buffer pool. Drop Recovery - For REGULAR type tablespaces, lets you enable/disable drop recovery. |
|
Performance properties |
This group lets you specify or select the Page SIze, Extent Size, Prefetch Automatic, Prefetch Size, Overhead, Transfer Rate, and File System Caching properties. |
|
Automatic Storage properties |
This group lets you specify or select the AutoResize, Initial Size, Increase Size, Max Size Unlimited, and Max Size attributes. |
Tablespaces (DB2 LUW) - Container
For each container in the tablespace, in the Container Properties area, provide the following container properties: Database Partitions, Type (FILE or DEVICE), Name, and Size, and then click the New button.
Use the Delete button to drop a selected container.