Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - Getting Started Guide

Client Application Analysis drilldown Unit of Work tab

The Unit of Work tab on the Client Application Analysis drilldown provides details and statistics about the currently executing unit of work. When the execution time for an application’s current unit of work is high ( Curr Uow Sec column in the list grid), use this tab to investigate this unit of work.

Optionally from this tab, you can start a tuning session on the SQL statement you are investigating.

Application information

These details identify the selected application whose current unit of work you are investigating:

Auth ID

App Name

Agent ID

Statement

This area shows the SQL statement that is currently executing for the unit of work.

Statement Details

These details describe the SQL statement that is currently executing for the unit of work, provide a breakdown of the SQL statement’s execution time, and show the most recently completed unit of work for the application:

Statement Type

Cursor Name

Execution Time, CPU User

Statement Operation

Agents/Max Agents

Execution Time, CPU Sys

Statement Section Number

Degree of Parallelism

Execution Time, Sort

Statement Package Name

Estimated Cost (timerons)

Previous UOW, Elapsed time, Stmt

Application Creator

Estimated Rows

 

Statement Activity

These statistics provide activity counts for the SQL statement that is currently executing for the unit of work and describe how the current unit of work is impacting database resources:

Sorts, Statement

Rows Deleted Internally

Sort Overflows

Rows Updated Internally

Rows Read

Rows Inserted Internally

Rows Written

Rows Fetched

Procedures

Tuning an SQL statement

 

 

Related topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating