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 d:\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 8 MB.You need to add more dbspace.

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

CREATE DBSPACE asiqdemo4 AS 'd:\sybase\asiqdemo4.iq'IQ STORESIZE 500

This adds 500 MB to the dbspace.

View this book as PDF