DSNB5RDP

Module DSNB5RDP is the read Database Page routine. It uses Buffer Control Blocks, Page Manipulation Blocks (PMBs), Page Set IDs (DBID/OBID), and Page Number (RBA). It interfaces with the VSAM Media Manager to initiate the physical reading of pages into the Buffer Pool. It is part of the Buffer Manager code in the Database Manager Address Space.

Hints

READIOs result when GETPAGE REQUESTS (DSNB1GET) are not satisfied by data already in the buffer pool. The buffer pool hit ratio can be improved by encouraging the use of SEQUENTIAL PREFETCH in an asynchronous I/O operation. SEQUENTIAL PREFETCH is only selected at BIND time for access paths using a high cluster ratio index although it may be dynamically chosen by Db2 at run time.

DSNB5RDP may also be evident when buffer stealing occurs due to relatively large workloads, and when pages must be reread back into the buffer pool from DASD.

For frequently used tables, consider isolating them in one of the buffer pools so that their data remains resident.

Reference Sources

IBM Db2 for OS/390, Messages and Codes, GC26-8979