Adding a temporary store file (manual method)

This procedure adds a temporary store file for the secondary node. You cannot perform queries on IQ data until you add a temporary store file. You can repeat this step as needed to add additional temporary store files if you require more temporary storage. Both the coordinator node and the secondary node must be running to perform this operation.

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.