US 12,405,865 B1
Recovery of a target database system
Dennis Butterstein, Leinfelden-Echterdingen (DE); Sabine Perathoner-Tschaffler, Nufringen (DE); Antje Dengler, Boeblingen (DE); and Brigitte Gößler, Wildberg (DE)
Assigned to International Business Machines Corporation, Armonk, NY (US)
Filed by INTERNATIONAL BUSINESS MACHINES CORPORATION, Armonk, NY (US)
Filed on Jul. 9, 2024, as Appl. No. 18/766,873.
Claims priority of application No. 2408201 (GB), filed on Jun. 10, 2024.
Int. Cl. G06F 7/00 (2006.01); G06F 11/14 (2006.01); G06F 17/00 (2019.01)
CPC G06F 11/1469 (2013.01) [G06F 2201/80 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer implemented method of recovery of a target database system, the method comprising:
receiving multiple database tables from a source database system to form the target database system; and
receiving multiple batches of database transactions, wherein a current batch of the multiple batches comprises a sequence of database transactions;
wherein the method further comprises performing, for the current batch of the multiple batches of database transactions:
generating a single recovery bookmark before beginning processing of the current batch, wherein the single recovery bookmark comprises: an earliest open entry for a previous batch of the multiple batches of database transactions, a latest commit entry for the previous batch, an earliest open entry for the current batch, a latest commit entry for the current batch, a transactional identifier of the current batch, and list of tables to be processed in the current batch, wherein the multiple database tables comprises tables in the list of tables;
performing the sequence of database transactions for the current batch on the target database using the transactional identifier of the current batch;
replacing the list of tables from the single recovery bookmark with a flag value upon completion of performing the sequence of database transactions for the current batch;
detecting a fault condition during the performance of the sequence of database transactions for the current batch;
recovering the target database system according to a recovery protocol using the single recovery bookmark if the fault condition is detected unless the list of tables is set to the flag value; and
resuming the performance of the sequence of database transactions for the current batch after recovery of the target database system or if the list of tables is set to the flag value.