Invention Grant
- Patent Title: Shared disk buffer pool update and modification
-
Application No.: US16690294Application Date: 2019-11-21
-
Publication No.: US11314718B2Publication Date: 2022-04-26
- Inventor: Wayne Jonleon Young , Pavel Sustr , Zachary T. Hoggard
- Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts
- Agent Stephanie Carusillo
- Main IPC: G06F16/23
- IPC: G06F16/23 ; G06F16/28 ; G06F16/2455

Abstract:
A method, system, and program product for updating buffer pools in a shared disk clustered database system is provided. The method includes generating thread software code for servers of a clustered database system. Cluster-wide lock software configured with respect to a shared mode for servers of the clustered database system is received. A tablespace space reclaim function is executed for moving data pages from a first location of a shared disk structure to a second location resulting in generation of updated data page metadata. The updated data page metadata is stored within the clustered database system and functionality of thread software code is detected. The cluster-wide lock software is reclaimed, enabling remote thread software code. A second cluster-wide lock is utilized to coordinate achievement of an idle state of local and remote threads. An idle state is enabled with respect to servers of the shared disk clustered database system.
Public/Granted literature
- US20210157784A1 SHARED DISK BUFFER POOL UPDATE AND MODIFICATION Public/Granted day:2021-05-27
Information query