A data correction was made to a table by creating a _new copy OF the original, Inserting the corrected data,
then renaming the original to _old and renaming the _new to the current name.
We do this procedure anytime a data correction is made.
I'm having failures on datamover in the DDL compare step.
The DDLs are identical. The process is done frequently but the Datamover failure is rare.
For example two tables were replaced in the production environment.
2 seperate Datamover jobs failed the next day on DDL compare when copying to dev.
A couple of days later the same two tables were replaced but this time only one of the jobs failed on DDL compare.
A compare using Ultra Edit showed no differences both times.
The Create_timestamp in DBC.tablesv is the only difference I see.
Has anyone had this happen?
setting compare_ddl to false works for me. I believe default is true