Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - 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

DMS component

The DMS component provides statistics about DMS (database-managed space) tablespaces to which the database or partition is mapped.

Required monitor switch

None

Displayed statistics

At each refresh, Spotlight captures the following statistics and displays them in the DMS component, which has got two parts:

Total:

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

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

Fullest:

  • Total Size—The total amount of the fullest tablespace in a DMS tablespace. This value is shown in MB.

  • Utilization—The percentage of the fullest tablespace in a DMS tablespace that is already used.

Note: In an auto-resizing DMS tablespace values in the fullest tablespace do not raise alarm except for its total size.

Graph

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

Associated drilldown

Click the DMS 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