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 supportadmin@quest.com 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

Instance home page alarms

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

Instance home page alarms

The following is a list of predefined alarms for the instance home page. To the right of each alarm name is the home page component and metric for which the alarm thresholds are defined. If necessary, you can use the Metric Editor to adjust the thresholds that correspond to these alarms to reflect your DB2 instance environment.

Alarm

Home Page panel

Component

Post Threshold Sorts alarm

Global Sort/Join

Post Threshold Sorts

Post Threshold Hash Joins alarm

Global Sort/Join

Post Threshold Hash Joins

Piped Sort Rejects alarm

Global Sort/Join

Piped Sort Rejects

Sort Overflows alarm

Global Sort/Join

Sort Overflows

Hash Loops alarm

Global Sort/Join

Hash Loops

Hash Join Small Overflows

Global Sort/Join

Hash Join Overflows

Hash Join Small Overflows alarm

Global Sort/Join

Hash Join Small Overflows

Agent Request Overflows alarm

Global Application/Agent

Agent Request Overflows

Agents Pending Locks alarm

Global Application/Agent

Agents Pending Locks

Agents Pending Token alarm

Global Application/Agent

Agents Pending Token

Missed Beats alarm

HADR

Missed Beats

Agents Pending Locks alarm

The Agents Pending Locks alarm becomes active when the number of agents waiting on a lock in comparison to the total number of registered agents for the DB2 instance reaches a threshold percentage. Lock waits occur for a number of reasons, including internal database contention.

This alarm has been predefined with a Low severity level. The underlying metric for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

The application agents could be experiencing concurrency problems. Try to identify the applications that are holding locks for long periods of time and determine the cause. One possible solution is to use small units of work (for example frequent COMMITs) to reduce concurrency issues.

Access the Client Application Analysis drilldown to identify the applications holding locks and review statistics about those locks.

Notes:

  • When you change the locking configuration parameters in one partition for a database, be sure that the changes are also made to all of the other partitions for the database.

 

Related topics

Agents Pending Token alarm

The Agents Pending Token alarm becomes active when the number of agents waiting for a token (a permission to run) in comparison to the total number of registered agents for the DB2 instance reaches a threshold percentage.

This alarm has been predefined with a Low severity level. The underlying metric for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

Determine whether the current value for the MAXAGENTS database configuration parameter is appropriate for your system. Some environments might use the MAXAGENTS parameter value to limit the number of processing tokens, thereby limiting the amount of execution concurrency in the database manager. Although this strategy might be beneficial to the system as a whole, it can impact applications, causing problems such a high percentage of agents awaiting tokens.

 

Related topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating