Restarting materialization

DB2 uses a relative byte address (RBA) to identify log records. The RBA value is the numbeer of bytes from the beginning of the file plus the HIGH RBA value of the previous archived log file. This value is also referred to as a log record sequence number (LRSN).

The Materialization RBA begins with 1 and increments by 1, so that the materialization process can be continued if a problem occurs. When a problem does occur, the materialization command can be modified by adding the skip parameter. Records are ignored until the skip record value is reached, then replication begins again at the next record.

The truncation point or QID from the materialization server has the value of the oldest open transaction (OOT). There are three RBA values in the truncation point. The middle RBA is the record number of the OOT. skip should be set to the OOT value minus 1, unless you want to skip a bad record or records.