Chatta subito con l'assistenza
Chat con il supporto

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

Threshold Queues tab

The Threshold Queues tab on Workload Management Analysis drilldown shows real-time information about the each threshold queue that the Workload Manager is currently managing in your current database. These queues are means of controlling workload resources. Rather than stopping activities or connections when too much work is executing in the workload, Workload Manager can assign these entities to a queue where they await their turn to run. Queues are established when the workload reaches certain user-defined thresholds that trigger queue creation.

Threshold Queue Summary Details

The tab lists the threshold queues currently defined in your Workload Manager environment on the database. Expand a queue node to view the following summary statistics collected for the queue at each database partition:

Name

Action Set

Queue Time Latest ( msec )

ID

Work Class

Queue Exit Time Latest

Partition

Workload

Threshold Curr . Concurrency

Predicate

Queue Size HWM

Threshold Max. Concurrency

Domain

Queue Time Total ( msec )

Last Reset

Superclass

Queue Assign. Total

 

Subclass

Queue Size Current

 

Information About Specific Threshold Queues

To access in-depth information about a specific threshold, click its entry and view the following sub-graph:

Queue Size -- The number of activities or connections still existing in the selected queue at the time specified on the graph.

Queue Time -- At the time specified on the graph, the amount of time that the last activity to be removed from the queue resided in that queue.

 

Related Topics

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

List of pre-defined alarms

Spotlight on IBM® DB2® LUW (Linux, Unix, and Windows) comes with some predefined alarms for the database or database partition home page and for the associated instance home page. For a list of these of alarms, click on the appropriate home page type.

Database or database partition home page alarms

Instance home page alarms

Database or database node 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

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione