Each row represents a table space.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TBSPACE | VARCHAR (128) | Name of the table space. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the table space. | |
OWNERTYPE | CHAR (1) |
|
|
CREATE_TIME | TIMESTAMP | Time at which the table space was created. | |
TBSPACEID | INTEGER | Identifier for the table space. | |
TBSPACETYPE | CHAR (1) | Type of table space.
|
|
DATATYPE | CHAR (1) | Type of data that can be stored in this table space.
|
|
EXTENTSIZE | INTEGER | Size of each extent, in pages of size PAGESIZE. This many pages are written to one container in the table space before switching to the next container. | |
PREFETCHSIZE | INTEGER | Number of pages of size PAGESIZE to be read when prefetching is performed; -1 when AUTOMATIC. | |
OVERHEAD | DOUBLE | Controller overhead and disk seek and latency time, in milliseconds (average for the containers in this table space). | |
TRANSFERRATE | DOUBLE | Time to read one page of size PAGESIZE into the buffer (average for the containers in this table space). | |
WRITEOVERHEAD | DOUBLE | Y | Reserved for future use. |
WRITETRANSFERRATE | DOUBLE | Y | Time to write one page of size PAGESIZE from the buffer to the table space (average for the containers in this table space). The null value means the same value as TRANSFERRATE will be used. |
PAGESIZE | INTEGER | Size (in bytes) of pages in this table space. | |
DBPGNAME | VARCHAR (128) | Name of the database partition group that is associated with this table space. | |
BUFFERPOOLID | INTEGER | Identifier for the buffer pool that is used by this table space (1 indicates the default buffer pool). | |
DROP_RECOVERY | CHAR (1) | Indicates whether or not tables in this table space can be
recovered after a drop table operation.
|
|
NGNAME1 | VARCHAR (128) | Name of the database partition group that is associated with this table space. | |
DEFINER2 | VARCHAR (128) | Authorization ID of the owner of the table space. | |
DATAPRIORITY | CHAR (1) | Reserved for future use. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|