STARTUP-ACCESS—Specify a Mode for the Recovered Object

The STARTUP-ACCESS keyword specifies the mode in which the object is placed after the recovery.
cafrdb2
The STARTUP-ACCESS keyword specifies the mode in which the object is placed after the recovery. All objects are placed in STOP mode during the recovery job.
IFI is used to start and stop objects.
Review the following considerations:
  • If objects were recovered as point-in-time (TORBA or TOCOPY) recoveries, take an image copy before restarting them. When
    Fast Recover
    starts processing, the object is stopped using IFI.
  • If you omit STARTUP-ACCESS, the object is started in its original state (RESET).
  • When STARTUP-ACCESS is specified with REBUILD INDEX or RECOVER INDEX, the specified mode applies only to the indexspace. The status of the associated tablespace is not affected.
This keyword has the following format:
STARTUP-ACCESS {
RESET
|RW|RO|FORCE|STOP}
  • RESET
    Sets the object back to its original state. This value is the default.
  • RW
    Lets programs read from or write to the named objects.
  • RO
    Lets programs read the named objects.
  • FORCE
    Resets any indications that an object is unavailable because of pending deferred restarts, write error ranges, read-only accesses, or utility controls. FORCE also resets check pending, copy pending, and recovery pending states. Full access to the data is forced. For more information about FORCE, see the IBM
    Db2 Command and Utility Reference
    manual.
  • STOP
    Puts objects in STOP mode.