Show TOC

admin show_connectionsLocate this document in the navigation structure

Displays information about all connections from the Replication Server to data servers and to other Replication Servers.

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.

Table 1: 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.

Related Information