Subject Re: [IB-Architect] Isolation level implemetation
Author Ann W. Harrison
Helen wrote:

>To satisfy Ivan's very valid requirement, I'd like a function that's
>surfaced in the Services API which reports uncommitted transactions, along
>with their start times, the USER variable and any locks which currently
>apply to each transaction. I guess this involves scanning the TIP or
>deltas or something of that ilk...

Start time isn't recorded. Scanning the lock table would be a good
start. In fact, if you've got something really stuck, you can find
the culprit right now through a lock print and ps -<somethingorother>.


We have answers.