Space Statistics: Tablespaces (DB2 UDB)
To display the space statistics information for the tablespaces, choose Tools ® Administration ® Monitoring ® Performance ® Database ® Tables/Indexes (or call Transaction DB02) and choose Space statistics in the Tablespaces group box.
The screen History of tablespaces gives information about the growth of the tablespaces. By default, only those tablespaces are shown where changes have occurred. To display all the tablespaces, choose History ® Tablespaces on/off.
Field |
Description |
Scale |
Daily, weekly or monthly overview |
Tablespace |
Name of the tablespace |
Total Used Size |
Space currently occupied |
Chg/day |
Average change in size per day (measured since recording started) |
Total Free Size |
Space currently free |
Chg/day |
Average change in size per day (measured since recording started) |
Total %-Used |
Percentage of the total size occupied |
Chg |
Percentage by which the amount used has changed. |
Total Container |
Number of containers belonging to the tablespace |
Chg/day |
Average change in number per day (measured since recording started) |
Total Tables/Indexes |
Number of tables/indexes belonging to the tablespace. |
Chg/dy |
Average change in number per day (measured since recording started). |
To see more detailed information on a tablespace, select the tablespace you are interested in and choose Select. A table is displayed that shows the data collected for the tablespace arranged by day. To move through the list of tablespaces, select Next tablespace or Prev. tablespace.
These statistics are updated daily.