Table space properties (DB2 for Linux, UNIX, and Windows)

Properties for DB2® for Linux, UNIX, and Windows table space objects

For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Type Shows the type of table space. You cannot modify this option.
Management Specifies an option for the MANAGED BY clause.
Page Size Defines the size of pages used for the table space. Valid values are displayed in the list.
Extent Size Specifies a value for the EXTENTSIZE clause. Specifies the number of PAGESIZE pages that will be written to a container before skipping to the next container.
Prefetch Size Specifies to read in data needed by a query prior to it being referenced by the query, so that the query need not wait for I/O to be performed.
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. The value of number-of-milliseconds is any numeric literal (integer, decimal, or floating point). If this value is not the same for all containers, the number should be the average for all containers that belong to the table space.
Transfer Rate Specifies the time to read one page into memory. This value is used to determine the cost of I/O during query optimization. The value of number-of-milliseconds is any numeric literal (integer, decimal, or floating point). If this value is not the same for all containers, the number should be the average for all containers that belong to the table space.
Recover Dropped Table Indicates whether dropped tables in the specified table space can be recovered using the RECOVER DROPPED TABLE option of the ROLLFORWARD DATABASE command. This clause can only be specified for a regular or large table space.
Group Optional: Specifies the database partition group for the table space. The database partition group must exist. The only database partition group that can be specified when creating a SYSTEM TEMPORARY table space is IBMTEMPGROUP.
Buffer Pool The name of the buffer pool used for tables in this table space. The buffer pool must exist. If not specified, the default buffer pool is used. The page size of the buffer pool must match the page size specified (or defaulted) for the table space. The database partition group of the table space must be defined for the buffer pool.
Tables page

Shows the tables that are assigned to this table space. You can highlight a table in the list and click Show Properties to view the properties for the table in the Properties view.

To modify the list, you must modify the Table Space properties of each table object.

Containers page
Specifies containers for the table space. For detailed information about syntax, see the related information.
Size page
Property Description
Initial Size Specifies the initial size, per database partition, of an automatic storage table space. This option is only valid for automatic storage table spaces. The integer value must be followed by K (for kilobytes), M (for megabytes), or G (for gigabytes).
Increase Size Specifies the amount, per database partition, by which a table space that is enabled for auto-resize will automatically be increased when the table space is full, and a request for space has been made. Units for INCREASESIZE can be K, M, G or PERCENT (percentage of the current size)
Maximum Size Specifies the maximum size to which a table space that is enabled for auto-resize can automatically be increased. If the table space is auto-resizable, but the MAXSIZE clause is not specified, the default is NONE.
Partitioning page
In edit mode, enter comma-separated partition numbers to specify which partitions each container exists on.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback