Chapter 2. Data sharing architecture 25
GBP optimizations
DB2 optimizes GBP access in several ways:
Dynamic recognition of GBP-dependency means that page registration
occurs only when there is inter-DB2 read/write interest. A data set is
dynamically recognized as being GBP-dependent when the P-locks that IRLM
manages indicate that at least one member is reading and at least one
member is writing to the data set.
If DBP1 has opened table space ABC for write (insert, update, or delete) and
DBP2 has opened ABC for read, only DBP2 must register the pages of ABC
that it reads into its local buffer pool. If DBP2 later opens ABC for write, then
both DBP1 and DBP2 must register all pages of ABC that they read into their
local buffers.
If only one ...