The
IQ_SYSTEM_MAIN dbspace manages important database
structures including the free list, which lists blocks in use.
Before adding space to IQ_SYSTEM_MAIN, shut down secondary nodes. Active
secondary nodes shut down automatically if a dbfile is added to IQ_SYSTEM_MAIN. The IQ message file
for the secondary node reports:
Multiplex secondary node shutting down
due to a file added to the IQ_SYSTEM_MAIN dbspace.
This node must be synchronized and restarted.
This behavior applies only to the IQ_SYSTEM_MAIN dbspace. Other dbspace operations
cause no disruption and all nodes in the multiplex continue to run.
When updating IQ_SYSTEM_MAIN:
- If any shared IQ main dbspace files have paths inaccessible from a secondary
node, that secondary node cannot access the file or any contents of that file
until the path is corrected.
- ALTER DBSPACE ALTER FILE RENAME PATH is prohibited on IQ_SYSTEM_MAIN.
After adding new files to IQ_SYSTEM_MAIN,
synchronize and restart secondary nodes.