For details about how Sybase IQ 15.2 stores data, see “Configurable tablespaces” in Chapter 1, “Overview of Sybase IQ System Administration” in the System Administration Guide: Volume 1.
Sybase IQ multiplex users need to be aware of the distinction between data managed solely by Sybase IQ and data that is managed by underlying SQL Anywhere software.
Managed by IQ |
Managed by SA |
|---|---|
IQ_SYSTEM_MAIN IQ_SYSTEM_MSG IQ_SYSTEM_TEMP IQ user main dbspaces |
System catalog SA temporary dbspace SA catalog dbspaces |
IQ_SYSTEM_MAIN and IQ user main dbspaces are shared by all multiplex servers, and all servers need access to the same physical file. See “Accessing the shared disk array” for address formats.
Data managed by SQL Anywhere is not shared. Each node needs its own copy of such data.
Each server has its own set of files in IQ_SYSTEM_TEMP and IQ_SYSTEM_MSG.
If you have a small test multiplex with servers on the
same physical host, follow this rule of thumb: To address dbspaces
managed by IQ, use absolute, not relative paths. To address catalog
dbspaces managed by SA, use relative paths, not absolute paths.
