Adding a temporary store file (manual method)

You cannot query IQ data until you add a temporary store file for the secondary node. Repeat the following step as needed to add additional temporary store files if you need more temporary storage.

The coordinator node and the secondary node must be running to perform this procedure.

1. Use Interactive SQL to connect to the reader.

2. Run the following command, substituting the appropriate file path. The temporary store file path must be a unique path for each server or host. The path may be absolute or relative, as long as the path resolves to a separate physical file for each multiplex server.

   • On UNIX –

     ALTER DBSPACE IQ_SYSTEM_TEMP ADD FILE
     iqdemo_r2_temp 'iqdemo_r2_temp.iqtmp' 
     SIZE 300 RESERVE 300 
     

   • On Windows –

     ALTER DBSPACE IQ_SYSTEM_TEMP ADD FILE
     iqdemo_r2_temp 'iqdemo_r2_temp.iqtmp' 
     SIZE 300 RESERVE 300 
     

Execute sp_iqdbspace ‘IQ_SYSTEM_TEMP’ to confirm that reader now has free temporary space.