State on Disk: Tablespaces (DB2 UDB)
To display the state on disk information for the tablespaces, choose Tools ® Administration ® Monitoring ® Performance ® Database ® Tables/Indexes (or call Transaction DB02) and choose Detailed analysis in the Tablespaces group box.
This function gives you more information about the tablespaces that have been created. You can get an up-to-date analysis at any time by selecting DB Analysis ® Refresh. This only has a minimal effect on your system performance and takes less than a minute.
Field |
Description |
Tablespace |
Name of the tablespace |
Type |
D atabase Managed Space or System Managed Space. At present, SMS can only be used for PSAPTEMP. |
Used Size |
Space occupied |
Free Size |
Free space |
%-Used |
Percentage share of the occupied space compared to the total size of the tablespace. |
Container |
Number of containers belonging to the tablespace. |
Status |
Status of the tablespace when the analysis takes place. |
The final line of the table contains the total values.
The total size of a tablespace is calculated by adding together the values for Used Size and Free Size.
For a more detailed analysis of a tablespace, position the cursor on the tablespace you are interested in and choose Analysis. The following options are available:
Lists all containers belonging to the selected tablespace. The information displayed includes the size and name of the tablespace.
You can update this information online at any time by selecting Refresh. This only has a minimal effect on your system performance and takes less than a minute.
Lists all tables or indexes belonging to a tablespace.
Shows detailed information about the selected tablespace. This information includes:
You can get an up-to-date analysis at any time by selecting DB Analysis ® Refresh. This only has a minimal effect on your system performance and takes less than a minute.
Shows how the size of the selected tablespace has changed. For more information, see