Contains a row for each table space.
Table 67. SYSCAT.TABLESPACES Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| TBSPACE | VARCHAR(18) |
| Name of table space. |
| DEFINER | CHAR(8) |
| Authorization ID of table space definer. |
| CREATE_TIME | TIMESTAMP |
| Creation time of table space. |
| TBSPACEID | INTEGER |
| Internal table space identifier. |
| TBSPACETYPE | CHAR(1) |
| The type of the table space:
S=System managed space D=Database managed space |
| DATATYPE | CHAR(1) |
| Type of data that can be stored:
A=All types of permanent data L=Long data only T=Temporary tables only |
| EXTENTSIZE | INTEGER |
| Size of extent, in 4K pages. This many pages are written to one container in the table space before switching to the next container. |
| PREFETCHSIZE | INTEGER |
| Number of 4K pages to be read when prefetch is performed. |
| OVERHEAD | DOUBLE |
| Controller overhead and disk seek and latency time in milliseconds. |
| TRANSFERRATE | DOUBLE |
| Time to read one 4K page into the buffer. |
| PAGESIZE | INTEGER |
| Size (in bytes) of pages in the table space. |
| NGNAME | VARCHAR(18) |
| Name of the nodegroup for the table space. |
| BUFFERPOOLID | INTEGER |
| ID of buffer pool used by this tablespace (1 indicates default buffer pool). |
| REMARKS | VARCHAR(254) | Yes | User-provided comment. |