Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - 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

Application statistics

The following table lists all of the statistics available on the Statistics tab of the Client Application Analysis drilldown. Clicking on an item displays a short definition of the statistic. For a more complete discussion, refer to your IBM documentation.

Agent Stolen

Direct Writes to Database

Rows Inserted

Block Cursor Requests Accepted

Hash Joins

Rows Read

Block Cursor Requests Rejected

Hash Join Loops

Rows Selected

Buffer Pool Data Logical Reads

Hash Join Overflows

Rows Updated

Buffer Pool Data Pages from Extended Storage

Hash Join Small Overflows

Rows Written

Buffer Pool Data Pages to Extended Storage

Internal Automatic Rebinds

Section Inserts

Buffer Pool Data Physical Reads

Internal Commits

Section Lookups

Buffer Pool Data Writes

Internal Rollbacks

Sort Overflows

Buffer Pool Index Logical Reads

Internal Rollbacks due to Deadlocks


Buffer Pool Index Pages from Extended Storage

Internal Rows Deleted

SQL Commit Statements Attempted

Buffer Pool Index Pages to Extended Storage

Internal Rows Inserted

SQL DDL Statements

Buffer Pool Index Physical Reads

Internal Rows Updated

SQL Dynamic Statements Attempted

Buffer Pool Index Writes

Lock Escalations, Exclusive

SQL Failed Statement Operations

Catalog Cache Heap Full

Lock Escalations

SQL Rollback Statements attempted

Catalog Cache Inserts

Lock Waits

SQL Select Statements Executed

Catalog Cache Lookups

Lock Deadlocks Detected

SQL Static Statements Executed

Catalog Cache Overflows

Lock Timeouts

SQL Update, Insert, Delete Statements Executed

Direct Read Requests

Package Cache Inserts

Unread Prefetch Pages

Direct Reads from Database

Package Cache Lookups


Direct Write Requests

Rows Deleted



Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating