We are running ASE 11.9.2.1 SWR 8741 on WinNT 4.0 with SP 5.

Twice yesterday, I had a spid that had had a SP, went into recv sleep (the
status in the sysprocesses table), yet did not relinquish the exclusive
locks it had established.

We have been having a similar problem with the chained mode being switched
on mysteriously, possibly by PowerDynamo, which could be causing this
situation.

1. I have been killing the spid to free up the locks. Is there a way to
tell it to commit instead?

2. Is there a way to disable chained mode completely, forcing everything to
run in unchained mode?

3. Are there any other good explanations for this behavior?

4. Is setting Autocommit to true in PowerDynamo the same thing as setting
the chained mode off?