STARTRBA—Define the Starting RBA

The STARTRBA keyword specifies the log RBA from which to recover the tablespace.
cafrdb219
The STARTRBA keyword specifies the log RBA from which to recover the tablespace. Use this keyword when performing OBID translation processing.
During the STARTRBA recovery, the recovery job compares each log record RBA with the RBA recorded in the data pages. If the log record RBA is less than the data page RBA, the recovery job assumes it has already been applied and ignores the current log record.
Consistency checks cannot be performed on the log ranges to be applied. Verify that the specified range does not include any activity that is not logged; for example, REORG with LOG=NO.
This keyword has the following format:
STARTRBA {X'
byte-string
'|HPRBA}
  • X'
    byte-string
    '
    Specifies the RBA. If the RBA of a log record is
    byte-string
    or greater, that record is used in the recovery. Enter the RBA as a hexadecimal number preceded by X and enclosed in single quotes.
  • HPRBA
    Specifies that HPRBA determines the starting RBA value. Use this setting when you do not know the value to specify. HPRBA uses the larger value between the HPGRBRBA and PGLOGRBA as the starting RBA value. If the RBA of a log record is equal to or greater than this value, that record is used in the recovery.
If you specify STARTRBA without ENDRBA, then ENDRBA defaults to the highest written RBA in the bootstrap data set for the Db2 subsystem containing the log records.
Consider the following items when using this keyword:
  • STARTRBA requires SORTLOG YES with OBIDXLAT.
  • STARTRBA requires FULLDD.
  • STARTRBA is
    not
    valid with RECOVER DATABASE, RECOVER INDEX, or REBUILD INDEX.
More information: