Hello,

I am moving one database from one machine to another, what I want to do after this move is done, is to validate that all the data and tables are exactly the same in the new and old database, does anyone know of a good tool and or command to compare two DB2 databases.

Thanks,
Dak

What I did:
- run your reports. They must be the same
- random queries: bring everything back to numbers and summarize & compare (i.e. summarize all the "length of" some varchar columns). The result is nonsence, but shoud be exacly the same in both databases.
- smart "greps" on your extract & load reports. Exclude all good-messages until you are left with an readable error-report. I mean: exclude all "rejected 0" messages you you'll see if there are any rejected rows.

Are you using a back up image, or export/import? If it is backup image I would doubt you are going to have any problems. But like Dr_te said, run reports before and after.