Tablespaces Wizard (DB2 LUW)

Go Up to [[IBM DB2 for Linux, Unix, and Windows Object Wizards{{#if:||{{{2}}}}}]]

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:

1. Open a creation wizard for a tablespace. For details, see Opening an Object Wizard.
2. 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. For details, see Setting Permissions or Privileges for an Object
   • DDL View panel. For details, see Previewing the DDL Generated to Create the New Object.
3. Click Execute 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. Specify whether storage is managed automatically, by the database, or by the system. Database Partition Group. Select a database partition group. Buffer Pool. 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 New.

Use the Delete button to drop a selected container.