Adding Shared Temporary Storage

Distributed Query Processing (DQP) requires temporary storage that all multiplex nodes can share. This task creates a resource on the coordinator that provides temporary storage for the coordinator and writer.

  1. In Folders, expand <localhost>_iqdemo_mpx > iqdemo > Dbspaces.
  2. In the Dbspaces folder, right-click IQ_SHARED_TEMP, choose New > File.
  3. On the Add File(s) dialog, click Add.
  4. Update the File Detail(s) dialog:
    Option Value

    Logical File Name

    Use shared_temp as the logical file name.

    Physical File Path

    Set the path to the <pathname>\MyIQDemo subdirectory and identify the secondary server database file as shared_temp.iqtmp.

    You can unselect This is a raw device to browse to the path, but you must manually enter the file name. The full field value should read:

    <pathname>\MyIQDemo\shared_temp.iqtmp

    Raw device option

    Unselect This is a raw device to display the default File size and Reserve size values.

    File Sizes

    		Update with these values:

    File Size

    300MB

    Reserve Size

    90MB
  5. Click OK to return to the Add File(s) dialog, then click OK > Next > Finish.
  6. On the Files tab, right-click shared_temp, and choose Properties.
  7. Change the Mode to Read/Write.
  8. Click Apply > OK.
Parent topic: Distribute the Workload
Next topic: Increasing the iq_main File Size