Troubleshooting
Problem
Using IDR CDC for IBM i
1. Deleted the PF (i.e., a table created using CRTPF command) on IBM i.
2. Created a new table using SQL statement: CREATE TABLE XXX after changing a column name.
3. Deleted the table mapping including the deleted table.
4. Re-mapped the table. Then, user was unable to complete the table mapping with DMU0068 error.
Symptom
1. Unable to complete re-mapping of the tables with the error below:
Error:
RA MSG 2007 (DMU0068) Table xxxxxx has been changed since it was selected for mirroring. Help Info - Table xxxxxx in library yyyyyy has been changed since it was selected for mirroring via Transformation Server. Mirroring could not be initiated as requested. Use the "Update Source Table Definition" option to ensure that the current record format is utilized for mirroring and describe the table to the target system again.
Error:
RA MSG 2007 (DMU0068) Table xxxxxx has been changed since it was selected for mirroring. Help Info - Table xxxxxx in library yyyyyy has been changed since it was selected for mirroring via Transformation Server. Mirroring could not be initiated as requested. Use the "Update Source Table Definition" option to ensure that the current record format is utilized for mirroring and describe the table to the target system again.
Cause
The metadata was not cleared; and the information of the deleted tables are kept in the metadata.
Diagnosing The Problem
Unable to complete table mapping.
Resolving The Problem
This issue can be avoided by removing the table(s) no longer needed from catalog as follow:
In Management Console,
1. Select "Configuration" tab,
2. Remove the tables that are no longer needed from Table Mappings in the relevant subscription(s) if it is not done yet,
3. Right click on the relevant Datastore,
4. Click on "Replication tables...", which will display all the tables stored in IDR CDC metadata.
5. Remove the tables that are no longer needed, which is a final step of clearing the metadata.
In Management Console,
1. Select "Configuration" tab,
2. Remove the tables that are no longer needed from Table Mappings in the relevant subscription(s) if it is not done yet,
3. Right click on the relevant Datastore,
4. Click on "Replication tables...", which will display all the tables stored in IDR CDC metadata.
5. Remove the tables that are no longer needed, which is a final step of clearing the metadata.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
11 June 2020
UID
swg21965475