CHC0839W

CHC0839W  Table name will be marked idle and mirroring of the table cannot continue.
Reason: reason

Explanation—The identified source table has been altered in Db2® and as a result, mirroring of that table cannot continue. The replication status of the source table is automatically set to Idle. The schema change that prevents mirroring from continuing is identified in the message text. Replication continues for all other source tables being replicated under the same subscription. This message is generated while the table is being mirrored.

Message Variables:

name—The name of the source table for which mirroring cannot continue.

reason—The schema change that prevents mirroring of the source table from continuing. One of the following strings is inserted in the message text at this point:
  • DATA CAPTURE CHANGES has been turned off
  • table DBID, OBID or PSID has changed
  • one or more columns have been removed
  • columns have been renamed, inserted or removed
  • the data type of a column has changed
  • the length or scale of a column has changed
  • a column was added to a table in Db2 version 9.1 Reordered Row Format
  • the table has been renamed

Message Destination—Product administration log

System Action—Mirroring ends for the altered table. Replication continues for all other source tables being replicated under the same subscription.

Operator Response—None

Client Administrator Response—Before you can restart mirroring data from the source table, you must perform one or more of the following operations in Management Console:
  • Re-add the source table
  • Re-describe the source table
  • Reassign the source table.
  • REORG of table space containing the source table
If row updates and deletes are applied to the source table after the schema change and before the re-add or REORG is performed, you must also refresh the source table before restarting mirroring.

For some schema changes, you do not have to perform all of the listed operations. If you require a specific procedure in response to a schema change, contact your database administrator or IBM® representative for assistance. For information about re-adding, describing, assigning, and refreshing tables, see your Management Console documentation. For information about table space REORGs, see the appropriate IBM publication.