Re: IDS 7.31 hangs during checkpoint

This sounds like a bug that we have been fighting with in 7.31.UC4. Tech support told us that it was a timing issue, that a table created (for us, in sysmaster database) during a checkpoint would hang the server (and this includes temp tables required for such SQL features such as order by and group by). The only solution was for us to upgrade to 7.31.UC5. This is a known bug, and you should really not have that much trouble getting Tech Support to recognize this. HTH Milton J. Vidrine, Jr. Garden Ridge, Inc. Jay Walters wrote: > I'm using IDS 7.31 TC2 on Windows NT 4.0 Sp3. > > I've got a somewhat consistent hang every 5-7 days on my database server > during a checkpoint. onstat -p says the status is blocked on the > checkpoint, but everything else looks good. Usually I do an onmode > -u/onmode -m to restart and everything goes back to it's merry way. > Could this be something to do with some database resource not being > large enough? Or is this an Informix bug where they don't handle their > critical sections right in the checkpoint code? I've sent in a bunch of > stuff to Informix tech support with no meaningful response. > > Cheers