3-12 IBM Informix OnLine Database Server Administrator’s Guide
From Any Mode Immediately to Offline
From Any Mode Immediately to Offline
This is the proper action to take if you receive a message that the OnLine
daemon is no longer running. After you take OnLine to offline mode, reini-
tialize shared memory by taking OnLine to quiescent or online mode.
If you are user informix, you can take OnLine from any mode to offline
(bypassing quiescent mode) from within DB-Monitor or from the command
line. If you are root, you can only use the command-line options.
A prompt asks for confirmation to go offline. If you confirm, OnLine initiates
a checkpoint request and sends a disconnect signal to all database server
processes that are attached to shared memory. The processes have 10 seconds
to comply before OnLine terminates them.
OnLine users receive either error message, -459 indicating that OnLine was
shut down, or error message, -457 indicating that their database server
process was unexpectedly terminated.
The tbinit daemon process performs proper cleanup on behalf of all database
server processes that were terminated by OnLine. Active transactions are
rolled back.
Taking OnLine offline removes the shared-memory segment. OnLine shared
memory must be reinitialized.
From DB-Monitor
From within DB-Monitor, select the Mode menu, Take-Offline option to take
OnLine offline immediately.
From the Command Line
From the command line, execute tbmode -k or tbmode -ky from the
command line to take OnLine offline immediately.
A prompt asks for confirmation of the immediate shutdown. The -y option to
tbmode eliminates this prompt.
For further information about the tbmode utility, refer to page 7-64.