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 FINANCE_DS and NY_DS data servers, enter:
admin show_connections, 'replicate'
You see:
Connection Name        Server       Database   User              
-------------------    ----------   --------   ----------          
FINANCE_DS.fin_rdb     FINANCE_DS   fin_rdb   rdb_maint        
NY_DS.ny_rdb_conn2     NY_DS        ny_rdb    rdb_maint

FINANCE_DS.fin_rdb is the default connection between the Replication Server and the fin_rdb database of the FINANCE_DS data server because the connection matches the combination of the data server and database names.

NY_DS.ny_db_conn2 is an alternate connection between the Replication Server and ny_rdb database of the NY_DS data server because the connection name does not match the combination of the data server and database names.

Optionally, use the rs_databases system table to list both default and alternate connections to the Replication Server.

Parent topic: Multiple Connections to the Replicate Database