Patent ID: 11860894
Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 16:
17. A computer program product, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to:
enable replication of an application data table of a database management system (DBMS) via a default amount of logging of a system table that corresponds to the application data table of the DBMS, wherein the default amount of logging includes a partial after image for update operations and does not include before images for delete operations, by:
identifying an update operation as recorded in a roll-forward recovery log for the DBMS, wherein the update operation relates to the system table that corresponds to the application data table;
identifying, using a partial image of the update operation as stored within the roll-forward recovery log, a first row of the system table that corresponds to the application data table, and wherein the first row is associated with the update operation;
querying first entries of system table related to the application data table;
generating, by encoding values of the first entries, a first new before image of the first row of the system table that corresponds to the application data table, wherein the first new before image of the first row reflects the application data table before the update operation;
identifying a delete operation as recorded in the roll-forward recovery log, wherein the delete operation relates to the system table that corresponds to the application data table;
identifying, using an identifier of the delete operation as stored within the roll-forward recovery log, a second row of the system table that corresponds to the application data table, wherein the second row is associated with the delete operation;
querying second entries of the system table that correspond to the application data table; and
generating, by encoding values of the second entries, a second new before image of the system table that corresponds to the application data table, wherein the second new before image reflects the application data table before the delete operation.