Support for DDL Replication in Replication Agent for UDB

Replication Agent for UDB now supports replication of several DDL commands.

create table
alter table (add column)
rename table
drop table

When you create a new table, and if pdb_automark_tables is true, Replication Agent for UDB automatically marks the table for replication.

For automatic marking of tables to succeed, you must manually set the value of the table DATA CAPTURE option to DATA CAPTURE CHANGES in the same transaction as the create table DDL command. Otherwise, Replication Agent for UDB logs an error message in the system log and in the NOCDCERRORTRC trace log for this event, along with the name of the newly created table. Replication Agent for UDB continues replicating all tables that are marked for replication.

To troubleshoot errors when Replication Agent for UDB fails to replicate DDL commands for a newly created table, see Troubleshooting DDL Replication Failure in Replication Agent for UDB in the Replication Agent Administration Guide.