onmode -k, -m, -s, -u, -j: Change database server mode

Read syntax diagramSkip visual syntax diagram
Syntax:

>>-onmode--+- -k-+---------------------------------------------><
           +- -m-+   
           +- -s-+   
           +- -u-+   
           '- -j-'   

Element Purpose Key Considerations
-k Takes the database server to offline mode and removes shared memory To reinitialize shared memory, shut down and restart the database server.

Taking the Database Server to Offline Mode with the -k Option.

-m Takes the database server from quiescent or administration mode to online mode See Bringing the Database Server Online with the -m Option.
-s Shuts down the database server gracefully Users who are using the database server are allowed to finish before the database server comes to quiescent mode, but no new connections are allowed. When all processing is finished, -s takes the database server to quiescent mode. The -s option leaves shared memory intact.

See Shutting Down the Database Server Gracefully with the -s Option.

-u Shuts down the database server immediately This option brings the database server to quiescent mode without waiting for users to finish their sessions. Their current transactions are rolled back, and their sessions are terminated.

See Shutting Down the Database Server Immediately with the -u Option.

-j Puts the database server into administration mode This option brings the database server to administration mode, allowing the informix user all functions including the issuance of SQL and DDL commands. The -j -U option enables the DBSA to designate specific users (in addition to the informix user) to access the database server.

See your HCL Informix® Administrator's Guide.

The following sections describe the options that take the database server from one mode to another.


Copyright© 2019 HCL Technologies Limited