Configuring SAP ASE for Simultaneous Loads

SAP ASE can simultaneously perform multiple load and dump commands.

Loading a database requires one 16K buffer for each active database load. By default, SAP ASE is configured for six simultaneous loads.

To perform more loads simultaneously, a system administrator can increase the value of number of large I/O buffers:

sp_configure "number of large i/o buffers", 12

This parameter requires you to restart SAP ASE. These buffers are not used for dump commands or for load transaction. See System Administration Guide: Volume 1 > Setting Configuration Parameters.