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 userinformix, you can take OnLine from any mode to offline
(bypassing quiescent mode) from withinDB-Monitor or from the command
line. If you areroot, you can only use the command-line options.
Aprompt asks for confirmation to go offline. If you confirm, OnLine initiates
a checkpoint request and sends a disconnect signal to all database server
processesthat 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.
Thetbinit daemon process performs proper cleanup on behalf of all database
server processes that were terminated by OnLine. Active transactions are
rolled back.
TakingOnLine offline removes the shared-memory segment. OnLine shared
memory must be reinitialized.
From DB-Monitor
Fromwithin DB-Monitor, select the Mode menu, Take-Offline option to take
OnLine offline immediately.
From the Command Line
From the command line, executetbmode -k or tbmode -ky from the
command line to take OnLine offline immediately.
Aprompt asks for confirmation of the immediate shutdown. The -y option to
tbmode eliminates this prompt.
For further information about thetbmode utility, refer to page7-64.