Chat now with support
Chat with Support

Spotlight on DB2 6.10 - Getting Started Guide

Dynamic SQL statement attempt rate

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

Required monitor switch


Displayed statistic

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


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 Dyn /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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating