Lopikamuna

Video of the DB2 9 7 Overview chat A video of the webcast overview of DB2 9.7 is now available on ChannelDB2. In it, Sal Vella (VP of Development) and Tim Vincent (Chief DB2 LUW Architect) discuss new features such as deep compression and answer audience questions. DB2 9.7 will be released in the near future. Cheers, Leons Petrazickis DB2 Express-C Team download  file  now

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...