abort switch

Description

Aborts the switch active command, unless Replication Server has gone too far in the active switch process to abort it. The switch active command changes the active database in a warm standby application.

Syntax

abort switch for 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

Replication Server has gone too far in the active switch process to cancel. Wait for the switch to complete and enter another switch active command to return to the original active database.

abort switch for LDS.pubs2
Switch for logical connection LDS.pubs2 is beyond the
point where it can be aborted. Abort command fails.

Example 2

Replication Server has aborted the active switch. The active database has not changed.

abort switch for LDS.pubs2
Switch for logical connection LDS.pubs2 has been aborted.

Usage

Permissions

abort switch requires "sa" permissions.

See also

switch active, admin logical_status, wait for switch