Chat now with support
Chat with Support

Spotlight on DB2 6.10 - User Guide

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release Getting started with Spotlight on IBM DB2 LUW Desktop features specific to Spotlight on IBM DB2 LUW Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns Buffer Pool Analysis drilldown Client Application Analysis drilldown Database Analysis drilldown Database Manager Summary drilldown Diagnostic Log drilldown FCM Analysis drilldown Tablespace Analysis drilldown Top SQL drilldown Operating System drilldown Workload Management Analysis drilldown
Spotlight on IBM DB2 LUW alarms Spotlight on IBM DB2 LUW Options Tuning SQL statements in Spotlight on IBM DB2 LUW
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

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

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:

SysAdm

Connect

SysMaint

DbAdm

Create Not Fenced

Implicit Schema

CreateTab

SysCtrl

Load

BindAdd

 

 

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:

SysAdm

Connect

SysMaint

DbAdm

Create Not Fenced

Implicit Schema

CreateTab

SysCtrl

Load

BindAdd

 

 

 

Related topics

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.

Pool

HWM Util Pct

Curr Size ( kb )

Max Size ( kb )

Curr Util Pct

Node

Size HWM ( kb )

Freeze First Column

 

Related topics

 

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating