Re: informix - problem with locked records (systables)

David Williams wrote: > > In article <37F248F0.EA880700@bloomberg.net>, Art S. Kagel > <kagel@bloomberg.net> writes > >o_neill wrote: > >> > >> Do you mean (onmode -s) for single user mode or > > > >Only if there are no attached users, and if there are actually phantom > >connections holding locks the onmode -s will never take effect since it > >waits for all users sessions to end. > > > >> (onmode -u) to shutdown and kill all attached sessions? > > > >Yes. > > > Surely onmode -yuk ??? > Sorry I don't have the manuals in front of me, but I remember this in > the release notes someone and I remember adding it to the FAQ.. Yes, the -u is required to rollback transactions at shutdown time since version 6. Which ever you use, you will still have to rollback those transactions, whether at shutdown time or at startup time. If a -uy or -kuy appears to freeze, then try just a -ky and let fast recovery rollback the transactions. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock http://www.informix.com |//////// /| | mailto:mdstock@mydas.freeserve.co.uk |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+