Identifying objects in advisory restart-pending status

Objects with backout work pending display a status of AREST (advisory restart-pending).

Procedure

To identify objects in advisory restart-pending status:

  1. Use the DISPLAY GROUP command to determine if a member has work pending,
    The following statuses indicate that work is pending for that member:
    A I
    This active member has indoubt URs, URs for which backout work is postponed, or both.
    Q I
    This quiesced member has indoubt URs, URs for which backout work is postponed, or both.
  2. Use the DISPLAY THREAD TYPE(INDOUBT) and DISPLAY THREAD TYPE(POSTPONED) commands to determine whether the pending work is indoubt URs or postponed backout URs.
    • To recover indoubt URs, use the RECOVER INDOUBT command.
    • To recover postponed-abort URs, use the RECOVER POSTPONED command. (If you specify AUTO or LIGHTAUTO for the LBACKOUT subsystem parameter, Db2 automatically recovers the postponed URs after a normal restart. Starting Db2 with the LIGHT(YES) or LIGHT(NOINDOUBTS) option causes postponed-abort URs to be automatically recovered unless LIGHTAUTO or LIGHT is specified for the LBACKOUT subsystem parameter.)
  3. Use the DISPLAY DATABASE command to determine which objects have backout work pending (status of AREST).

    The AREST status is removed when the backout processing is complete for the object. You cannot use the command START DATABASE with ACCESS(FORCE) to remove the advisory status if any indoubt or postponed backout URs exist for the object.

    Utilities are not restricted by the AREST status, but any write claims that are held by postponed-abort URs on the objects in AREST status prevent draining utilities from accessing that page set.