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 see Chapter 5, “Setting Configuration Parameters,” for more information. These buffers are not used for dump commands or for load transaction.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
