FROMLOGLABEL—Define the Log Label to Use

The FROMLOGLABEL keyword defines the log label from which the tablespaces are recovered.
cafrdb219
The FROMLOGLABEL keyword defines the log label from which the tablespaces are recovered. Use this keyword to specify the log starting point when you perform a log-only recovery after a point-in-time recovery outside of Db2. During FROMLOGLABEL recovery, each log record RBA is compared with the RBA in the data pages. If the log record RBA is less than the data page RBA, the recover job assumes it has already been applied and ignores the current log record.
Use FROMLOGLABEL with care. Data resulting from a partial recovery can be inconsistent.
This keyword denotes a partial log-only type of recovery. Do not specify the LOGONLY keyword with FROMLOGLABEL.
FROMLOGLABEL is omitted by default.
Specify only one FROMLOGLABEL for a RECOVER statement even when the statement includes multiple tablespaces.
FROMLOGLABEL is not valid with RECOVER INDEX. FROMLOGLABEL is not valid for OBIDXLAT recovery. Use the STARTRBA keyword instead.
This keyword has the following format:
FROMLOGLABEL {[creator.]name[(version)]}
  • creator
    (Optional) Specifies the creator of the log label.
  • name
    Specifies the log label name.
  • version
    (Optional) Specifies the log label version.