Displaying Replicate Connection Information

Use the replicate parameter with admin show_connections to display information on all replicate connections.

For example, at the Replication Server controlling the replicate databases in the IQSRVR data server, enter:
admin show_connections, 'replicate'
You see:
Connection Name        Server       Database   User              
-------------------    ----------   --------   ----------          
IQSRVR.iqdb            IQSRVR       iqdb       db_maint        
IQSRVR.iqdb_conn2      IQSRVR       iqdb       db_maint2
IQSRVR.iqdb_conn3      IQSRVR       iqdb       db_maint3

IQSRVR.iqdb  is the default connection between the Replication Server and the iqdb database of the IQSRVR data server because the connection name matches the combination of the data server and database names.

IQSRVR.iqdb_conn2 and IQSRVR.iqdb_conn3 are alternate connections between the Replication Server and the iqdb database of the IQSRVR data server because the connection name does not match the combination of the data server and database names.

Parent topic: Multi-Path Replication to Sybase IQ