Entering content frame

Background documentation Space: History - Database and Tablespaces (DB2 UDB for UNIX and Windows) Locate the document in its SAP Library structure

Note

The following function is only available for RFC-monitored systems.

You can access history data on the database and tablespaces by calling the DBA Cockpit and choosing Space ®History ® Database and Tablespaces in the navigation frame of the DBA Cockpit. The History – Database and Tablespaces screen appears. By default, the database history is displayed.

To switch to the tablespace history, select Tablespaces in the Object Selection field.

The following information is displayed:

Space

Column

Description

Partition

Monitored partition - displayed only if you are using a multi-partition database

Tablespace Name

Name of the tablespace (only displayed if you have selected Tablespaces in the Object Selection field)

KB Total

Amount of space in KB allocated

Changes (KB Total)

Average change of KB Total. The average value depends on your selection in the Statistics field.

KB Used

Used space in KB of the allocated space

Changes (KB Used)

Average change of used space

% Used

Percentage used of allocated space

KB Free

Free space in KB of allocated space

Containers

Number of containers belonging to the tablespace

Changes Containers

Average change of number of containers

Tables and Indexes

Column

Description

Tablespace Name

Name of the tablespace (only displayed if you have selected Tablespaces in the Object Selection field)

Tables

Number of tables

Changes Tables

Average change of number of tables

Table (KB)

Space used by tables

Changes Table (KB)

Average change of space used by tables

Indexes

Number of indexes

Changes Indexes

Average change of number of indexes

Index (KB)

Space used by indexes

Changes Index (KB)

Average change of space used by indexes

If you want to display delta values between available measurements, select a row and choose This graphic is explained in the accompanying text Details. Alternatively, you can double-click the selected row. The table will be displayed again with the following difference: Columns with the heading Changes... are renamed with Delta...

 

Leaving content frame