Re: onmode and system shutdown

In article <332D643C.13A8@edge.net>, Mark Spears <pmspears@edge.net> wrote: >We have a weekly shutdown procedure that requires us to reboot one of >our production machines that runs informix. Recently we had a slight >problem; there was an index rebuild occuring when the automated reboot >script kicked in. The system shut down, and on reboot Online went into >recovery mode for about four hours. > >My question: is there a straightforward way to determine what the >Online 7.12 engine is doing? Some option to onstat, for example, that >would allow a script to intelligently opt for or against shutting down >the informix system? I think what you are looking for is some signs of server activity to be the basis of the decision to reboot. i.e a user who has forgotten to disconnect when s/he closed shop 5 hrs ago is NOT active. If that is so, and on the assumption that you are already executing your reboot thru a cron-run shell script, you can add lines to it to examinine the ONLINE log file's age. Under normal operations, the log file cannot be older than CKPTINTVL seconds, but if there is no activity it stays untouched, irrespective of dormant connections. Implementation : One way is to create a 'marker' file x minutes before your planned shutdown. Then, prior to shutdown, if the log file is NEWER (find option) than the marker, abort. > >My next question: After giving an onmode -ky command, is there any way >to "undo" that and tell the engine that we dont want it to go offline >after all? (We found that it is possible for the engine to go into >quiescent mode for quite a while before actually going offline... ) Nope. Once Shutdown is initiated, you can do zilch about it (Admn. Guide) ---------------------- Rudy Fernandes (ICP) GIC, Kuwait ----------------------