admin show_connections

Syntax

admin show_connections[, 'primary' | 'replicate' | 'logical']

Parameters

primary – Displays information on all primary connections.
replicate – Displays information on all replicate connections.
logical – Displays information on all logical connections.

Examples

Example 1 – 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

Example 2 – 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'
```
You see:
```
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.
Example 3 – 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'
```
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.
Example 4 – Displays all connections to logical databases.
```
admin show_connections, 'logical'
```
You see:
```
Connection Name        Server       Database             
-------------------    ----------   --------          
WS_DS.ws_db            WS_DS        ws_db         
WS_DS.ws_db1           WS_DS        ws_db  
```
where WS_DS.ws_db is the default logical connection and WS_DS.ws_db1 is the alternate logical connection.

Usage

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 Descriptions for admin show_connections Output
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: `active` – the connection is being used `already_faded_out` – the connection is owned and closed `being_faded_out` – the connection is owned and is being closed `closed` – closed connections are not owned by any threads `connecting` – connecting to a server `free` – the connection is open and not owned by anyone `idle` – the connection is owned but is not used `limbo` – connection handles are in a state transition `total` – the total number of connections
`number`	The number of connections of this type
`comments`	A description of the `connection state` field

Permissions

Any user may execute this command.