Method and apparatus for making available data that was locked by a dead transaction before rolling back the entire dead transaction

A computer-readable medium carrying one or more sequences of one or more instructions for removing changes made by a dead transaction, the one or more sequences of one or more instructions including instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of:

• prior to dying, a transaction making a first change;
• after making said first change and prior to dying, said transaction making a second change;
• and
• after said transaction has died, undoing said first change made by said dead transaction prior to undoing said second change made by said dead transaction.

A system for removing changes made by a dead transaction, the system comprising:

• a memory;
• one or more processors coupled to the memory;
• and
• a set of computer instructions contained in the memory, the set of computer instructions including computer instructions which when executed by the one or more processors, cause the one or more processors to perform the steps of:
• prior to dying, a transaction making a first change;
• after making said first change and prior to dying, said transaction making a second change;
• and
• after said transaction has died, undoing said first change made by said dead transaction prior to undoing said second change made by said dead transaction.

A method for linking recovery records, the method comprising the steps of:

• identifying a recovery record, wherein the recovery record contains change information that reflects a chance to said particular resource;
• linking the recovery record into a recovery record chain, wherein the recovery record chain contains only recovery records that contain change information that reflect one or more changes to said particular resource;
• and
• wherein the step of linking the recovery record includes generating identifying data within at least one of the records in the recovery record chain or within the recovery record, wherein said identifying data once generated identifies a particular record in the recovery record chain.