MQ_COMMON_DIR and Database

Catalog and transactional data is stored in the file system and in the database.

Consult a database administrator (DBA) for details on the best way to back up and recover data using your company’s IT policy.

For the file system, do a full backup, and then incremental backups of the whole $MQ_COMMON_DIR directory. Generally, you should back up the database first and the file system second, since the database contains pointers to the file system.

To restore, first restore the database, and then restore all full backups. Follow this with incremental backups of MQ_COMMON_DIR.