When running DML commands in multiplex, the visibility of the table rows differs for different table types.
There are three types of row visibility in multiplex:
Table Type | Data Scope |
---|---|
IQ base | Global |
IQ temporary | Connection |
Global temporary table | Connection |
SA catalog (table created IN SYSTEM) | Server |
SA temporary (table created IN SYSTEM) | Connection |
SAP Sybase IQ copies data in SA catalog tables on the coordinator node to the secondary node catalog store whenever a secondary node is synchronized. The data in catalog store tables is otherwise not related between secondary server and coordinator server instances. After synchronization, local SA table data on the secondary server is lost, because table data from the coordinator overwrites it.