Entering content frame

Background documentation Buffer Pools: Asynchronous I/O (DB2 UDB for UNIX and Windows) Locate the document in its SAP Library structure

To display information on asynchronous I/O for your selected buffer pool(s), call the DBA Cockpit.

...

       1.      In the navigation frame, choose Performance ®Buffer Pools.

The Buffer Pool Snapshot screen appears.

       2.      To display more detailed information, select one or more buffer pools and choose This graphic is explained in the accompanying text Details.

A detail Buffer Pool Snapshot screen appears.

       3.      Choose Asynchronous I/O.

If you have selected more than one buffer pool, you can use the page buttons on the screen to navigate between them.

 

Field

Description

Average Time

 

Asynchronous Physical Reads

Average time in milliseconds required by the I/O servers to read a page from disk and write it to the buffer pool

Asynchronous Physical Writes

Average time in milliseconds required by the I/O cleaners to read a page from the buffer pool and write it to the hard disk

Data

 

Asynchronous Physical Reads

Number of data pages that were read asynchronously from disk and written to the buffer pool by the I/O servers (prefetch)

Asynchronous Physical Writes

Number of data pages that were written asynchronously from buffer pool to disk (I/O cleaners)

Asynchronous Read Requests

Number of asynchronous data read requests

Index

 

Asynchronous Physical Reads

Number of index pages that were read asynchronously from disk and written to the buffer pool by the I/O servers (prefetch)

Asynchronous Physical Writes

Number of index pages that were written asynchronously from buffer pool to disk (I/O cleaners)

Asynchronous Read Requests

Number of asynchronous index read requests

Note

Data is read or written in pages. A page can be 4 KB, 8 KB, 16 KB, or 32 KB in size.

 

Leaving content frame