Show TOC

ignore lossLocate this document in the navigation structure

Allows Replication Server to accept messages after it detects a loss.

Syntax
ignore loss
 from <data_server>.<database 
>[to {<data_server>.<database> | <replication_server>}]
Parameters
from data_server.database

Specifies the primary data server and database whose message loss is to be ignored.

to data_server.database

Specifies the destination data server and database for the lost messages.

to replication_server

Specifies the destination Replication Server for the lost messages.

Usage
  • Replication Server detects loss when it rebuilds queues or replays transaction logs in recovery mode.

  • A Replication Server detects message losses on connections to the replicate databases it manages.

  • For warm standby databases, use the logical connection name for <data_server>.<database>, except for losses that Replication Server detects between the active database and the standby database. To ignore these losses, use the physical <data_server>.<database> name.

  • If direct routes exist, the destination Replication Server detects message losses from the source Replication Server. Look in both Replication Server log files to determine whether losses were detected.

  • When a Replication Server detects losses, it accepts no messages on the connection until ignore loss is executed.

  • After ignore loss is executed, a few updates may be necessary before messages begin to flow again.

  • After ignore loss is executed, procedures are required to bring replicated data up to date.

See the Replication Server Administration Guide Volume 2 for detailed recovery instructions.

Permissions

ignore loss requires “sa” permission.