Backing Up the IQ Store and Catalog Store

Read the rest of the backup topics for complete details before you perform a backup.

This procedure summarizes backup steps.

  1. Connect to the server using an account with DBA privileges. For a multiplex database, you must connect to the coordinator.
  2. Run the BACKUP command. For complete syntax, see Reference: Statements and Options.
    It backs up the following files:

    • The catalog store (SYSTEM dbspace file), typically named dbname.db

    • All dbspace files of the IQ store

  3. Make a copy of the params.cfg file for each server. BACKUP does not back it up.
  4. Save the lengths of the following files:

    • All dbspace files on the coordinator

    • IQ temporary store

Parent topic: Types of Backups