지금 지원 담당자와 채팅
지원 담당자와 채팅

Spotlight on DB2 6.9.3 - Release Notes

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 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:

Procedures

Tuning an SQL statement

 

 

Related topics

관련 문서
Spotlight on DB2 - 6.9.3
Getting Started Guide
Release Notes
User Guide
Showing 1 to 3 of 3 rows

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택