Mention the database server operating modes available for Informix?
Submitted by: AdministratorInformix 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 inOnline mode. You can see the current database server mode by executing the onstat - utility from the command.
Submitted by: Administrator
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 inOnline mode. You can see the current database server mode by executing the onstat - utility from the command.
Submitted by: Administrator
Read Online Informix Job Interview Questions And Answers
Top Informix Questions
☺ | What is the informix-list@iiug.org mailing list? |
☺ | Explain about light scans in Informix? |
☺ | Somehow Informix fails to go online. Is there a way to view what oninit is doing? |
☺ | What is Informix Binary Large Object? |
☺ | Mention the database server operating modes available for Informix? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |