How to compare two table layout

rreword · #1 (**permalink**) 09-09-11, 12:58

Hi,

We have 4 different schema in same database, all schema contains similar table structures but we have found some layout differences in some of table.

Is there any command which compare table layout of same table from two difference schema?

This is for DB2 9

Thanks,

rwe

n_i · #2 (**permalink**) 09-09-11, 13:05

Optim Database Administrator has this feature I believe. Possibly Toad as well - check their web site.

smith43017 · #3 (**permalink**) 09-09-11, 13:55

ODA had this option Select the schema and right click on it you have option compare schema.

Quest Toad for db2, DBARTISA's Change manager has this option.

db2girl · #4 (**permalink**) 09-09-11, 16:24

Or you can use db2look to generate DDL for different schemas and then do a "diff" on them.

rreword · #5 (**permalink**) 09-09-11, 21:58

Thanks for reply...Currently we don't have Toad or any other tool... but getting table ddl and doing diff can give me answers..

Thanks for your quick reply...

Internet Services

Web Development

Digital Marketing

Consumer Tech