CHC0860E

Table owner.table has been altered and replication will end. Reason: reason

Explanation—The identified source table has been altered in DB2® and as a result, mirroring of that table cannot continue. Mirroring of the subscription will end. The schema change that prevents mirroring from continuing is identified in the message text. This message is generated while the table is being mirrored.

Message Variables:

owner—The owner of the table.

table—The name of the table.

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 clone table has been added
  • the table has been renamed

Message Destination—Product administration log

System Action—Mirroring ends in error.

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.