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


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.


About Troubleshooting

This section identifies general problems that you may encounter when using Spotlight applications, and details how to address those problems. For problems caused in specific Spotlight applications, see the help for that application.


Product Authorization Errors

When first installed, Spotlight can be used with full functionality for a specified trial period. When the trial period expires, contact your Questrepresentative to obtain an authorization key to continue.


  • Make sure that you enter the authorization key exactly as stated on your Product Authorization sheet or as provided by your Questdistributor. If you enter the authorization key incorrectly, the following message is displayed:

    Invalid authorization key

  • Once the trial period has expired, if an authorization key is not supplied, only the Spotlight home page will be visible. If you click any of the drilldown buttons, the following message is displayed:

    You do not have a license for “Spotlight...” that enables access to this functionality. Please contact Questfor information about obtaining the correct license.

  • If the trial date has not passed, check that the date on your system is set correctly.

How to enter an authorization key

  1. Click Help | About Spotlight.
  2. Click Installed products. The Installed Products page lists all the Spotlight products that are currently installed on your system.
  3. Locate your Spotlight product in the list of installed products.
  4. Click the associated View/change product license link.
  5. Click Change this license.
  6. Enter the new Authorization key and Site message.

Tip: Individual Spotlight applications may handle invalid license numbers in different ways (for example, if the license has expired on a trial copy of the software). For more information, refer to the corresponding help in that application.

I Cannot Open a Migrated Connection


Spotlight is unable to open a migrated connection.


When you open a Spotlight connection, you use connection details that are stored in files somewhere on your local computer or (in the case of migrated connections) somewhere on your network.

When Spotlight cannot access those connection details (for example, when the relevant network machine is unavailable), it displays a Spotlight message box that you can use to change the location where connection details are stored. The choices you have are:

Option Description


Click to open the Spotlight Migration wizard to change the location where connection details are stored.


Click to abandon the attempt to open the desired Spotlight connection.


Sometimes the network location that you have been using is only temporarily unavailable. Click to reuse the existing connection details to open a Spotlight connection.

Note: You should not migrate connections to locations that may be offline frequently or for extended periods. You cannot migrate connections that are currently in use or inaccessible.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating