Sybase IQ runs out of IQ STORE dbspace

Symptom

You need to add another dbspace, if IQ stops processing transactions and the IQ session log (console) reports the following error: ”You have run out of IQ STORE dbspace in database /s1/Sybase/ASIQ-12_6/demo/asiqdemo.db. In another session, please issue a CREATE DBSPACE...IQ STORE command and add a dbspace of at least 8MB.”

Solution

To add another dbspace, execute the following command in Interactive SQL:

CREATE DBSPACE asiqdemo4 AS '/s1/sybase/asiqdemo4.iq'
IQ STORESIZE 500

This command adds 500MB to the database.