Transaction log file disk

Recovering from a full disk when two-phase commit is enabled requires disabling two-phase commit.

To recover from a full disk if two-phase commit is enabled:

  1. Use PROUTIL 2PHASE END to disable two-phase commit on the database.
    Note: Unless after-imaging is also enabled for the database when you end two-phase commit, the user will be unable to resolve any limbo transactions where the database recorded the coordinator's commit of a distributed transaction.
  2. Truncate the BI file.
  3. Enable two-phase commit.
  4. Restart the database.