Kbase P21907: 2PC: How to get a list of distributed transactions committed around a certain time?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
2PC: How to get a list of distributed transactions committed around a certain time?
GOAL:
2PC: How to see if a distributed transaction has been completed by the coordinator?
FIX:
When running Two Phase Commit, as advised, you are most certainly running After Image on each database part of the distributed application.
The solution is to use aimage scan verbose on the coordinator database to view transactions completed by the coordinator:
rfutil <db> -C aimage scan verbose -a <ai>
A 2PC committed transaction would look like this and ends in a RL_CTEND
note:
Trid: 1867 Tue Mar 25 09:26:00 2003. (2598)
code = RL_TBGN (1637)
transaction index = 1868 (1638)
dbkey = 0 update counter = 0 (1639)
Trid: 1868 Tue Mar 25 09:26:00 2003. (2598)
User Id: marshall. (2599)
code = RL_RMDEL (1637)
transaction index = 1868 (1638)
area = 6 dbkey = 23328 update counter = 33 (9016)
...
... ( other notes remove for space)
...
code = RL_BKFAM (1637)
transaction index = 1868 (1638)
area = 6 dbkey = 64 update counter = 1982 (9016)
code = RL_RMNXTF (1637)
transaction index = 1868 (1638)
area = 6 dbkey = 23328 update counter = 35 (9016)
code = RL_CTEND (1637) ----------------------------------> you can see
that the transaction was committed by the coordinator
transaction index = 1868 (1638)
dbkey = 0 update counter = 0 (1639)
Trid: 1868 Tue Mar 25 09:26:00 2003. (2598)
...
....