The Data Exchange Agent looks for special audit trail entries to pass on to the Runtime Service. By default, the Data Exchange audit entries are not written to the audit trail. To enable the audit entries to be written to the audit trail, replication must be turned ON for the tables.
Replication can be turned ON and OFF in UREP.
You may turn replication ON and OFF for all tables within a schema or for a single table within a schema.
Note: All CHARACTER and BLOB columns of the table are replicated as 8-bit data. Data Exchange is currently unaware of any CHARACTER and BLOB columns that may contain 9-bit sensitive data.
Turning replication ON for all tables:
To turn replication ON for all the tables in a schema, use one of the following UREP commands:
PROCESS TABLE ALL FOR SCHEMA <SCHEMA NAME> REPLICATE ON.
If a table in the schema already has replication turned ON, this command has no effect and it does not change the replication ON timestamp for that table.
Turning replication OFF for all tables:
To turn replication OFF for all the tables in a schema, use the following UREP command:
PROCESS TABLE ALL FOR SCHEMA <SCHEMA NAME> REPLICATE OFF.
If a table in the schema already has replication turned OFF, this command has no effect and it does not change the replication OFF timestamp for that table.
Turning replication ON for a specific table:
To turn replication ON for a specific table in a schema, use the following UREP command:
PROCESS TABLE <TABLE NAME> FOR SCHEMA <SCHEMA NAME> REPLICATE ON.