QDB Administration

The QDB offers special commands that you can issue to the database to make it easier to administer. You can use these commands to add new databases, delete old ones, perform backups, etc.

This chapter contains:

• Backing up and restoring databases

Backing up and restoring databases

You can back up databases to permanent storage (or any POSIX filesystem that allows read/write access) by:

• calling qdb_backup() from a client application
• using the -b option to qdbc.
• using the resource manager interface:

  echo backup dbname >/dev/qdb/.control

These methods are affected by options in the QDB configuration file. See the “Configuration file” section of the Starting QDB chapter for more information.

To restore a database, start qdb with the -R option set to auto. For more information about this option, see the “Database recovery” section in the Starting QDB chapter.

You can cancel a database backup in client code by calling qdb_bkcancel(). You can also cancel a backup operation using the resource manager interface:

echo cancel >/dev/qdb/.control