Drop Logical Database Connections

If you are dismantling a warm standby application, you may need to remove a logical database from the replication system.

To do this, drop the standby database, then execute the drop logical connection command. Before you execute the command, you must drop the standby database. See Replication Server Administration Guide Volume 1 > Manage Database Connections > Drop Database Connections for information about dropping physical database connections.

The syntax for drop logical connection is:

drop logical connection to data_server.database

data_server and database represent the logical data server and logical database.

For example, to drop the connection to the pubs2 logical database in the LDS logical data server, enter:

drop logical connection to LDS.pubs2

Drop a Logical Database from the ID Server
When a warm standby application exists in the replication system, logical databases, along with physical databases, data servers, and Replication Servers, are listed in the rs_idnames system table in the RSSD for the ID Server. Occasionally, it may be necessary to remove the entry for a logical database from this system table.

Parent topic: Alter Warm Standby Database Connections