International Business Machines Corporation

Wayne Jonleon Young

Vijayshankar Raman

Guy Maring Lohman

Ronald Jason Barber

Sam Sampson Lightstone

Liping Zhang

Ippokratis Pandis

Gregory R Stager

Vincent Kulandai Samy

Vincent Kulandaisamy

Pavel Sustr

Zachary T Hoggard

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.

Shared disk buffer pool update and modification

Embodiments of the invention relate to processing data records, and for a multi-phase partitioned data reduction. The first phase relates to processing data records and partitioning the records into a first partition of records having a common characteristic and a second partition of records that are not members of the first partition. The data records in each partition are subject to intra-partition data reduction responsive to a resource constraint. The data records in each partition are also subject to an inter-partition data reduction, also referred to as an aggregation to reduce a footprint for storing the records. Partitions and/or individual records are logically aggregated and a data reduction operation for the logical aggregation of records takes place in response to available resources.

Accurate partition sizing for memory efficient reduction operations

Embodiments relate to payload storage format for storing data in support of an aggregation function. As an input is subject to aggregation, the input is evaluated to ascertain a payload format for the aggregation. It is understood that there is more than one payload format. An evaluation of the aggregation key is a factor in the initial payload format. If the key is an addition to an existing aggregation, the evaluation considers changing the format of the payload to address processing and/or memory efficiency for the aggregation. The evaluation and the format change takes place dynamically so that the aggregation may continue.

Adaptive payload management

Embodiments of the invention relate to payload storage format for storing data in support of an aggregation function. As an input is subject to aggregation, the input is evaluated to ascertain a payload format for the aggregation. It is understood that there is more than one payload format. An evaluation of the aggregation key is a factor in the initial payload format. If the key is an addition to an existing aggregation, the evaluation considers changing the format of the payload to address processing and/or memory efficiency for the aggregation. The evaluation and the format change takes place dynamically so that the aggregation may continue.

Growing community of inventors

Toronto, Canada

Wayne Jonleon Young