Data storage

For details about how Sybase IQ 15.0 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.

Table 1-1: DBspace administration

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.

NoteIf 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.