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.
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. |
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.
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. |