78 DB2 Recovery Expert for Multiplatforms
Forward update reconstruction
Start with the image of the row from a backup image and roll forward through all
the updates to the row in the logs to get to the before image for the update in
question. Then it can reconstruct the after image by applying the change given in
the log record. You can force db2la to use forward update reconstruction by using
the “-G f” option when generating Undo/Redo SQL.
Backward update reconstruction
Start with the image of the row that currently exists in the table and roll back
through all of the updates to the row in the logs to get to the after image for the
update in question. Then , RE can reconstruct the before image by reversing the
change given in the log record. ...