Dear Fellow Lazy DBAs:

Here is an interesting problem - I'm looking for outside the box solutions.

Imagine you have 8 tables which have identical logical structure and about 99% of the data is the same, but there are some differences - anomalies.  You wish to "merge" this data into a new table eliminating all duplication and consolidating data so that if a row appears even in only one of the 8 tables it will appear in the merged result.

I will add that the tables are quite large - let's say between 1/2 million and a million rows each - and you have to run this job semi-frequently so total elapsed run time is important. Efficiency is very important.  Of course the 8 tables are on separate servers/instances of DB2.

Any takers?

Best, Hal Steiner
________________________________________________________________________
AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.

DB2 & UDB email list listserv db2-l LazyDBA home page