Wednesday , April 24 2024

Adding Space to Sybase IQ server


Adding Space to Sybase IQ server

Little background about IQ space.

In IQ 15.0
Dbspace != dbfile
Under one dbspace we can have many dbfiles
dbspace is more like segment in ASE .

if IQ_USER_MAIN is out of space we can see these messages in iqmsg log file .


Query to check the  Usage space .


To list the dbfiles that are added to IQ_USER_MAIN.


In the above case we have three dbfiles already added to IQ_USER_MAIN . if we plan to add space then we can add IQ_USER_MAIN_004 .
if it is a raw device we have to work with Unix team to create it with the size we want .

Adding space to IQ Coordinator in a Multiplex environment .
1-    It is always a good idea to take a downtime window and add the space as we normally add more TB’s of space.
2-    For Multiplex environment it is recommended to Shutdown reader nodes (eg: reader1,reader2 or writter1 & 2…)
3-    Login to Coordinator and add new data files:

alter dbspace IQ_USER_MAIN add file IQ_USER_MAIN04  ‘/dev/raw/raw604’ size 240GB;

4-    Start Reader1/writer1  & Reader2/writer2 – start_sync



About Bhaskara Vasamsetti


  1. Sir, Madam,

    This is one of the best post for me, thanks very much

  2. Hi Bhaskara,

    Do you have more training resource for Sybase IQ?

    Best regards,


Leave a Reply

Your email address will not be published. Required fields are marked *