Recovery of a target database system

A computer program product comprising one or more computer-readable storage medium having computer-readable program code embodied therewith, said computer-readable program code configured to implement a method, comprising:

• receiving multiple database tables from a source database system to form a target database system;
• receiving multiple batches of database transactions, wherein at least some of the multiple batches of database transactions comprise a sequence of database transactions;
• wherein the method further comprises repeatedly performing the following for a 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 the current batch, a latest commit entry for the current batch, and a latest commit entry for a next batch of the multiple batches of database transactions;
• 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;
• and
• resuming the performance of the sequence of database transactions for the current batch after recovery of the target database system.

A computer system comprising:

• a processor configured for controlling said computer system;
• and
• a memory storing machine executable instructions, execution of said instructions causes said processor to:
• receive multiple database tables from a source database system to form a target database system;
• receive multiple batches of database transactions, wherein at least some of the multiple batches comprise database transactions in a sequence of database transactions;
• wherein the execution of said instructions further causes said processor to repeatedly perform the following for a current batch of the multiple batches of database transactions:
• generate a single recovery bookmark before beginning processing of the current batch, wherein the single recovery bookmark comprises:
• an earliest open entry for the current batch, a latest commit entry for the current batch, and a latest commit entry for a next batch of the multiple batches of database transactions;
• perform the sequence of database transactions for the current batch;
• detect a fault condition during the performance of the sequence of database transactions for the current batch;
• recover the target database system according to a recovery protocol using the single recovery bookmark;
• and
• resume the performance of the sequence of database transactions for the current batch after recovery of the target database system.