Method, system and computer program product for synchronizing the flushing of parallel nodes database segments through shared disk tokens

Claim 3

The method as recited in claim 1, wherein the step of selectively flushing comprises the step of selectively flushing the database segments from the primary node when the persistent storage semaphore indicates that the backup node has not yet started flushing the database segments.

Claim 4

The method as recited in claim 1, wherein the step of selectively flushing comprises the step of selectively flushing the database segments from the backup node when the persistent storage semaphore indicates that the primary node has not yet started it s flush procedure.

Claim 5

The method as recited in claim 1, wherein the step of selectively flushing comprises the step of selectively flushing the database segments from either the primary node or the backup node to the data storage device in response to a received flush command.

Claim 6

The method as recited in claim 1, wherein the persistent storage semaphore indicates an initialization of a flush.

Claim 7

The method as recited in claim 1, wherein the persistent storage semaphore indicates a request for a flush.

Claim 8

The method as recited in claim 1, wherein the persistent storage semaphore indicates a flush is in progress.

Claim 9

The method as recited in claim 1, wherein the persistent storage semaphore indicates a flush has completed.

Claim 10

A computer system, comprising: (a) a plurality of nodes and a data storage device coupled to the computer system; (b) access means coupled to the data storage device for accessing one or more database segments from a data storage device attached to the computer system, for modifying the accessed database segments, and for storing a copy of the modified database segments in both a primary node and a backup node;; (c) definition means coupled to the data storage device for defining a persistent storage semaphore for the database segments on the data storage device, wherein the persistent storage semaphore is accessible by both the primary and backup nodes; (d) modification means coupled to the data storage device for modifying the persistent storage semaphore for the database segments on the data storage device to indicate a flush status of both the primary and backup nodes; and (e) flush means coupled to the plurality of nodes and the data storage device for selectively flushing the database segments from either the primary node or the backup node to the data storage device based on the flush status indicated in the persistent storage semaphore.

Claim 11

A computer system, comprising: (a) a plurality of nodes and a data storage device coupled to the computer system; (b) access means coupled to the data storage device for accessing one or more database segments from a data storage device attached to the computer system, for modifying the accessed database segments, and for storing a copy of the modified database segments in both a primary node and a backup node;; (c) definition means coupled to the data storage device for defining a persistent storage semaphore for the database segments on the data storage device, wherein the persistent storage semaphore is accessible by both the primary and backup nodes; (d) modification means coupled to the data storage device for modifying the persistent storage semaphore for the database segments on the data storage device to indicate a flush status of both the primary and backup nodes; and (e) flush means coupled to the plurality of nodes and the data storage device for selectively flushing the database segments from either the primary node or the backup node to the data storage device based on the flush status indicated in the persistent storage semaphore.

Claim 12

The computer system as recited in claim 9, wherein the flush means comprises means for selectively flushing the database segments from the primary node when the persistent storage semaphore indicates that the backup node has not yet started flushing the database segments.

Claim 13

The computer system as recited in claim 9, wherein the flush means comprises means for selectively flushing the database segments from the backup node when the persistent storage semaphore indicates that the primary node has not yet started its flush procedure.

Claim 14

The computer system as recited in claim 9, wherein the flush means comprises means for selectively flushing the database segments from either the primary node or the backup node to the data storage device in response to a received flush command.

Claim 15

The computer system as recited in claim 9, wherein the persistent storage semaphore indicates an initialization of a flush.

Claim 16

The computer system as recited in claim 9, wherein the persistent storage semaphore indicates a request for a flush.

Claim 17

The computer system as recited in claim 9, wherein the persistent storage semaphore indicates a flush is in progress.

Claim 18

The computer system as recited in claim 9, wherein the persistent storage semaphore indicates a flush has completed.

Claim 19

One or more program storage devices readable by a computer having a memory and coupled to a data storage device, each of the program storage devices tangibly embodying one or more programs of instructions executable by a computer to perform method steps for flushing database segments in a computer system having a plurality of processor nodes, the method comprising the steps of: (a) accessing one or more database segments from a data storage device attached to the computer system, modifying the accessed database segments, and storing a copy of the modified database segments in both a primary node and a backup node; (b) defining a persistent storage semaphore for the database segments on the data storage device, wherein the persistent storage semaphore is accessible by both the primary and backup nodes; (c) modifying the persistent storage semaphore for the database segments on the data storage device to indicate a flush status of both the primary and backup nodes; and (d) selectively flushing the database segments from either the primary node or the backup node to the data storage device based on the flush status indicated in the persistent storage semaphore.

Claim 20

One or more program storage devices readable by a computer having a memory and coupled to a data storage device, each of the program storage devices tangibly embodying one or more programs of instructions executable by a computer to perform method steps for flushing database segments in a computer system having a plurality of processor nodes, the method comprising the steps of: (a) accessing one or more database segments from a data storage device attached to the computer system, modifying the accessed database segments, and storing a copy of the modified database segments in both a primary node and a backup node; (b) defining a persistent storage semaphore for the database segments on the data storage device, wherein the persistent storage semaphore is accessible by both the primary and backup nodes; (c) modifying the persistent storage semaphore for the database segments on the data storage device to indicate a flush status of both the primary and backup nodes; and (d) selectively flushing the database segments from either the primary node or the backup node to the data storage device based on the flush status indicated in the persistent storage semaphore.

Claim 21

The one or more program storage devices as recited in claim 17, wherein the step of selectively flushing comprises the step of selectively flushing the database segments from the primary node when the persistent storage semaphore indicates that the backup node has not yet started flushing the database segments.

Claim 22

The one or more program storage devices as recited in claim 17, wherein the step of selectively flushing comprises the step of selectively flushing the database segments from the backup node when the persistent storage semaphore indicates that the primary node has not yet started its flush procedure.

Claim 23

The one or more program storage devices as recited in claim 17, wherein the step of selectively flushing comprises the step of selectively flushing the database segments from either the primary node or the backup node to the data storage device in response to a received flush command.

Claim 24

The one or more program storage devices as recited in claim 17, wherein the persistent storage semaphore indicates an initialization of a flush.

Claim 25

The one or more program storage devices as recited in claim 17, wherein the persistent storage semaphore indicates a request for a flush.

Claim 26

The one or more program storage devices as recited in claim 17, wherein the persistent storage semaphore indicates a flush is in progress.

Claim 27

The one or more program storage devices as recited in claim 17, wherein the persistent storage semaphore indicates a flush has completed.