Re: Shutdown database

William Raper wrote: > > Shutdown: onmode -yuck > (translates to (c) do a checkpoint (u) shutdown & kill all > attached systems > (k) completely shutdown (y) yes ) > > For all you old-timers out there: I learned recently that > there are conditions > under which the -yuck is better than a -ky -- specifically > during an upgrade > from 7.2x to 7.3x. I've never heard of a -c option. A -u or -k option is supposed to perform a checkpoint anyway. The change that was made in version 6 was that the -k option no longer rolled back unfinished transactions as it did in version 5. So the transactions would only be rolled back at startup time, thus causing a potential delay. If you want to shutdown completely and perform the rollback, then you must issue the -kuy options. I'm sure I have mentioned this before, and possibly is has made it to the FAQ. This then is the basis of the problem you would encounter when upgrading to a new version. You should rollback all transactions in the old version instead of attempting to roll them back in the new version. I would never recommend running onmode -ky unless you were in a hurry to shutdown and you had a lot of active users. You will STILL have to wait for the startup, but it might let you go home earlier. ;-) 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 |/ ////////| +----------------------+-----------------------------------+-----------+