Previous Topic: Define DB2 LUW Global Temporary TableNext Topic: Define DB2 LUW XML Indexes


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 New icon in property editors to create a new object 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. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  7. (Optional) Click the Where Used tab to view where the object is used within the model.
  8. (Optional) Click the UDP tab to work with user-defined properties for the object.
  9. (Optional) Click the Notes tab to view and edit user notes.
  10. (Optional) Click the Extended Notes tab to view or edit user notes.
  11. 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