Chat now with support
Chat with Support

Spotlight on DB2 6.10 - Release Notes

Static SQL Statement Attempt Rate

The Static/s dataflow depicts the rate at which applications are attempting to execute static SQL statements within the database or partition.

Required monitor switch

None

Displayed statistic

At each refresh, Spotlight captures the number of static SQL statements that applications are attempting to execute per second within the database or partition.

Graph

The line graph that appears over the dataflow charts the static SQL statement attempt rate over the series of refreshes that occur during the Spotlight session.

Associated drilldown

Click the Static/s dataflow to open the Top SQL drilldown. This drilldown provides details about the SQL statements currently running (or recently run) on the database or partition and helps you pinpoint problem SQL.

 

Related topics

Top SQL drilldown

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating