admin logical_status

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.

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