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.
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.
Privileges (DB2 for Linux, UNIX, and Windows)
Specify which users, groups, and roles can access the table space.
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.
I/O Settings page
Property Description
File System Caching Specifies that all I/O operations in the target table space are to be cached at the file system level.
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.
System Type Automatically sets the Average Seek Time, Rotation Speed, and Transfer, based on the type of hard drive on the system.
Average Seek Time Specifies the average amount of time it takes to seek table data. This value can be used to automatically calculate the I/O controller overhead.
Rotation Speed Specifies the disk cycle time in revolutions per minute needed to calculate latency time. This value can be used to automatically calculate I/O controller overhead.
Transfer Specifies the disk transfer rate in megabytes per second. This value can be used to automatically calculate I/O transfer rate.
Storage Options page
Property Description
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.
Size page
Property Description
Page Size Defines the size of pages used for the table space. Valid values are displayed in the list.
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).
Autoresize Specifies whether or not the auto-resize capability of a DMS table space or an automatic storage table space is to be enabled. Auto-resizable table spaces automatically increase in size when they become full.
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.
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.
Average Table Size Specifies the average size of tables in this new table space. This value can be used to automatically calculate Extent Size and Prefetch Size.
External container count Specifies how many containers exist on separate physical hard drives. This value can be used to automatically calculate Extent Size and Prefetch Size.
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