admin logical

Displays status information for logical connections.

Syntax

admin logical_status [, logical_ds, logical_db]

Parameters

logical_ds – The data server name for the logical connection.
logical_db – The database name for the logical connection.

Examples

Example 1 – This output shows the LDS.pubs2 logical connection in its normal, active state. The current active database is the pubs2 database in the TOKYO_DS data server. The standby database is the pubs2 database in the SYDNEY_DS data server. The TOKYO_RS Replication Server manages the logical connection. Both physical connections are active. No special operations are in progress.

admin logical_status, LDS, pubs2

Logical Connection Name ---------------	Active Connection Name ---------------	Active Conn State ---------	Standby Connection Name -----------	Standby Conn State -----
[109] LDS.pubs2	[115] TOKYO_DS.pubs2	Active/	[116] SYDNEY_DS.pubs2	Active/

Logical
Connection Name
---------------

Active
Connection Name
---------------

Active
Conn State
---------

Standby
Connection
Name
-----------

Standby
Conn
State
-----

[109] LDS.pubs2

[115]
TOKYO_DS.pubs2

Active/

[116]
SYDNEY_DS.pubs2

Active/

Controller RS ---------------------	Operation in Progress -------------	State of Operation in Progress ----------------------	Spid -----
[16777317] TOKYO_RS	None	None

Usage

Use admin logical_status to find the status of logical connections for an active database and a standby database in a warm standby application.
If you do not specify logical_ds and logical_db, admin logical_status displays information about all logical connections controlled by this Replication Server.
Column descriptions for admin logical_status output table describes the output columns.

Column descriptions for admin logical_status output
Column	Description
`Logical Connection Name`	The DBID (database ID) for the logical connection and the logical data server and database names.
`Active Connection Name`	The DBID, the data server, and the database name for the current active database.
`Active Connection State`	A description of the status of the active connection. Can be active, suspended, or suspended by error.
`Standby Connection Name`	The DBID, the data server, and the database name for the current standby database.
`Standby Connection State`	A description of the status of the standby connection. Can be active, suspended, suspended by error, or waiting for marker.
`Controller RS`	The RSID (Replication Server ID) and name of the Replication Server that manages the logical, active, and standby databases.
`Operation in Progress`	A description of the operation in progress. Can be None, Switch Active, or Create Standby.
`State of Operation in Progress`	The current step in the operation.
`Spid`	The process ID for the server thread that is executing the operation.

Permissions

Any user may execute this command.