Comparing DB2 Databases

Hi,

I have four DB2 v82 enterprise server (v81 fp11) databases that are all restores of the same backup image, housed on separate machines.

I ran some random statements on them (the same random statements were run against all of the databases, however).

The problem is that I do not have the log of the results of the random statement and I noticed that due to space issues on the machines, some of the statements may/may not have excecuted similarly accross all boxes.

The question I have is whether there is a way for me to see if the two database are exactly the same, that is they contain the same tables, indexes, procedures, the works.

I was thinking of doing md5checksums on all the files for the database in all the tablespaces and checking if any of the md5sums are different, but I am not sure if this is fool proof.

Any suggestions/help is greatly appreciated.

Thank you!

Mansoor

generate ddl using db2look on both the databases and compare the output.