Dropping 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.