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.

For example, if a drop logical connection command fails, you may have to force the ID Server to delete from the rs_idnames system table the row that corresponds to the logical database. Logical database connections show an ā€œLā€ in the ltype column.

The sysadmin dropldb command logs in to the ID Server and deletes the entry for the specified logical database. The syntax is:
sysadmin dropldb, data_server, database

data_server and database refer to the logical data server and the logical database names.

You must have sa permission to execute any sysadmin command.