Before migrating tables to IQ that contain Character Large Object (CLOB), Binary Large Object (BLOB), image or text columns with the IQ Loader DB via Insert Location component, review your IQ configuration. The IQ parameter LOAD_MEMORY_DB controls how much system memory IQ uses to manage these types of columns. By default, IQ sets this parameter to 0, which means that the memory usage for processing these requests is unlimited. You may see this error:
ASA Error -1006042: All available virtual memory has been used; allocation cancelled: Extra info: 948472704].
If you set this parameter to a specific value, for example, 300 (MB), IQ uses only the specified amount of memory to process these requests, and prevents the error from occurring. For more information on IQ parameters, see Chapter 2, “Database options,” in the Sybase IQ 12.7 Reference Manual.
