Log Settings Dialog

Write a warning on multiple updates/deletes

True by default so that warnings are written to the log for update or delete operations that update more than one field. The warning is useful because it notifies you that there may be issues with primary key field settings which do not uniquely identify records. Disable this warning in cases where a trigger is attached to the field being updated or deleted, and that trigger also updates other fields. In this case, the log could quickly fill with warning messages for a behavior that is intentional.

Write a warning on IBM i/AS400 member operations

Relevant only when using IBM Db2 for i (AS/400) as a source database. False by default. When set to true, any operation performed on members will generate a message in the Replication Agent log.

NOTE: This flag was previously Write a warning on member reorganize The earlier behavior is included in the new functionality.

Write a warning on insert attempt

True by default. Adds a warning to the Syniti DR log when an attempt is made to insert a record not found while trying to do an update.

Write a warning on update attempt

False by default. Adds a warning to the Syniti DRlog when an attempt is made to update a record following a duplicate key error

Continual messaging in recovery

True by default. When set to true, error messages are written to the log even during recovery.

Write an error on schema change

True by default. When set to true, an error message is written to the log when an ALTER TABLE has been executed on a replicated table. It is highly recommended that you keep this option enabled so that you can detect table changes and thereby avoid or quickly repair replication errors.

Opening the Log Settings Dialog

  1. In the Management Center Metadata Explorer, choose Replication Agent Options.

  2. In the Replication Agent Options dialog, switch to the Log tab.

  3. Click Settings in the Log tab to open the Log Settings dialog.