The following system procedures simplify multiplex dbspace management:
Procedure |
Purpose |
---|---|
sp_iqmpxcountdbremote |
Returns a count of dbremote connections for a multiplex database. |
sp_iqmpxgetconnversion |
Displays the version number for a specified connection. |
sp_iqmpxreplacewriteserver |
Converts the query server on which it runs into the new write server for the multiplex. |
sp_iqmpxvalidate |
Detects inconsistencies in the multiplex configuration information. |
sp_iqmpxversioninfo |
Displays server type (W for write server, Q for query server, S for single-node mode) and synchronization status. |
sp_iqmpxcfg_<servername> |
Sets up specified query server for SQL Remote replication. |
For details, see Chapter 10, “System Procedures,” in the Sybase IQ Reference Manual and “sp_mpxcfg_<servername> procedure”.