Two configuration parameters affect logical recovery:
Specifies the number of threads for used logical recovery during a warm restore.
The number of threads should usually match the number of tables or fragments that are frequently updated on each coserver to roll forward the transactions recorded in the logical log.
Another way to estimate the threads required is to use the number of tables or fragments that are frequently updated. On a single-CPU coserver, the number of threads should be no fewer than 10 and no more than 30 or 40. At a certain point, however, the overhead associated with each thread outweighs the advantages of parallel threads.
A warm restore takes place concurrently with other database operations. To reduce the impact of the warm restore on users, you can allocate fewer threads to it than you would to a cold restore.
Specifies the number of threads used for logical recovery during a cold restore and fast recovery.
The size of the buffer pool as specified by the BUFFERS configuration parameter also determines the speed of recovery. The buffer pool must be large enough to contain all of the logical-log and physical log pages that are required for recovery.
For information about specifying a physical-log size that is appropriate for fast recovery, see Managing the Physical Log.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]