Data Storage

IQ_SYSTEM_MAIN, IQ_SHARED_TEMP, and IQ user main dbspaces are shared by all multiplex servers, and all servers need access to the same physical file.

Each server has its own set of files in IQ_SYSTEM_TEMP and IQ_SYSTEM_MSG.

Dbspace management
Managed by IQ	Managed by SA
IQ_SYSTEM_MAIN IQ_SYSTEM_MSG IQ_SYSTEM_TEMP IQ_SHARED_TEMP IQ user main dbspaces	System catalog SA temporary dbspace SA catalog dbspaces

Data managed by SQL Anywhere is not shared. Each node requires a separate copy of such data. Introduction to SAP Sybase IQ describes the distinction between data managed solely by SAP Sybase IQ and data that is managed by underlying SQL Anywhere® software.

Note: If you have a small test multiplex with servers on the same physical host, follow this guideline: To address dbspaces managed by IQ, use absolute, not relative paths. To address catalog dbspaces managed by SA, use relative paths, not absolute paths.