IBM Books

Administration Guide


SYSCAT.TABLESPACES

Contains a row for each table space.

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


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]