Many customers who use change data capture in production environments need to register hundreds of tables for capture. Using the PowerExchange Navigator to create and manage large numbers of registrations is not practical. The DTLUCBRG utility enables you to create and manage registrations in bulk.
This utility can perform the following tasks:
Adds capture registrations and extraction maps. The utility creates registrations and extraction maps at specified PowerExchange Listener locations for a set of tables or data maps. You can use a mask to limit the registrations created.
Generates before-image columns and change-indicator columns in the extraction maps as needed.
Modifies inactive or active registrations.
Performs a test run to report on the scope of the registrations before actually creating them.
For Microsoft SQL Server sources, changes the status of multiple registrations in one operation and also deletes and rebuilds the associated SQL Server publications. This feature is useful if you need to reset the status of mulitple registrations, or if you need to re-create registrations and regenerate publications because you made DDL changes to a large number of tables.
DTLUCBRG creates all registrations with a version of 1. The utility cannot set the registration status to history and then create a subsequent version of the registration.