Chat now with support
Chat with Support

We are currently experiencing issues on our phone support and are working diligently to restore services. For support, please sign in and create a case or email for assistance

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

Select Multiple Rows

On grids with the Select All and Clear All buttons you can select multiple rows in the grid.

Click To do this...
Select all rows
Clear all rows
CTRL + click Select several individual rows (or clear rows already selected)
SHIFT + click Select a range of rows


Related Topics

Grid Properties - Options Page

To freeze the first column

When selected the first column will remain visible while you scroll through the columns of the table:

Right-click the grid header and select Freeze First column.

To word-wrap text

By default, Spotlight truncates text that is too long to fit in the space allocated to the column. To allow text to wrap onto multiple lines:

  1. Right-click the data content of the grid and select Properties | Options.
  2. Select Allow text to word-wrap onto multiple lines if it is wider than the column


Related Topics

Home Page Components

Spotlight Basics describes how Spotlight applications work. It contains these sections:



Spotlight Connections

Create / Modify / Delete connections to systems, and monitor those systems.

Monitor Spotlight Connections Monitor connections, detect alarms, investigate the cause of alarms.

Alarms are the warnings that Spotlight raises when a metric falls outside its "normal" range of values.

Charts, Grids and Home Page Components Spotlight displays provide detailed statistics of the monitored system, relevant to diagnosing the cause of alarms. Make the best use of them.
View | Options Customize Spotlight.
Troubleshooting Solve problems using Spotlight.


Spotlight Home Page Components

The components in the Spotlight home page are visual objects that correspond to important features of the system Spotlight is monitoring. Components can be of many different types, including buttons, gauges, data flows, queues, spinners, and containers.

Note: They change color to alert you to performance bottlenecks. Spotlight Alarms



Component Description

Button - Sometimes called a process icon. A Spotlight component that contains a single value that represents the state or existence of a process.

Data flow - Panels in the Spotlight home page may be connected to other panels by data flows that show the rate at which data is moving through a system. As the rate increases, so does the speed of the flow.

Gage - A Spotlight component that shows a measurement as a continuous range of possible values.

Queue - Spotlight component that shows a measurement as a range of discrete values. The globe at the end of the queue is an alarm indicator.

Container - A cylindrical component that fills up as the value it measures increases. Normally used to indicate file size or disk usage.

Spinner - Spotlight component that shows a measurement as a rotating wheel. The higher the value, the faster the speed of rotation.


Action Description
Hover the mouse over the component

Opens information on the status of the component.

Click on the component.

Shows What's this help or performs other customized action. Balloon help
Right click on the component | What's this

Opens information about the component in balloon help.

If an alarm is raised on the component, then opens help for resolving the alarm. Spotlight Alarms

Right click on the component | Show History

View the recent history of the component.


  • Change the size of the popup chart by clicking and dragging a corner of the popup.
  • Maximize and restore the size of the chart via the Maximize chart buttons at the top right of the popup chart.
  • Zoom in on a section of the chart by clicking in the chart, and zoom out by clicking the Unzoom chart button at the top right of the popup chart.
  • Right click and drag over the chart and time axis to zoom in on a time frame.
  • Right click the chart to copy to clipboard.
  • You can customize how history data is stored. see Spotlight History for more information.
  • You can customize the behavior and display of the history charts. Chart configuration
Right click on the component | Show Details View a drilldown page for the component. Spotlight drilldown pages contain a detailed breakdown of the statistics used to diagnose the component.
Right click on the component | Snooze alarm

Ignore (Snooze) Alarms Components with snoozed alarms are represented by .

Right click on the component | Copy to Clipboard Copy To Clipboard
Right click on the component | Restore Default Settings You can change the appearance and behavior of Spotlight components. Restore Default Settings
Right click on the component | Metrics

Metrics Dialog

Thresholds Dialog

Right click on the component | Properties

Home Page Properties - Options Page

Component Properties - Overhead Page

Click . This icon indicates the diagnostic server is unable to collect the data required for the affected component. Click the icon for more information.
Data for this control is not available. (There are no alarms associated with this control.) Component Properties - Overhead Page
Data for this control is not available. (Alarms associated with the control are disabled.) Component Properties - Overhead Page


Related Topics

Calibrate Spotlight Connections

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating