Chat now with support
Chat with Support

Spotlight on DB2 6.10 - 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

Switches panel

The Switches panel on the instance home page shows the current on/off status for the monitor switches that the DB2 snapshot monitor is using to capture data for the currently highlighted connection (within which you opened the instance home page).

Caution: There are known issues with monitor switches on IBM DB2 for LUW (Linux, Unix, and Windows) version 7 instances that do not have FixPak 8 or later applied. In some cases, setting monitor switches can cause the instance to crash. If you are not running DB2 for LUW version 7 with FixPak 8 or later applied, contact IBM technical support.

The following illustration is an example of the Switches panel.

The switches return the following types of data:

  • Buffer Pool—Number of reads and writes, and the time taken for these reads and writes

  • Lock—Lock waits, timeouts, and deadlocks

  • Sort—Number of sort heaps used, as well as sort performance statistics

Note: The Buffer pool, Lock, and Sort switches are preselected and cannot be changed. The home pages require data supplied by these switches.

  • Statement—SQL statement start and stop times, as well as statement identification information

  • Unit of Work (UOW)—Start and end times for transactions, as well as completion status information for each transaction

  • Table—Number of table rows read and written

  • Timestamp—Timestamps for instance activity


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating