Support for Extended Relative Record Number Values
Support for Extended Relative Record Number Values
To store extended relative record number (RRN) values, PowerExchange 10.5 generates column DTL__CAPXEXRRN instead of DTL__CAPXRRN when creating extract maps for Db2 for i tables. The large RRN values can then be propagated to the target tables.
If you are upgrading to PowerExchange 10.5 and you want to use the new DTL_CAPXEXRRN column, you must create a new extraction map and import it into PowerCenter. Existing extraction maps that have the DTL__CAPXRRN column name are still supported.
If you run the DTLUCBRG or DTLURDMO utility, you might need to import the new extraction map to get the correct definition:
DTLUCBRG creates an extraction map by using the new DTL__CAPXEXRRN column name.
DTLURDMO uses the new DTL__CAPXEXRRN column name if CREATEXMAPS is specified on the REG_COPY statement. If XM_COPY is used to copy an extraction map, the RRN column in the existing extraction map is copied. For an extraction map created with a release of PowerExchange before 10.5, this the DTL__CAPXRRN column. For an extraction map created with PowerExchange 10.5, this is the DTL__CAPXEXRRN column.
For more information, see the "Introduction to Change Data Extraction" chapter in the