Unit of Work tab
The Unit of Work sub drilldown provides additional information for the SQL statement that is currently executing for the unit of work. This is the statement that was selected in the Current SQL tab of the Top SQL drilldown. The sub drilldown contains three panes:
-
Statement pane—This pane shows the SQL statement that is currently executing for the unit of work. If you want to tune the statement, you can open a tuning session in SQL Optimizer for DB2 by clicking the SQL Tuning icon.
-
UOW Details pane—This pane shows details for the SQL statement that is currently executing for the unit of work. The details include statement start and stop times, number of concurrent agents, and number of blocking cursors.
-
UOW Activity pane—This pane shows activity counts for the SQL statement that is currently executing for the unit of work. The counts provide a measure of how the current unit of work is impacting database resources.
From this sub drilldown, you can also open a tuning session on the statement.
Tasks specific to the Top SQL 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.
Printing the Top SQL drilldown
You can print the list of SQL statements on the SQL tab in the Top SQL drilldown; or you can print details for a specific statement on that tab.
To print the SQL statement list
-
If the Detail pane for a specific SQL statement is displayed on the drilldown, click
in the upper right corner of the tab. The Detail pane is hidden.
-
Select File4Print.
-
On the Print dialog, click OK.
To print the details for a specific statement
-
If the Detail pane that you want to print for a specific SQL statement is not displayed, select that statement from the list. The Detail pane is displayed.
-
Select File4Print.
-
On the Print dialog, click OK.
Operating System 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.