Size of page sets

You should allow enough space in your page sets for the expected peak message capacity. You should also allow for any unexpected peak capacity, such as when a build up of messages develops because a queue server program is not running. This can be done by allocating the page set with secondary extents or, alternatively, by enabling dynamic page set expansion. For more information, see Enabling dynamic page set expansion.

When planning page set sizes, consider all messages that might be generated in addition to your application's message data. For example, trigger messages, event messages and any report messages that your application has requested.

The size of the page set determines the time taken to recover a page set when restoring from a backup, because a large page set takes longer to restore.

Note:
Recovery of a page set also depends on the time the queue manager takes to process the log records written since the backup was taken; this is determined by the backup frequency. This is discussed in Recovery procedures.
Note:
Page sets larger than 4GB require the use of SMS extended addressability.