Entering content frame

Background documentation Performance: Buffer Pool Snapshot (DB2 UDB for UNIX and Windows) Locate the document in its SAP Library structure

The Buffer Pool Snapshot screen provides an overview of the following important key indicators of the buffer pool activity of your database and enables you to compare these key indicators:

·        Buffer Pool Name

·        Buffer Pool Size (KB)

·        Buffer Quality (%)

·        Data Logical Reads

·        Data Physical Reads

·        Index Logical Reads

·        Index Physical Reads

·        Temporary Data Logical Reads

·        Temporary Data Physical Reads

·        Temporary Index Logical Reads

·        Temporary Index Physical Reads

You can access the Buffer Pool Snapshot screen by calling the DBA Cockpit and choosing Performance ® Buffer Pools in the navigation frame of the DBA Cockpit.

You can display more detailed information by selecting one or more buffer pools and choosing This graphic is explained in the accompanying text Details. A detail Buffer Pool Snapshot screen appears with information on:

·        Buffer Pools

·        Asynchronous I/O

·        Direct I/O

·        Extended Storage

Leaving content frame