Certain operations may cause the memory used by Sybase IQ to grow dynamically. Changing the way Sybase IQ uses buffers can dramatically change the way it uses memory. See the chapter entitled “Managing System Resources” in the Sybase IQ Performance and Tuning Guide for more information about buffers.
Depending upon the load on the system where Sybase IQ is running, the amount of system swap required may sometimes exceed the suggested minimum. Insufficient swap space may result in the system supporting fewer users, and large processes that cannot acquire sufficient swap space may be prematurely killed by the operating system.
See your operating system documentation for information about extending swap space.