CDC Guide for z/OS

10.5
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Recovering from Unplanned Schema Changes to DB2 Source Tables

If schema changes were improperly made to DB2 source tables in a CDC environment, the DB2 ECCR might abend when it reads the first change record for the table after the schema change is made.

When the DB2 ECCR abends, it writes the following messages to the EDMMSG data set:

PWXEDM177511E Table 'creator.table_name' Schema verification failed.
PWXEDM172807E ABEND issued by schema verification, Abend code=3680, Reason code=10040001. [additional_text]

To prevent this problem, make schema changes by following the procedure in Changing the Schema of DB2 Source Tables.

If you use PowerExchange Condense, ensure that PowerExchange Condense has processed all of the captured changes. Then, shut down PowerExchange Condense.

Extract all of the changes to the target.

Delete the capture registration and extraction map.

Create a new capture registration that uses the new schema.

Issue the DB2 ECCR REFRESH command so that the ECCR can use the new registration based on the changed schema.

Warm start the DB2 ECCR.

Restart any extraction processes and, if applicable, PowerExchange Condense.

Managing DB2 Schema Changes

Changing the Schema of DB2 Source Tables

Download Guide

Watch

Comments

Communities