If
the coordinator runs out of space in IQ_SYSTEM_MAIN,
including reserve space, it may abort to prevent database corruption
and you may be unable to start the coordinator normally.
Should the coordinator abort due to lack of space,
start the coordinator in a single node mode using the -iqmpx_sn startup
switch, and add more space by adding file(s) to IQ_SYSTEM_MAIN.
Restart the coordinator normally and synchronize all secondary nodes,
as in the following procedure.
When
the coordinator needs space in IQ_SYSTEM_MAIN,
proceed as follows:
- Shut down all servers in the multiplex.
- Start the coordinator in single node mode using -iqmpx_sn
1:
start_iq @params.cfg mpxtest.db -iqmpx_sn 1 -n mpxnode_c
- To add more space to IQ_SYSTEM_MAIN
with a new file on a raw device, use syntax like the following:
| Platform |
Action |
|---|
| UNIX |
ALTER DBSPACE IQ_SYSTEM_MAIN ADD FILE mymainfile
'/dev/rdsk/c4t600A0B80005A7F5D0000024'
where mymainfile is the logical or chosen
logical name of the new dbfile.
|
| Windows |
ALTER DBSPACE IQ_SYSTEM_MAIN ADD FILE
mymainfile '\\.\PhysicalDrive3'
|
- Restart the coordinator normally, without the -iqmpx_sn
1 switch.
- Synchronize secondary nodes.