Space: Tablespaces (DB2 UDB for UNIX and Windows) (SAP Library - CCMS: SAP/DB2 UDB for UNIX and Windows)

Space: Tablespaces (DB2 UDB for UNIX and Windows)

You can access information on space for tablespaces by calling the DBA Cockpit and choosing Space ® Tablespaces in the navigation frame of the DBA Cockpit. The Tablespace Configuration screen appears.

The following information is displayed:

Column	Description
Tablespace Name	Name of the tablespace
TS Type	Type of tablespace, for example, DMS or SMS
KB Total	Total space used by tablespace in KB
Percent Used	Used space in relation to the available space
KB Free	Total amount of free space
Page Size	Size of a page in bytes
High-Water Mark	Indicates the highest (maximum) value of used pages reached
No. Containers	Number of containers
Contents	Contents of tablespace, for example, any data, temporary data
TS State	State of tablespace, for example, normal load pending

To display more information on the tables or indexes of a tablespace, select one or more tablespaces and choose This graphic is explained in the accompanying text Contents. The Space: Tablespace Content screen appears displaying the following information:

Column	Description
Tablespace Name	Name of tablespace
Schema	Name of the schema
Name	Name of table or index
Type	Type of object, for example, index, primary index or table

In addition, you can maintain tablespaces, that is This graphic is explained in the accompanying text Change, Add or Delete them. For more information, see Maintaining Tablespaces.