Ignoring replication errors

 To ignore replication errors (SQL)
  • Create a BEFORE trigger on the action that causes the known error. This trigger should signal the REMOTE_STATEMENT_FAILED SQLSTATE (5RW09) or SQLCODE (-288) value.

    For example, if you want to ignore INSERT statement errors that occur when a table is missing a referenced column, create a BEFORE INSERT trigger that signals REMOTE_STATEMENT_FAILED SQLSTATE when the referenced column does not exist. The INSERT statement fails, but this failure is not reported in the SQL Remote Message Agent (dbremote) output log. See Remote statement failed.