admin logical_status

Description

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.
Table 3-4 describes the output columns.

**Table 3-4: 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.