Your IQ database must be shut down during a system-level backup. For details about performing system-level backup on multiplex systems, see Using Sybase IQ Multiplex.
You must shut down your IQ database before starting the system-level backup. You must also ensure that no one starts the IQ database until the system-level backup is complete.
The file protection of the .db file is read-only when the database is shut down cleanly, and set to read/write when the database is in use. If you are writing a script to perform backups, it is a good idea for the script to check the access mode of the file, to be sure that the database is shut down.
To ensure that a database remains shut down, the script can check the size of the .iqmsg file at the start and end of the script to make sure it has not changed. If the database was started while the script was running, the .iqmsg file is larger.
