(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 Reference: Statements and Options > SQL Statements > ALTER DBSPACE Statement.