Displays information about all connections from the Replication Server to data servers and to other Replication Servers.
admin show_connections[, 'primary' | 'replicate' | 'logical']
Displays connection data for this Replication Server.
admin show_connections
Server User Database ------ ---- -------- SYDNEY_DS pubs2_maint pubs2sb SYDNEY_RS SYDNEY_RS_rsi NULL State Owner Spid ----- ----- ---- already_faded_out DSI 89 active RSI 53 connection state number comments ---------------- ----- -------- connecting 0 in the process of connecting to a server active 2 established connections owned and used by threads idle 0 established connections owned but not being used being_faded_out 0 idle connections that are being closed already_faded_out 0 idle connections that have been closed free 1 established connections not owned by any threads closed 61 closed connections not owned by any threads limbo 0 connection handles in state transition total 64 total number of connection handlers available
Displays all connections to primary databases.
For example, at the Replication Server controlling the primary databases in the SALES_DS data server, enter:admin show_connections, 'primary'
Connection Name Server Database User ---------------- ---------- --------- ---------- SALES_DS.pdb SALES_DS pdb pdb_maint SALES_DS.pdb_conn2 SALES_DS pdb pdb_maint
SALES_DS.pdb is the default connection between the Replication Server and the pdb database of the SALES_DS data server because the connection name matches the combination of the data server and database names.
SALES_DS.pdb_conn2 is an alternate connection between the Replication Server and the pdb database of the SALES_DS data server because the connection name does not match the combination of the data server and database names.
Displays all connections to replicate databases.
For example, at the Replication Server controlling the replicate databases in the FINANCE_DS and NY_DS data servers, enter:admin show_connections, 'replicate'
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.
Displays all connections to logical databases.
admin show_connections, 'logical'
Connection Name Server Database ------------------- ---------- -------- WS_DS.ws_db WS_DS ws_db WS_DS.ws_db1 WS_DS ws_db
This command displays information about default and alternate database connections and routes from the current Replication Server.
Column descriptions for admin show_connections output table describes the output from this command.
Column |
Description |
---|---|
<Connection Name> |
The name of default, and alternate primary or replicate connections originating from this Replication Server |
<Server> |
The name of the data server or Replication Server to which this Replication Server is connected |
<User> |
The login name for this client |
<Database> |
The name of the database to which this Replication Server is connected (null for routes) |
<State> |
The state of this connection |
<Owner> |
Indicates the owner of the thread. One of these: DSI – Data Server Interface (to a database) RSI – Replication Server Interface (to a Replication Server) |
<Spid> |
Unique identifier for this thread |
<connection state> |
One of these values:
|
<number> |
The number of connections of this type |
<comments> |
A description of the <connection state> field |