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

Schema Verification

When the DB2 ECCR captures the first change record for a DB2 table, the ECCR verifies that the table schema in the DB2 catalog matches the schema in the corresponding PowerExchange capture registration.

The schema verification routine does not access the DB2 catalog. Instead, the routine uses the internal PowerExchange tables that were created from the DB2 catalog when you started the DB2 ECCR.

If the DB2 table schema in the catalog matches the schema in the activated registration, capture processing continues.

If the DB2 table schema in the catalog does not match the activated schema registration, the verification routine prints a report and the DB2 ECCR ABENDs.

You can request that the DB2 ECCR also run this schema verification routine at startup by specifying the CHKSCHEM statement in the RUNLIB member to which the REPL2OPT DD statement in the ECCR JCL points.

Managing DB2 Schema Changes

Sample Schema Verification Report and Abend Messages

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal