Technical data
Managing the Queue Manager and Queue Database
13.9 Saving and Restoring the Queue Database
Note
When you restore your queue database, you must always restore both the
master and queue files, even if you lost only one of those files.
5. Start the queue manager with the START/QUEUE/MANAGER command. Do
not enter the /NEW_VERSION qualifier: a new, empty journal file will be
created automatically.
Example
The following example is a simple procedure showing how to restore the queue
database from tape.
$ STOP/QUEUE/MANAGER/CLUSTER
$ SET DEFAULT SYS$COMMON:[SYSEXE]
$ DELETE SYS$QUEUE_MANAGER.QMAN$JOURNAL;,SYS$QUEUE_MANAGER.QMAN$QUEUES;, -
_$ QMAN$MASTER.DAT;
$ MOUNT/FOREIGN MUA0:
%MOUNT-I-MOUNTED, QDB mounted on _LILITH$MUA0:
$ BACKUP/LOG MUA0:QDB_9SEP.SAV/SELECT=[SYSEXE]MASTERFILE_9SEP.KEEP; -
_$ QMAN$MASTER.DAT;
%BACKUP-S-CREATED, created SYS$COMMON:[SYSEXE]QMAN$MASTER.DAT;1
$ SET MAGTAPE/REWIND MUA0:
$ BACKUP/LOG MUA0:QDB_9SEP.SAV/SELECT=[SYSEXE]QFILE_9SEP.KEEP; -
_$ SYS$QUEUE_MANAGER.QMAN$QUEUES
%BACKUP-S-CREATED, created SYS$COMMON:[SYSEXE]SYS$QUEUE_MANAGER.QMAN$QUEUES;1
$ DISMOUNT MUA0:
$ START/QUEUE/MANAGER
13.10 Maximizing Queuing System Performance
The following resources have the most effect on queuing system performance:
• CPUs — CPU speed and availability are important on the nodes on which the
queue managers are running. The more time the queue manager has and the
faster the CPU, the faster the queue manager can process information.
• Disks — Disk speed as well as nonqueuing activity (such as paging and heavy
access to the database) on the database disk can affect performance.
Use the following methods to maximize your queuing system’s performance:
• Maintain queue manager processes on the fastest and most available nodes in
a cluster. (See Section 13.1.)
• Create an additional queue manager to run on another node to distribute the
CPU load on heavily used queuing systems. (See Section 13.8.)
• Move queue and journal files to disks with less activity or higher speeds. (See
Section 13.5.)
Note that moving the master file provides little difference in performance.
Managing the Queue Manager and Queue Database 13–15