Space:
History - Overview (DB2 UDB for UNIX and Windows) 
The following function is only available for RFC-monitored systems.
You can access the History - Overview screen by calling the DBA Cockpit and choosing Space ®History ®Overview in the navigation frame of the DBA Cockpit. The History – Overview screen appears.
The following information is displayed:
Database and Tablespaces
|
Field |
Description |
|
Tablespaces |
|
|
Last Analysis |
Date and time of the last analysis |
|
Total Number |
Total number of tablespaces in the database |
|
Total Size |
Total size of all tablespaces in KB |
|
Free Space |
Free space in all tablespaces in KB |
|
Used Space |
Used space of all tablespaces as a percentage |
|
Minimum Free Space |
Free space of the tablespace with the lowest amount of free space in KB |
|
Maximum Used |
Used space of the tablespace with the highest fill level as a percentage |
|
Database Partitions |
|
|
Total Number |
Number of database partitions. The value displayed is only higher than 1 if you are using a multi-partition database. |
Tables and Indexes
|
Field |
Description |
|
Last Analysis |
Date and time of the last analysis |
|
Total Number of Tables |
Total number of tables defined in the database |
|
Total Size of Tables |
Total amount of used space of all tables defined in the database |
|
Total Number of Indexes |
Total number of indexes defined in the database |
|
Total Size of Indexes |
Total amount of used space of all indexes defined in the database |
|
Oldest REORG Check |
Date and time of the oldest execution of RUNSTATS using program dmdb6srp |
|
Latest REORG Check |
Date and time of the latest execution of RUNSTATS using program dmdb6srp |
The job to collect the database and tablespace history and the job to collect tables and indexes history are triggered by the DB collector. You can display the schedule of these two jobs in the DBA Planning Calendar by choosing Jobs ® DBA Planning Calendar in the DBA Cockpit. In the Category group box you can choose All Actions or DB Collectors. The default setting is DBA Actions.
Calculating table values with outdated statistics can result in inaccurate values. To calculate update statistics including calculation of table sizes, use the DBA Planning Calendar.