Kbase P178708: Why does promon show transactions in phase 1 and phase 2 when two phase commit is not enabled?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/12/2010 |
|
Status: Unverified
GOAL:
Why does promon show transactions in phase 1 and phase 2 when two phase commit is not enabled?
GOAL:
What does phase 1 and phase 2 transaction states mean in a database not enabled for two phase commit?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
If a transaction spans two databases, you may see transactions in phase 1 or phase 2 in promon R&D options > Status > 4 > 3. This can occur even if the databases are not enabled for two phase commit. Although these are two phase commit states, in ths scenario, they carry less overhead.
The phases are the same but:
- the identity of the coordinator is not recorded
- phase 1 is not persisted and a crash of a participant before the final commit will cause a rollback of in-doubt transactions during crash recovery
- the tl file is not used to record commits