What Are The Database Server Operating Modes Available For Informix? Explain Each.
Answer»
ONLINE : instance is up & running, allowing connections from all the users (that have the necessary GRANTS)
OFFLINE: instance is down. No connections to the database allowed
SINGLE USER: instance is up & running, but only user informix can access the database. Useful when DBA WANTS to CLOSE all the user sessions, perform some TASK and bring the instance in multi user mode
QUIESCENT: Similar with SINGLE USER mode, useful for maintenance task (recovery / recovery of a corrupt or offline dbspace chunk)