Re: DBA-Question: About In-doubt distributed transactions

Hello,

   I had the same problem with a oracle 7.3.4 distributed DB environment. although I had a lot of contact with local oracle support I did not get a satisfactory
solution. if the pending transaction stays collecting for days or weeks You will
have to clean up the entries with

execute dbms_transaction.purge_lost_db_entry(global_tran_id) commit;

I had to do this several times and I never ran into troubles, but it is highly recommendet to backup all DB nodes before performing this statement, see also API documentation of dbms_transaction. I would not be surprised if oracle 8 provides better equipment to resolve or prevent pending 2pcs.

just for curiosity:
are You dealing with huge distributed transactions on connectivities that like to break down?

regards,
--marcus

Kapustin A.G. schrieb in Nachricht <36DD026A.309F_at_dd.vaz.tlt.ru>...
>Hello!
>
>My Question is:
>
>Some transactions were in-doubt in distributed Oracle database.
>On my node, in view DBA_2PC_PENDING there are some rows with
>status 'collecting' or 'prepared'.
>
>I can easily COMMIT or ROLLBACK transactions referenced by rows with
>'prepared'-state:
> ROLLBACK FORCE 'transaction_id'
>or
> COMMIT FORCE 'transaction_id'
>
>After this action - transaction state changes to 'forced rollback' or
>'forced commit'.
>But I can't do the same action with 'collecting'-entries.
>
>How can I resolve this in-doubt transactions?
>
>Please answers to kag_at_dd.vaz.tlt.ru
>
>Bye
Received on Wed Mar 03 1999 - 18:36:46 CST