Displays information about all connections from the Replication Server to data servers and to other Replication Servers.
admin show_connections
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
This command displays information about database connections and routes from the current Replication Server.
Table 3-5 describes the output from this command.
Column |
Description |
|---|---|
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 |
Any user may execute this command.
alter connection, alter logical connection, alter route, create connection, create logical connection, create route, drop connection, drop logical connection, drop route, resume connection, suspend connection
