Physical Modeling › DB2 LUW Property Editors › Define a DB2 LUW Tablespace

Define a DB2 LUW Tablespace

Use the DB2 for LUW Tablespace Editor to specify parameters for a DB2 LUW tablespace.

To define a DB2 LUW tablespace

1. Right-click a Tablespace in the Model Explorer and select Properties.

   The DB2 for LUW Tablespace Editor opens.

2. Select a tablespace and work with the following options:

   Note: Click New on the toolbar to create a tablespace. Use the Enter filter text text box to filter a large list of names to locate the one you want to work with.

   Name

   Specifies the name of the tablespace.

   Type

   Specifies the tablespace type. Make a selection from the drop-down list: Large, Regular, System Temporary, or User Temporary.

   Managed By Type

   Specifies how the tablespace is managed. Select from the drop-down list; valid values are System, Database, and Automatic Storage.

   Database Partition Group

   Specifies the database partition group associated with the selected tablespace. Make a selection from the drop-down list.

   Generate

   Specifies whether or not to generate DDL for this object during Forward Engineering.

3. Complete the following fields on the General tab:

   Page Size

   Specifies the size of pages used for the tablespace. Select a page size from the drop-down list: 4k, 8k, 16k, or 32k.

   Extent Size

   Specifies the number of Page Size pages that are written to a container before skipping to the next container. Enter an integer in the text box.

   Prefetch Size

   Specifies whether or not the data needed by a query is read before it is referenced, so that the query does not wait for I/O to be performed. Enter an integer in the text box.

   Bufferpool

   Specifies the bufferpool used for tables in the selected tablespace. Select a bufferpool from the drop-down list.

   Use File System Caching

   Specifies whether or not I/O operations are cached at the file system level.

   Recover Dropped Table

   Specifies whether dropped tables can be recovered using the RECOVER DROPPED TABLE option of the ROLLFORWARD DATABASE command.

   Overhead

   Specifies the I/O controller overhead and disk seek and latency time. This value is used to determine the cost of I/O during query optimization. Enter an integer in the text box.

   Transfer Rate

   Specifies the transfer rate in milliseconds (that is, the time allocated to read one page into memory). Enter an integer in the text box.

   Use Auto-Resize

   Specifies whether or not you want to use the auto-resize capability of a DMS tablespace or an automatic storage tablespace.

   Initial Size

   Specifies the initial size of an automatic storage tablespace, for each database partition.

   Increase Size By

   Specifies how you want to increase tablespace, when an auto-resize tablespace is full and DB2 receives a request for space. Select from the drop-down list; valid values are Value and Percentage.

   Increase Size

   Specifies the amount of increase of the tablespace, per database partition.

   Max Size

   Specifies the maximum size to which a tablespace that is enabled for auto-resize can automatically be increased.

4. Click the Tablespace Container tab and work with tablespace the following options:

   Tablespace Container Name

   Specifies the name of the tablespace container.

   Database Partition

   Specifies the database partition name associated with the tablespace container. Select a partition from the drop-down list.

   Container Type

   Specifies the type of the container. The container can be file or device.

   Stripe Set

   Specifies the stripe set for the container.

   Total Pages

   Specifies the total pages for the container.

5. Click the Permission tab and grant permissions to users or roles on the selected tablespace.
6. Click the Comment tab and enter any comments you want to associate with the tablespace.
7. Click the Where Used tab to view where a tablespace is used in the model.
8. Click the UDP tab to work with user-defined properties for the tablespace.
9. Click the Notes tab to view history information and view or edit user notes.
10. Click Close.

    The DB2 for LUW Tablespace Editor closes.

More Information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor