Re: onmode and system shutdown

In article <332D643C.13A8@edge.net>, Mark Spears <pmspears@edge.net> writes >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? > Look at the output to onstat -p and see if the isamtot field changes very much...note it is proably an idea to do an onstat -z to reset the value to be near 0 as it can overflow and become negative or get large and become hard to read... >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... ) > Not that I have idea of, almost certainly no documented way... >Thanks, >Jeff Anderson >Service Merchandise >(thanks Mark for letting me use this account) -- David Williams