Chat now with support
Chat with Support

Spotlight on DB2 6.10 - User Guide

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release Getting started with Spotlight on IBM DB2 LUW Desktop features specific to Spotlight on IBM DB2 LUW Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns Buffer Pool Analysis drilldown Client Application Analysis drilldown Database Analysis drilldown Database Manager Summary drilldown Diagnostic Log drilldown FCM Analysis drilldown Tablespace Analysis drilldown Top SQL drilldown Operating System drilldown Workload Management Analysis drilldown
Spotlight on IBM DB2 LUW alarms Spotlight on IBM DB2 LUW Options Tuning SQL statements in Spotlight on IBM DB2 LUW
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

SMS component

The SMS component provides statistics about SMS (system-managed space) tablespaces to which the database is mapped.

Required monitor switch


Displayed statistics

At each refresh, Spotlight captures the following statistics and displays them in the SMS component:

  • Total Size—The total amount of space in an SMS tablespace. This value is shown in MB.

  • Utilization—The percentage of space in an SMS tablespace that is already used. This statistic has a predefined range of alarms. For more information see, DMS Utilization alarm.


The fill graph depicts the percentage of SMS tablespace that currently contains table data in the database.

Associated drilldown

Click the SMS component to open the Tablespaces drilldown. This drilldown provides details about the tablespaces in which the database you are currently monitoring resides. You can select a specific tablespace to view its storage and activity statistics.


Related topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating