pdb_automark_nocdc_error

(IBM DB2 UDB only) Specifies whether to stop replication if DDL replication and automark are enabled but the table data capture is not enabled in the same create table DDL transaction.

Default

False

Values

true – Stops replication if DDL replication and automark are enabled but the table data capture is not enabled in the same create table DDL transaction.

false – Does not stop replication if DDL replication and automark are enabled when the table data capture is not enabled in the same create table DDL transaction.

Comments

  • Change the pdb_automark_nocdc_error parameter value only when Replication Agent is in the Admin or Replication Down state.
  • When pdb_automark_nocdc_error is true, Replication Agent stops all replication processing and goes to the Replication Down state if:
    • automark is enabled, and
    • Replication Agent processes a create table DDL command for which data capture is not enabled in the same create table transaction.
  • When pdb_automark_nocdc_error is false and automark is enabled, a warning message is logged if Replication Agent processes a create table DDL command for which data capture is not enabled in the same create table transaction.

    The warning message indicates that the newly created tables are not marked for replication. Check the NOCDCERRORTRC log file in the Replication Agent log directory to manually mark the tables for replication using pdb_setreptable.