Mention the database server operating modes available for Informix?

Questions by sripri   answers by sripri

Showing Answers 1 - 3 of 3 Answers

jayanta.js

  • Sep 24th, 2007
 

Informix IDS provide following modes:-
1)Online mode -> This is the normal operating mode of the database server.
2)Offline mode  -> The database server is not running. Shared memory is not allocated.
3)Quiescent mode -> This is the normal operating mode of the database server.
Administrators use this mode to perform maintenance functions that do not require the execution of SQL and DDL statements.
Only the administrator (user informix) can access the database
server.
4)Single-User mode -> This mode is an intermediary mode between Quiescent mode and Online mode.
 Administrators use this mode to perform any maintenance task, including tasks requiring the execution of SQL and DDL statements. Administrators can also perform all other functions available in Online mode. You can see the current database server mode by executing the onstat - utility from the command

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions