Familiarize yourself with requirements before updating IQ_SYSTEM_TEMP dbspaces.
When updating IQ_SYSTEM_TEMP:
- Create, alter, and drop temporary dbspace files only from the node
where they reside. The syntax for these commands is the same as for
simplex temporary dbspaces.
- Secondary servers must be synchronized before you run ALTER DBSPACE
ALTER FILE RENAME PATH. Synchronization happens automatically through TLV log replay, but there may be a time delay of up to two minutes between the previous dbspace operation on this dbspace (create or alter) and when you can run ALTER DBSPACE ALTER FILE RENAME PATH. If
secondary servers are not synchronized, you may see a “Command not
replayed” error.
Before updating dbspaces, see the overview of dbspaces and
dbfiles in System Administration Guide: Volume 1 > Overview of System Administration > Data Storage in Sybase IQ.