Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 .
1 2 3 4 5 6 7 8 9 10 11 | 10/12 02:54:08. 0000000000 Allocation successful. Dbspace IQ_USER_MAIN I. 10/12 02:54:12. 0000000000 Allocation failed. Dbspace IQ_USER_MAIN is OUT OF SPACE I. 10/12 02:54:12. 0000000000 Allocation successful. Dbspace IQ_USER_MAIN I. 10/12 02:54:17. 0000000000 Allocation failed. Dbspace IQ_USER_MAIN is OUT OF SPACE I. 10/12 02:54:28. 0000000000 Allocation successful. Dbspace IQ_USER_MAIN I. 10/12 02:54:32. 0000000000 Allocation failed. Dbspace IQ_USER_MAIN is OUT OF SPACE I. 10/12 02:54:50. 0000000000 Allocation successful. Dbspace IQ_USER_MAIN I. 10/12 02:54:54. 0000000000 Allocation failed. Dbspace IQ_USER_MAIN is OUT OF SPACE I. 10/12 02:55:10. 0000000000 Allocation successful. Dbspace IQ_USER_MAIN I. 10/12 02:55:14. 0000000000 Allocation failed. Dbspace IQ_USER_MAIN is OUT OF SPACE I. 10/12 02:55:27. 0000000000 Allocation successful. Dbspace IQ_USER_MAIN |
Query to check the Usage space .
1 2 3 4 5 6 7 8 9 10 11 | (DBA)> select substr(DBSpaceName,0,48),Usage%,TotalSize from sp_iqdbspace() substr(sp_iqdbspace.DBSpaceName,0,48) Usage% TotalSize —————————————————————- IQ_SYSTEM_MAIN 21 480G IQ_SYSTEM_TEMP 1 600G IQ_USER_MAIN 83 35.1T (3 rows) Execution time: 44.784 seconds |
To list the dbfiles that are added to IQ_USER_MAIN.
1 2 3 4 5 6 7 8 9 | (DBA)> select substr(DBSpaceName,0,30) DBSpaceName, substr(DBFileName,0,30) DBFileName, substr(Path,0,50) Path, substr(DBFileSize,0,6) DBFileSize from sp_iqfile() where DBSpaceName=’IQ_USER_MAIN’ DBSpaceName DBFileName Path DBFileSize ———————————————————————————— IQ_USER_MAIN IQ_USER_MAIN_001 /dev/raw/raw01 240G IQ_USER_MAIN IQ_USER_MAIN_002 /dev/raw/raw02 240G IQ_USER_MAIN IQ_USER_MAIN_003 /dev/raw/raw03 240G (3 rows) |
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
Sir, Madam,
This is one of the best post for me, thanks very much
Hi Bhaskara,
Do you have more training resource for Sybase IQ?
Best regards,
Sanjib
we have 10 sybase IQ article for now.