Improving the Recovery Log Scan During load database and load tran

You can configure the default data cache to include a large buffer pool for reading log pages and asynchronous prefetch limits.

By default, boot time recovery automatically reconfigures the default data cache to include a large buffer pool for reading log pages and changes the asynchronous prefetch limits for both this pool and the default pool.

This is done to allow recovery to read log pages efficiently and to allow prefetch for large numbers of data (and index pages) and log pages. The settings applied by boot time recovery are:

In SAP ASE 15.7 SP60 and later, specify whether or not to apply these same configuration changes during load database and load tran recovery. To apply the configuration changes, use the sp_configure configuration parameter enable large pool for load. The settings for enable large pool for load are:

Prior to 15.7 SP60, these changes were not applied to load database and load tran recovery because these commands are potentially done on a live system and the changes could negatively impact the rest of the system.