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 member reorganize

Relevant only when using IBM Db2 for i (AS/400) as a source database. False by default. When set to true, a warning will be recorded in the Syniti DR log if RGZPFM (reorganized physical member) is executed on a table.
When an RGZPFM command is executed on an IBM Db2 for i table, the physical space used by the table is reorganized in order to compact the table and use empty slots. The consequence of this operation is that the RRN sequence is changed among records. If you rely on RRN for your replication, for example by using the RRN as source primary key, this warning would notify you of a reorganization so that you can run a full refresh from source to target table to keep your data consistent.

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.