Adding a Temporary Dbfile

You must add a temporary dbfile to IQ_SYSTEM_TEMP on a newly added server.

Prerequisites

All IQ main store file paths must be absolute or relative in a way accessible to all servers in the multiplex.

Task

Start Interactive SQL and connect to the secondary multiplex node:
```
dbisql -c "uid=DBA;pwd=sql;eng=mpxnode_w1;links=tcpip{port=2957}"
```
Add the temporary dbfile in Interactive SQL using the ALTER DBSPACE statement.
(Secondary servers do not allow CREATE DBSPACE.)
```
ALTER DBSPACE IQ_SYSTEM_TEMP ADD FILE mpxnode_w1_temp 'w1_temp1.iqtmp' SIZE 500
```
Starting the server creates a message log for you, but you must create the temporary store file yourself. You must connect to the secondary server to add a temp store file for that server. Adding temporary store files in multiplex always adds a file specifically to the server to which you are connected. You can start the server, but cannot run IQ queries until a temporary store is added.

For command reference details, see ALTER DATABASE in Reference: Statements and Options.
Run sp_iqmpxvalidate to make sure that no errors are reported on this server.