Spotlight on DB2 6.9.3 - User Guide

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

Client Application Analysis drilldown

Authorities tab

Note: This feature is not available on IBM DB2 10.5 and later if Monitor Functions Method is used to retrieve data.

The Authorities tab on the Client Application Analysis drilldown provides details about the authorities granted to the application. The authorities can be granted explicitly or implicitly to the application.

Explicit Authorities information

This section lists the authorities granted explicitly to the application. The list can include any of these authorities:

Implicit Authorities information

This section lists the authorities granted implicitly (indirectly) to the application from a group or from PUBLIC. The list can include any of these authorities:

Related topics

Client Application Analysis drilldown

Memory Pools tab

The Memory Pools tab on the Client Application Analysis drilldown helps you keep track of system memory usage as it relates to the particular application you are monitoring. It is important to remember that, with the notable exception of buffer pools, most memory is allocated dynamically on an as needed basis by the Database Manager.

The memory pools list provides the following information about each memory pool in a grid format. Since you can choose to hide or display any column in the grid, some columns below might not display in your current list view.

Related topics

Client Application Analysis drilldown

Memory Pool types

Statistics tab

The Statistics tab on the Client Application Analysis drilldown lists performance statistics for database events associated with the selected application. Each row in the list identifies a specific event and provides countsfor the event based on these time measurements:

• Interval—Displays the number of occurrences of the event for the most recent monitoring interval.

• Rate—Displays the interval rate per second during the most recent monitoring interval.

• Lifetime—Displays the number of occurrences during the life of the event (since the database was activated or performance statistics were reset).

Related topics

Client Application Analysis drilldown

Application statistics