A system and associated method are provided for directing a database management
system, to relocate buffer pages that are pinned in a buffer pool of a data processing
system. Each of the buffer pages has a respective page descriptor for indicating
the location of the buffer page in the buffer pool. Once the pages are relocated,
the now free system memory of the buffer pool is resized. Prior to resizing, a
selected pinned page is latched by an agent of the system, wherein the selected
page of the buffer pages is in a resize region of the buffer pool. The pinned and
latched page becomes a fixed page. The agent for the database management system
determines a suitable relocation region of the buffer pool for the fixed page.
A resizer module copies the contents of the fixed page to the relocation region
and changes the respective page descriptor to indicate the relocation region. The
resizer module performs the relocation of other pages in the resize region to allow
dynamic resizing of the buffer pool while maintaining the presence of pinned versions
of the pages in the buffer pool prior to resizing.