TOLOGPOINT—Define the Log Point LRSN to Use

The TOLOGPOINT keyword specifies the log point LRSN to which the tablespace is recovered in a data sharing environment.
cafrdb2
The TOLOGPOINT keyword specifies the log point LRSN to which the tablespace is recovered in a data sharing environment. Use TOLOGPOINT to make a partial recovery.
Review the following considerations:
  • Use TOLOGPOINT with care. Data resulting from a partial recovery might be inconsistent.
  • TOLOGPOINT is not supported with REBUILD INDEX.
  • If you specify TOLOGPOINT when recovering a NOT LOGGED tablespace, specify a recoverable point.
  • TOLOGPOINT is a statement-level operand that can be applied to every object (DATABASE, TABLESPACE, and INDEXSPACE) in the RECOVER statement.
This keyword has the following format:
TOLOGPOINT {X'
byte-string
'|LAST-LOGPOINT|LAST-QUIESCE}
  • X'
    byte
    -
    string
    '
    Specifies the log point (LRSN) to use. Enter this value as a hexadecimal number preceded by an X and enclosed in single quotes ('). If the LRSN of a log record is
    byte-string
    or greater, that record is not used in the recovery.
  • LAST-LOGPOINT
    Recovers to the last copy or quiesce point. SYSIBM.SYSCOPY is scanned to determine the correct LRSN. If the most recent image copy before the specified point is not available, fallback logic takes place. Fallback logic finds the prior image copy and applies log records until the specified point is reached. If a valid image copy is not found, log records defining the object are applied until the specified point has been reached.
    You can enter the LAST-LOGPOINT value only when a single database object is specified for the RECOVER statement. To specify LAST-LOGPOINT for multiple objects (when a common copy or quiesce point was previously established), specify MULTI-OBJECT-TORBA(YES) in
    hlq
    .CDBAPARM(PFR). You must guarantee that all objects in the RECOVER statement have a common copy or quiesce point.
  • LAST-QUIESCE
    Recovers to the last quiesce point. SYSIBM.SYSCOPY is scanned to determine the correct RBA. If no quiesce point is found, the RBA of the most recent image copy is used to determine the correct RBA. If the most recent image copy before the specified point is not available, fallback logic takes place. Fallback logic finds the prior image copy and applies log records until the specified point is reached. If a valid image copy is not found, log records defining the object are applied until the specified point has been reached.