Backup and Recovery of the Master Database (iidbdb)

The iidbdb database is your Ingres installation's master database. It contains information about your installation as a whole, such as:

• Which databases exist in this installation
• Where user databases are located
• Which locations can be used for files
• Which users can access databases

The iidbdb also contains information about groups, roles, and database privileges defined for your site.

The iidbdb is journaled by default.

The iidbdb and Checkpointing

You should regularly checkpoint and journal the iidbdb database. Ckpdb and rollforwarddb are the supported utilities for recovering the iidbdb if it is lost or damaged for any reason. The system catalogs containing the installation information for groups, roles and database privileges are stored in the iidbdb database and can only be recovered from backups.

For the detailed steps for performing these procedures, see the Procedures section of online help for VDBA. See the topic Setting Checkpoints and the topic Recovering a Database from Checkpoints.