Replication of the Adaptive Server drop login command in a
warm standby environment fails if you execute drop login at the
active database to drop a user while the user connection to the standby database is
active.
To ensure that the replication of
drop login can proceed:
- Use sp_who at the active and standby
databases to verify that there is no active session for the
user before you execute drop login at the
active database.
- You can use dsi_fadeout to decrease the
length of time that Replication Server waits for a
connection or all connections to a standby server to be
idle, before Replication Server closes the connections and
prevents user activity. Use dsi_fadeout
with alter connection for a single
connection, or with configure replication
server for all connections.
- You can use suspend connection and
resume connection to restart
connections between Replication Server and the standby
databases to stop user activity.
See:
- drop login in the SAP Adaptive Server
Enterprise Reference Manual: Commands.
- sp_who in the SAP Adaptive Server
Enterprise Reference Manual: Procedures.
- dsi_fadeout, alter
connection, configure replication
server, suspend
connection, and resume
connection in the SAP Replication
Server Reference Manual.