Adding shared temporary storage (manual method)

Distributed query processing (DQP) requires temporary space for use by participating multiplex nodes. This method uses Interactive SQL to add temporary space.

New or freshly migrated databases create an empty IQ_SHARED_TEMP dbspace. To enable distributed query processing, add files to this dbspace and make them read-write accessible from all nodes in the multiplex.

1. Start Interactive SQL and connect to the coordinator.

2. Run the ALTER DBSPACE ADD FILE command.

   On UNIX –

   ALTER DBSPACE IQ_SHARED_TEMP ADD FILE
   iqsharedtemp2 '/myiqdemo/iq_shared_temp2.iqstmp' 
   

   On Windows –

   ALTER DBSPACE IQ_SHARED_TEMP ADD FILE iqsharedtemp2 'c:\myiqdemo\iq_shared_temp2.iqstmp'
   

3. Wait for the new file information to propagate to all multiplex nodes. This may take a few minutes.

4. Change the new file to read-write mode:

   ALTER DBSPACE IQ_SHARED_TEMP ALTER FILE
   iqsharedtemp2 READWRITE 
   

   IQ_SHARED_TEMP is configured and your multiplex is ready for distributed queries.