Configuring Adaptive Server for simultaneous loads

Adaptive Server can perform multiple load and dump commands simultaneously. 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 a restart of Adaptive Server. See “number of large i/o buffers” for more information. These buffers are not used for dump commands or for load transaction.