Sets the entire database offline or online, with the option of clearing all records from LOGDB.
When the database is set OFFLINE, all non-system databanks are closed. During the process of setting the database OFFLINE, all updated databank pages are forced to disk and all databank shadows are brought up to date.
A typical use for this is when backing up all databank files in one go using the host file system utilities.
When the database is set ONLINE again, you must specify whether to clear all the LOGDB records (using the RESET LOG option), or whether to preserve these (using the PRESERVE LOG option).
The RESET LOG option should be used only after a complete backup has been taken of everything in the database.
The current ident must have BACKUP privilege.
While the database is OFFLINE no connections to it can be established, the database can only be accessed by a single system administrator ident.
An error will be raised if an attempt is made to set the database OFFLINE when it is already OFFLINE, or ONLINE when it is already ONLINE.
ExampleSET DATABASE OFFLINE;
For more information, see the Mimer SQL System Management Handbook, Backing-up and Restoring Data.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40