DB2 Version 10.1 for Linux, UNIX, and Windows

log_ddl_stmts - Log Data Definition Language (DDL) statements database configuration parameter

This parameter specifies that extra information regarding Data Definition Language (DDL) statements will be written to the log.

Configuration type
Database
Parameter type
Configurable Online
Propagation class
Immediate
Default [range]
No [Yes; No]

The default setting of the log_ddl_stmts configuration parameter avoids the overhead of writing extra log records for DDL operations. Set this parameter to YES if you need to replicate DDL operations and a replication capture program is used to capture changes from the log.