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

Buffer Pool Statistics

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

Direct Read Requests

Physical Page Maps

Direct Reads

Pool Async Data Read Requests

Direct Write Requests

Pool Async Data Reads

Direct Writes

Pool Async Data Writes

Files Closed

Pool Async Index Writes

Index Logical Reads

Pool Data Logical Reads

Index Physical Reads

Pool Data Physical Reads

Index Writes

Pool Data Pages to Extended Storage

Pages from Block IOs

Pool Data Writes

Pages from Vectored IOs

Unread Prefetch Pages

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating