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

Operating System drilldown

The Operating System drilldown provides information about the performance, processes, and storage on the server.

When you click the OS drilldown icon on the toolbar, the Operating System home page for the system where your database is running opens. For help with the OS drilldowns for Windows, Linux, or Unix, press F1 on the appropriate OS home page.

For specific information about monitoring a Unix or Linux Operating System, refer to help for Spotlight on Unix, and for monitoring a Windows Operating System, refer to help for Spotlight on Windows, or Spotlight on Windows Clusters. To open this help, select Help|Contents.


Workload Management Analysis drilldown

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

Workload Management Analysis drilldown

Note: This drilldown is available for DB2 9.5 and later databases only.

The Workload Management Analysis drilldown reports the information gathered by the WLM_GET table functions about the Workload Management (WLM) environment for the currently selected database.

Opening the Workload Management Analysis drilldown

To open the Workload Management Analysis drilldown

On the home page for the selected DB2 database or on the home page for the DB2 instance, click in the toolbar.

Using the Work Management Analysis drilldown

From the following tabs on the drilldown, view both summary information and drill-down details about how workloads are being managed and how they are performing in the database:

Service Classes


Work Classes

Work Actions


Threshold Queues


Service Classes tab

The Service Classes tab on Workload Management Analysis drilldown shows real-time summary and drill-down information about each service class defined on the current database.

A DB2 service class is a database object, assigned to one or more workloads, which defines the execution environment in which the activities in a workload run. That is, the service class is the primary point from which resources for database requests are assigned, work flow is managed, and activities are monitored in a workload.

A workload is assigned to one service class in the workload definition. However, a service class can be assigned to multiple workloads.

Service Class Summary Details

The tab lists the service classes currently defined on the database. These include both user-defined and system default service classes. Each top-level node in the list is the service superclass , which serves as the top tier for managing work environments. Expand a service superclass node to view its subclasses. The different service subclasses provide granularity in mapping resources and applying controls. A subclass is the actual environment where workload activities run.

The following summary statistics are shown for each subclass at database-partition level:


Con. Act. HWM

Coord Act. Queue Time Std . Dev .


Coord Act. LT HWM

Active Requests


Coord Act. LT Avg

Total Requests

Connection HWM

Coord Act. LT Std . Dev .

Req . Time Avg.

Coord Act. Compl .

Coord Act. Exec Time Avg.

Req . Time Std . Dev .

Coord Act. Aborted

Coord Act. Exec Time Std . Dev .

Req . Time Total

Coord Act. Rejected

Coord Act. Queue Time Avg.

Last Reset

Information About Specific Service Classes

To access in-depth information about what is happening across all workloads in your database at the service class level, click a service class entry and view any of the following sub-drilldowns. (Click a superclass to view information across all its subclasses; click a subclass to view information specific to the subclass.)

Workload Occurrences
Shows details about occurrences (that is, database connections assigned to a workloads) currently running across all workloads assigned to the service class. For each occurrence, view the attributes used to assign the connection to its workload, the current status of the occurrence, and the volume and success and failure rates of its activities.

Provides details about the agents handling activities associated with occurrences across all workloads in the service class.

Threshold Queues
Lists statistics for queued activities in all workloads in the service class. These statistics include queue times and sizes.

Class Activity
Graphically depicts activity totals for all workloads in the service class.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating