I found a in-doute transaction through Instance Manager. The application
could not query a table which was dead-locked by this in-doubt transaction.
I knew nothing to clear this. I had to shutdown the instance. After that,
everything is ok.Below is part of trace file.
- SESSION ID:(8.6) 2000.04.28.09.58.22.000
DISTRIB TRAN
28.747578320000000000000000000000000000000000000000000000000000000016B907004409F938128E9100
is local tran 6.7.43497 (hex=06.07.a9e9)
change pending prepared tran, scn=9377247 (hex=0.008f15df)
to pending collecting tran, scn=9377247 (hex=0.008f15df)
DISTRIB TRAN
28.747578320000000000000000000000000000000000000000000000000000000016B907004409F938128E9100
is local tran 6.7.43497 (hex=06.07.a9e9))
delete pending collecting tran, scn=9377247 (hex=0.008f15df)
Thank in advance.
Tel:(8621)52340871/0872*667
E-mail:cyhu_at_eachnet.com
Received on Thu Apr 27 2000 - 22:59:01 CDT