Data Storage

Understand the distinction between data managed solely by Sybase IQ and data that is managed by underlying SQL Anywhere® software.

See System Administration Guide: Volume 1 > Overview of Sybase IQ System Administration > Data Storage in Sybase IQ and System Administration Guide: Volume 1 > Overview of Sybase IQ System Administration > SQL Anywhere and Sybase IQ.

Dbspace administration
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

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. See Files on Shared Disk Arrays for address formats.

Data managed by SQL Anywhere is not shared. Each node requires a separate copy of such data.

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

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.