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

Global SQL Request/Response panel

The Global SQL Request/Response panel on the instance home page provides an overview of all the SQL activity across all active databases within the instance. These spinners are providing counts for this activity, but not rates. For rates that correspond to these counts, access the appropriate home page for the particular database or partition, or open the Top SQL drilldown.

The following illustration is an example of the Global SQL Request/Response panel.

You can use the Metric Editor to modify the thresholds for the metric behind the statistic in each of these components to generate appropriate alarms. Review the following for additional information:

Static SQL

The number of static SQL statements executed across all active databases in the instance.

Note: In multiple-partition environments, the Database Manager Summary drilldown provides this statistic for each active partition on the system. Additionally, the All Nodes row shows a running total for this statistic across all partitions.

Dynamic SQL

The number of dynamic SQL statements executed across all active databases in the instance.

Note: In multiple-partition environments, the Database Manager Summary drilldown provides this statistic for each partition on the system. Additionally, the All Nodes row shows a running total for this statistic across all partitions.

Transactions

Transactions The number of commits and rollbacks completed per second within the instance. This number includes both internal transactions that the database manager executes and transactions completed at the application level.

Note: In a multiple-partition database, information is presented for each active partition on the system. An All Nodes row keeps a running total for all partitions. In a single-partition database, only the All Nodes information is presented.

 

Related topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating