International Business Machines Corporation

Zachary T Hoggard

Wayne Jonleon Young

Pavel Sustr

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.

Growing community of inventors

Markham, Canada

Zachary T Hoggard