DSNB1GET

Module DSNB1GET is part of the Buffer Manager component that obtains virtual addressability of requested pages.

Db2 data is stored in linear addressable DASD data set collections called page sets. Within page sets, the data is stored in fixed-sized units called pages. Db2 functions that process this data do not directly access the page sets, but instead operate on virtual storage copies of the pages.

Hints

High time attributed to DSNB1GET indicates movement of a large number of rows from the buffer pool to a program. Attempt to apply a more restrictive predicate to reduce the number of cross memory moves and limit the number of pages of data returned to the program.

Reference Sources

IBM Db2 for OS/390 Administration Guide, SC26-8957.

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