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.

StepsAdding a temporary store

  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.