Re: How to log users off before dbexport from cron

Graeme Muirhead wrote: > > As part of our overnight jobs we export all our databases to a safe location > on disk. My script to do this first shuts down Online (Version 7.22 on HP-UX > 10.2) using onmode -ky, as the dbexport command will fail if there are still > users running oninit processes. I have two questions: Just as long as you know that the -k option does NOT rollback transactions. Only the -u option will do that. The transactions will be rolled back at start up time if you use -k. So for a quicker start-up, I would use onmode -kuy. > 1. Is it wise to shut down Informix so frequently - can this have a > detrimental effect on performance in that routines that would be read from > cache in an up and running system have to be read from disk the first time > they are executed? Certainly the cache will be cleared, but on a busy system this will be built up again quickly enough. > 2. How can I identify Informix processes running under user IDs and > terminate them safely and cleanly - I could do this with UNIX script but > I'd be happier if there was a tried and tested Informix utility? That's pretty much onmode. 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 |/ ////////| +----------------------+-----------------------------------+-----------+