Kbase P63666: What is important to know with 2PC (Two-phase Commit)?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
What is important to know with 2PC (Two-phase Commit)?
GOAL:
First aid for two phase commit
FIX:
There are two important things to know for handling Two-phase Commit (2PC):
1. Resolving Limbo Transaction is well documented
. paragraph 12.5 of Progress Data Administration Guide (V8)
. paragraph 10.5 of Progress Data Administration Guide and Reference book (V9)
.
2. If there is a problem on one database, then all databases part of the 2PC configuration need to be restored with latest backup and the After-Image extents roll forward ("rfutil" command) with same yyyy:mm:dd:hh:mm:ss value for "endtime" option or, if the problem is at the time of a distributed transaction, with the locally identified transaction numbers and "endtrans" option.
After-Image and 2PC commit is to enable before restarting the databases.