From Any Mode Immediately to Offline

You can take the database server immediately from any mode to offline mode. After you take the database server to offline mode, reinitialize shared memory by taking the database server to quiescent or online mode. When you reinitialize shared memory, the database server performs a fast recovery to ensure that the data is logically consistent.

The database server users receive either error message -459 indicating that the database server was shut down or error message -457 indicating that their session was unexpectedly terminated.

After you take the database server to offline mode, reinitialize shared memory by taking the database server to quiescent or online mode. When you reinitialize shared memory, the database server performs a fast recovery to ensure that the data is logically consistent.

The database server performs proper cleanup on behalf of all sessions that were terminated by the database server. Active transactions are rolled back.

To perform an immediate shutdown, perform one of the following commands:

• To shut down all coservers, execute:

  xctl onmode -k

  or

  xctl onmode -ky 

• To shut down only one coserver, execute:

  xctl -X= -c nn onmode -ky -X=

  The -y option eliminates the automatic prompt that confirms an immediate shutdown.