erickroco9611
New Member
Hi again...
I don´t know if this post would be better in DBA or Development, but I'm a developer so...
I was looking for some issues in my database with PROMON and I found that some Transactions has a flag as "DEAD".
The law (Progress) said:
"When the "Tran State" is DEAD it signifies the transaction is no longer active.
The transaction id is the one that existed previously when the transaction was active but no longer does.
Effectively, It means that the transaction table entry is now free and available for resuse by a new transaction.
This can often occur when record locks are acquired outside of a transaction."
Then... Should I take care about this!!???
How can I avoid this!!!?
Thanks in advance!
I don´t know if this post would be better in DBA or Development, but I'm a developer so...
I was looking for some issues in my database with PROMON and I found that some Transactions has a flag as "DEAD".
The law (Progress) said:
"When the "Tran State" is DEAD it signifies the transaction is no longer active.
The transaction id is the one that existed previously when the transaction was active but no longer does.
Effectively, It means that the transaction table entry is now free and available for resuse by a new transaction.
This can often occur when record locks are acquired outside of a transaction."
Then... Should I take care about this!!???
How can I avoid this!!!?
Thanks in advance!