FROMRBA or FROMLOGPOINT specification

You can specify FROMRBA or FROMLOGPOINT only with LOGAPPLY ONLY. When you use LOGAPPLY ONLY, you must specify FROMRBA or FROMLOGPOINT for each table space and index specification.

FROMRBA or FROMLOGPOINT specifies the log point in the log where the application of the log records should begin for the object or object data set being recovered. You can specify the log point with a keyword or with a hexadecimal string.

This option assumes that the object or objects have been brought to an appropriate point by some other activity prior to this step.

You can use the FROMRBA and FROMLOGPOINT keywords interchangeably, regardless of the version of Db2 that you are using.

The syntax diagram for the FROMRBA or FROMLOGPOINT specification is in RECOVER-TABLESPACE-RECOVER-INDEX-and-RECOVER-INDEXSPACE-syntax.

Related topics

RECOVER-TABLESPACE-RECOVER-INDEX-and-RECOVER-INDEXSPACE-option-descriptions

Example-4-Recovering-to-a-specified-copy

Example-8-Recovering-using-tape-stacked-data-sets

Example-10-Overriding-installation-options

Example-5-Recovering-to-a-specific-log-point


Option

Description

FROMRBA LASTQUIESCE or FROMLOGPOINT LASTQUIESCE

FROMRBA LASTQUIESCE or FROMLOGPOINT LASTQUIESCE specifies that the log point where the application of the log records will begin for this object (or object data set) is the log point of the most recent quiesce point registered in SYSIBM.SYSCOPY. If this is recovery of an index, the QUIESCE entry for the table space is used. You can abbreviate LASTQUIESCE to LASTQ.

Important

If you use LASTQUIESCE and the quiesce is prior to the ALTER ADD PART, the recovery will fail. You must specify a hard-coded RBA. If the partition was added for a partition-by-growth universal table space, you can use the LASTQUIESCE option.

FROMRBA LASTCOPY or FROMLOGPOINT LASTCOPY

FROMRBA LASTCOPY or FROMLOGPOINT LASTCOPY specifies that the log point where the application of the log records will begin for this object (or object data set) is the log point of the most recent image copy (full or incremental) registered.

FROMRBA LASTARCHQ or FROMLOGPOINT LASTARCHQ

FROMRBA LASTARCHQ or FROMLOGPOINT LASTARCHQ specifies that the log point of the most recent ARCHIVE LOG MODE(QUIESCE) command is the point where the application of the log records will begin for this object (or object data set).

FROMRBA LASTSHUTDOWN or FROMLOGPOINT LASTSHUTDOWN

FROMRBA LASTSHUTDOWN or FROMLOGPOINT LASTSHUTDOWN specifies that the log point of the most recent successful STOP DB2 command is the point where the application of the log records will begin for this object (or object data set).

Important

If you specify this keyword in a data sharing environment, log records since the last successful shutdown of the member subsystem on which the job is running is used for recovery, without regard to other member subsystems. For this reason, use extreme caution when you use FROMRBA LASTSHUTDOWN or FROMLOGPOINT LASTSHUTDOWN in a data sharing environment to ensure that the shutdown used is really a point consistent with the state of the spaces.

FROMRBA X'logPoint' or FROMLOGPOINT X'logPoint'

FROMRBA X'logPoint' or FROMLOGPOINT X'logPoint' specifies the log point in the log where the application of the log records for this object will begin.

'logPoint' is a string of up to twelve hexadecimal digits.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*