Replication Performance
Fewer Joins between Replication Tables
In DB2 UDB v8.1, many joins between replication control tables have been eliminated, resulting in substantial improvements in performance. Following are the joins that have been removed:
The column IBMSNAP_UOWID is replaced by IBMSNAP_COMMITSEQ in CD tables. The IBMSNAP_COMMITSEQ column allows the Apply program to process certain target table types without having to join the CD table with the UOW table.
CD tables that are not involved in replica scenarios with conflict detection can be pruned without a join. In cases where a join between the CD table and the UOW table is required, the join is made using the IBMSNAP_COMMITSEQ column.
Joins of the CD table and the UOW table are no longer ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
