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

Detail for the selected SQL statement

When you click a specific entry in the SQL statement list on the SQL tab in the Top SQL drilldown, a detail pane appears in the lower half of the tab area. This detail identifies the selected SQL statement, lists the full statement text, and provides operational and performance statistics for the statement.

Note: The SQL Statement Archiver captures a sampling of the SQL statements executed. The expected consequence of this sampling process is that the Archiver might not capture every execution. Therefore, statistics for this statement might actually be minimum values. For example, the value for Executions shows the number of executions that the Archiver has observed for the selected statement. The actual number of executions might be higher, but not lower, since the Archiver might not have captured all executions of the statement.

SQL statement text

The text box at the top of the detail pane shows the actual text of the SQL statement. Key words appear in blue; literal values appear in red. You can also select and copy this SQL statement text.

Identification details

The following details identify the SQL statement:

Database Name

Section Number

Schema Name

Statement Type

Package Name


Summary information

The following statistics provide an execution summary for the SQL statement:


Max Nbr Agents

Cost Estimate

Degree Parallelism

Card Estimate



The following are execution statistics collected for the SQL statement:

Rows Fetched

Internal Row Inserts

Rows Read


Rows Written

Sort Overflows

Internal Row Deletes

Sort Time (1/1000 sec)

Internal Row Updates

CPU Time (1/1000 sec)


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating