Unanswered: How to compare two tables from two different databases?
Using DB@ v8.1 on windows 2000.
I have two database serves. Both the databases on two database servers. Both have same structure and synchronising each other. I need to verify whether both the database tables have same data after synchronization. Can I have solution from any one?
In local database you can see the remote tables from remote database as thay would be in your local database - this is federated database.
If you are trying to compare two tables from two DB2 databases then all the products you need is DB2. If you would like to compare two tables from diffrent databases like DB2 and Oracle you need product IBM Information Integrator. As I see you probably have DB2 on bouth servers so DB2 is only what you need.