Chat now with support
Chat with Support

Please note, you may experience access issues between 6am - 7am Eastern time on Saturday, May 28 2022 due to planned maintenance

Spotlight on SAP ASE 2.12 - Release Notes

Unit of Work sub drilldown for the Current SQL 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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating