On May 1, 2008, at 5:40 AM, spammeiloveit@googlemail.com wrote:

> Don't laugh, but I am still using IngresII 2.5 on Reliant UNIX.
>
> Every 6 months or so our weekly iidbdb online "ckpdb" batch job hangs,
> locking the entire installation. Last time the final part of the log
> file was "CPP: Preparing stall of database, active xact cnt: 2".
> ...
>
> Is the "ckpdb iidbdb" process uniquely vulnerable to active sessions,
> or is the cause of our problems more likely to be something else?

The queue tables used by the Remote Command Server used to be in iidbdb.
They got moved to imadb, and I thought that was in 2.5; but it could
be that I am wrong. Or it could be that if the upgrade didn't do
just the right thing, they'd stay in iidbdb. Is this an upgrade
installation from an older version?

Other than rmcmd queue tables, I can't think of anything that would
normally hold iidbdb open for any length of time, unless some
hideously misguided (and privileged) application put something
nonstandard in there.

Karl