Configuring a Trace Filter Value

To configure the value for a trace filter, specify the trace flag, the filter code and the values to filter on.

You can configure the filter code values that enables data tracing for the Replication Agent objects identified by these codes:
Object Filter Code

table name

TA

schema name

SC

owner name

OW

transaction ID

TR

log record number

LR

operation type

OP

user

US

The permitted values for opertation type are insert, update, or delete.
  1. To configure a trace filter value on the LTITRACELTL flag only for update statements, enter:
    trace_filter LTITRACELTL, OP, UPDATE
    go
  2. To set the trace filter to include both update and delete operations in the LTITRACELTL log, enter:
    trace_filter LTITRACELTL, OP, “update, delete”
    go
    Note: Enter the double quotes for multiple filter values and operation names are case-insensitive
  3. To set the trace filter to include only trace message that contain tables named foo or bar across all trace logs, enter:
    trace_filter all, TA, “foo,bar”
    go