What Are The Database Server Operating Modes Available For Informix?

1.	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)

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)