Loss of transaction log file

If you cannot access the database because of a lost or corrupt transaction log file, you must end and then enable two-phase commit.

To recover from the loss of a transaction log file:

  1. If two-phase commit is enabled for the database, end two-phase commit using the PROUTIL 2PHASE END utility.
    Note: If you end two-phase commit and a coordinator recorded any distributed transaction commits in this database, the user cannot resolve any limbo transactions for that distributed transaction unless after-imaging is also enabled for the database.
  2. Enable two-phase commit using the PROUTIL 2PHASE BEGIN utility.
  3. Put the database back online.