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
