SQL Reference

SYSCAT.TABLESPACES

Contains a row for each table space.

Table 92. SYSCAT.TABLESPACES Catalog View

Column Name Data Type Nullable Description
TBSPACE VARCHAR(18)
Name of table space.
DEFINER VARCHAR(128)
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 = System temporary tables only
U = Declared temporary tables only

EXTENTSIZE INTEGER
Size of 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 prefetch is performed.
OVERHEAD DOUBLE
Controller overhead and disk seek and latency time in milliseconds.
TRANSFERRATE DOUBLE
Time to read one page of size PAGESIZE 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).
DROP_RECOVERY CHAR(1)

N = table is not recoverable after a DROP TABLE statement
Y = table is recoverable after a DROP TABLE statement

REMARKS VARCHAR(254) Yes User-provided comment.

Column Name	Data Type	Nullable	Description
TBSPACE	VARCHAR(18)		Name of table space.
DEFINER	VARCHAR(128)		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 = System temporary tables only U = Declared temporary tables only
EXTENTSIZE	INTEGER		Size of 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 prefetch is performed.
OVERHEAD	DOUBLE		Controller overhead and disk seek and latency time in milliseconds.
TRANSFERRATE	DOUBLE		Time to read one page of size PAGESIZE 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).
DROP_RECOVERY	CHAR(1)		N = table is not recoverable after a DROP TABLE statement Y = table is recoverable after a DROP TABLE statement
REMARKS	VARCHAR(254)	Yes	User-provided comment.

[ Top of Page | Previous Page | Next Page ]