DB Bulk Load Sybase IQ and DB Space

If you are using the Bulk Load Sybase IQ component and the project or job takes a long time to execute, and if you see an out of space message in the Sybase IQ console or log, you need to add another dbspace.

The message in the IQ message file indicates which dbspace has run out of space and the minimum number of megabytes to add. If the problem occurs while you are inserting data, you may need more room in the IQ store. If the problem occurs during queries with large sorts and merges, you may need more room in the temporary store.

This SQL statement adds 100MB of database space to the existing iqdemo database on Windows:

CREATE DBSPACE iqdemo2 AS
'd:\\sybase\\IQ-15_3\\demo\\iqdemo2.iq'
IQ STORE 
SIZE 100;

This SQL statement adds 200MB of temporary space to the existing iqdemo database:

CREATE DBSPACE iqdemotmp AS
'd:\\sybase\\IQ-15_3\\demo\\iqdemo2.iqtmp' 
IQ TEMPORARY STORE 
SIZE 200 ;

Note:

For additional information about diagnosing potential memory problems, see Sybase IQ Troubleshooting and Recovery Guide > Resource issues.