Entering content frame

Background documentation Tablespaces: 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 tablespace(s), call the DBA Cockpit.

...

       1.      In the navigation frame, choose Performance ®Tablespaces.

The Tablespace Snapshot screen appears.

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

A detail Tablespace Snapshot screen appears.

       3.      Choose Asynchronous I/O.

If you have selected more than one tablespace, 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 into 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 buffer pool to disk (I/O cleaners)

Asynchronous Read Requests

Number of asynchronous index read requests

 


 

Leaving content frame