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


Spotlight uses metrics, thresholds, and severities to determine the performance statistics of a system. Icons, flows, and labels graphically display this information in the main application window.


A metric is a measurable value resulting from a request made against the target machine. This query runs each time the main application window is refreshed.

The query provides a performance statistic about the system (for example, the number of machines that have at least one server session), and returns a value to Spotlight.


Each metric is divided into thresholds. Some metrics may have only one threshold, while others can have many. A threshold is simply a range of values that can be returned by the metric. A threshold cannot belong to more than one metric.


Each threshold is associated with a severity. The severity determines what action Spotlight is to take when the value returned by a metric falls into the range controlled by a threshold. For example, you may set a severity to display a color, flash the color, emit a sound, or perform an action.

Alarms are attached to severities.

How They Work Together

The following diagram shows an example of the relationship between metrics, thresholds, and severities.

In the previous example, the query (% of users connected) is run against the database, and any values returned can fall into one of three ranges (called thresholds). If the query returned the value 20%, the value would fall into the range covered by Threshold 1.

In this example, Threshold 1 is attached to Severity 2. You can set the colors of the severity via the Spotlight Console Options window (for example, Severity 2 might be set to display in green). The component that the metric belongs to then changes to green whenever that threshold is exceeded.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating