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 on IBM DB2 LUW menus

You can use menus to access the functions of Spotlight on IBM® DB2® LUW (Linux, UNIX, and Windows). There are two different types of menus:

  • Standard menus displayed via the menu bar on the Spotlight console.

The standard menus available in Spotlight on IBM® DB2® LUW are also those that are common to all Spotlight applications. For more information, see the Spotlight menus topic in Spotlight basics help.

  • Shortcut menus displayed when you right-click an object in a Spotlight home page or in a drilldown.

Most shortcut menus in Spotlight on IBM® DB2® LUW, and most of the options within those menus, are also those that are common to all Spotlight applications.

Selecting commands from a menu

You can select a command from a menu by typing the letter that is underlined in the command name. For example, to connect to a system, press the letter O when the File menu is displayed. If the menu is not visible you can type the File menu access key ( ALT+F ) and then press O.

Some commands also have a shortcut key. If you use shortcut keys, you do not have to display the menu first.

Spotlight on IBM DB2 LUW toolbar

The Spotlight on IBM® DB2® LUW (Linux, Unix, and Windows) toolbar is located at the top of the main application window. The toolbar provides you with quick access to commonly-used commands and functions. Click once on a toolbar button to carry out the command. To see a description of what each button does, rest your mouse pointer over the button. Information about the button appears. If a button appears dimmed, it is unavailable.

The buttons on the Spotlight toolbar are of two kinds:

  • Buttons common to all Spotlight applications.

The buttons that are common to all Spotlight applications are covered in the Spotlight toolbar topic in the Spotlight basics help.

  • Buttons that are specific to Spotlight on IBM® DB2® LUW.

The toolbar buttons that are specific to Spotlight on IBM® DB2® LUW are those used to access drilldowns.

The graphic below shows the drilldown toolbar buttons for Spotlight on IBM® DB2® LUW. For a description of each drilldown, click an icon on the graphic.

Spotlight on IBM DB2 LUW drilldowns

Welcome to Spotlight on IBM DB2 LUW (Linux, Unix, and Windows). The help topics in this book cover features available in the interface when Spotlight is connected to a version 9 database.

Spotlight is a powerful database monitoring and diagnostic tool. Its unique user interface provides you with an intuitive, visual representation of the activity on the DB2 databases and database partitions that you choose to monitor. Graphical flows and line and fill graphs illustrate the activity on and between database components. Icons display the value of key statistics. Using the Spotlight browser, you can switch your monitoring focus between the various databases and partitions. Additionally, you can view activity at the DB2 instance level for any of these systems.  

The power of Spotlight lies in its ability to provide visual and audible warnings if the performance metrics exceed acceptable thresholds. The components and dataflows on the home page change color to show you the source of the problem.

A range of reports and graphs provide you with detailed information about a DB2 database, database partition, or the instance to which the database belongs. This information can be viewed on the screen or be printed.

You can set Spotlight options to warn you when a threshold is reached. You can define a number of thresholds so that warning messages are displayed well before the traffic levels into or out of databases become critical.

Spotlight uses a number of different techniques to warn you when your DB2 instance or a database is exceeding a threshold. For example, to issue a warning, you can configure Spotlight to change a color on the home page or drilldown, provide an audible signal, or perform an action, such as send an email message.


Related topics

About Spotlight on IBM DB2 LUW drilldowns

Drilldowns display detailed information about the system that you are monitoring. Each drilldown contains a series of reports and graphs that provide you with specific information about the components of your system. The statistics that are available help you identify and anticipate performance problems.

Note: The drilldowns listed below are specific to Spotlight on IBM® DB2® LUW. Other Spotlight applications have their own individual drilldowns.


For information on drilldowns in general, see the topic Components and Drilldowns in the Spotlight basics help. For information on accessing drilldowns, see the topic To view drilldowns. (To open the Spotlight basics help, select Help|Contents.) 

For further information, see the following drilldowns:

  • DB2 Instance—Opens the instance home page, which shows real-time performance information for the instance that contains the database or database partition currently selected in the Spotlight browser.

  • Database Manager Summary—Shows global summary information about all active databases and partitions in the DB2 instance.

  • Client Application Analysis—Shows statistics about the applications currently running at the DB2 instance or database level.

  • Database Analysis—Shows statistics about the databases in the DB2 instance.

  • Tablespace Analysis—Shows statistics about the tablespaces to which a database is mapped.

  • Top SQL—Shows statistics about the SQL statements currently executing or recently executed on the DB2 instance.

  • Buffer Pool Analysis—Shows statistics about buffer pools configured for a database.

  • FCM Analysis—Shows a breakdown of message buffer traffic for the instance you are monitoring.

  • Workload Management Analysis—Reports information about the Workload Management (WLM) environment for your database.

  • Diagnostic Log—Lists diagnostic log, notification, and event records for a database.

  • Operating System—Shows statistics about the performance, processes, and storage on the server.


Related topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating