System and method for relocating pages pinned in a buffer pool of a database system
AssigneeInternational Business Machines Corporation
InventorsKeriley K. Romanufa, Aamer Sachedina
Life of this patent
Estimating the term…
Loading patent…
AssigneeInternational Business Machines Corporation
InventorsKeriley K. Romanufa, Aamer Sachedina
Estimating the term…
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.
A method for directing a database management system to relocate buffer pages that are pinned in a buffer pool, the method comprising:
A computer program product having instruction codes for directing a database management system to relocate buffer pages that are pinned in a buffer pool, the computer program product comprising:
A system for directing a database management system to relocate buffer pages that are pinned in a buffer pool, the system comprising:
Dependencies are inferred from the claim text.