Using ASNTDIFF and ASNTREP utilities to sync the data between source and target tables in DB2 Q replication
Using ASNTDIFF and ASNTREP utilities to sync the data between source and target tables in DB2 Q replication When you observe that there are some data differences between source and target tables in DB2 Q replication, we can use these 2 utilities( asntdiff, asntrep ) which can compare the source and target and repair them based on our requirement to synchronize the data. ASNTDIFF : asntdiff utility which can compare two relational tables and generate a list of differences between the two. ASNTREP : asntrep utility will syncronize a source and target table by repairing differences between the two tables. Important note : Its always good to synchronize the tables when there is less amount of activity or no activity going at source so that we can have perfectly synchronized table. Below tutorial demonstrates the use of asntdiff to compare the source and target and asntrep to repair the target table based on differences generated by asntdiff. Below is the data populated o...
