When running DML commands in multiplex, the visibility of the table rows differs for different table types.
Global scope – All connections on all servers can see the rows.
Server scope – All connections on a particular multiplex server can see the rows.
Connection scope – Only a single connection on a particular multiplex server can see the rows.
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.