Adaptive Server can simultaneously perform multiple load and dump commands. Loading a database requires one 16K buffer for each active database load. By default, Adaptive Server 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 Adaptive Server. These buffers are not used for dump commands or for load transaction. See Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide: Volume 1.
