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.
These details identify the selected application whose current unit of work you are investigating:
This area shows the SQL statement that is currently executing for the unit of work.
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:
|
|
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:
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.
This section lists the authorities granted explicitly to the application. The list can include any of these authorities:
|
SysAdm |
Connect |
SysMaint |
|
DbAdm |
Create Not Fenced |
Implicit Schema |
|
CreateTab |
SysCtrl |
Load |
|
BindAdd |
|
|
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:
|
SysAdm |
Connect |
SysMaint |
|
DbAdm |
Create Not Fenced |
Implicit Schema |
|
CreateTab |
SysCtrl |
Load |
|
BindAdd |
|
|
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.
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).
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
