For DDL to be replicated, the pdb_setrepddl command must be set to enable. If pdb_setrepddl is set to enable, all DDL in your primary database is replicated. Also, you must set the ddl_username and the ddl_password.
DDL replication is not available for IBM DB2 Universal
Database.
To replicate DDL:
Replication Agent requires a unique user name to be supplied that has authority to execute all DDL commands at the standby database.
Replication Server must have a database-level replication definition with replicate DDL set in the definition.
For details about configuration property ddl_username and for database-level replication definition, refer to the Replication Agent Reference Manual.
Enabling replication for DDL in the primary database
Log in to the Replication Agent administration port.
Use the pdb_setrepddl command without an argument to determine if replication is already enabled for DDL in the primary database:
pdb_setrepddl
If the pdb_setrepddl command returns information that replication is enabled, you do not need to continue this procedure.
If the pdb_setrepddl command returns information that replication is not enabled for DDL, continue this procedure to enable replication for DDL.
Use the pdb_setrepddl command to enable replication for DDL:
pdb_setrepddl enable
After replication is enabled for the DDL, you can begin replicating your primary database.
See the Replication Agent Primary Database Guide.
