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.
Prerequisites
- You have the SAP Sybase IQ MANAGE ANY DBSPACE system privilege.
- The SAP Sybase IQ resource
is authenticated and running.
Task- In the Perspective Resources view, select
<localhost>_iqdemo_mpx and select .
- In the left pane, select .
- Click the arrow next to DB Files and select
New.
The Create DB File Wizard appears.
- On the DB Files page, select the resource <localhost>_iqdemo
(the coordinator) and the dbspace IQ_SHARED_TEMP.
- Click Add.
- On the DB File Details page, specify:
| Option |
Description |
|---|
|
Logical name
|
User-defined name of the dbfile. Use shared_temp.
|
|
Path to physical file on disk
|
Path to the physical file on disk. Enter the value
<pathname>/myiqdemo/shared_temp.iqtmp.
|
|
Raw device
|
Click to unselect the check mark.
|
|
File size
|
300MB.
|
|
Reserve size
|
90MB.
|
|
Mode
|
Select Read/Write.
|
- Click
OK to return to the DB Files page, then click
Finish.
The right pane in the Administration Console lists the new
shared_temp file.