System procedures for managing multiplex dbspaces

The following system procedures simplify multiplex dbspace management:

Table 5-8: Multiplex stored procedures

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,” Sybase IQ Reference Manual.