CDC Guide for z/OS

Back Next

Replacing a Table with Another Table That Has the Same Name

If you need to replace a table from which changes are captured with another table that has the same name, use this procedure.

Stop SQL changes from being written to the table.

You can set read-only access on the table.

Verify that the DB2 ECCR captured all changes up to the point at which change activity was stopped.

Rename the table from which changes were captured to a different name.

Delete or deactivate the capture registration for the table.

Issue the DB2 ECCR REFRESH command to drop the table from the DB2 ECCR.

Rename the new table to the name of the dropped table that was previously registered for change capture.

Create and activate a capture registration for the newly renamed table.

Issue the DB2 ECCR REFRESH command again to add the newly renamed table to the DB2 ECCR.

Allow change activity to resume on both tables.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.