abort switch

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

The abort switch command attempts to cancel the switch active command.
If there is no switch in progress for the logical connection, Replication Server returns an error message.
If the command cancels the active switch successfully, you may have to restart the RepAgent for the active database.
The switch active command cannot be cancelled after it reaches a certain point. If this is the case, you must wait for the switch active to complete. Then use switch active again to return to the original active database.

Permissions

abort switch requires "sa" permissions.