db structure

Mathew_paul · #1 (**permalink**) 02-01-10, 23:34

hi

is there any way to compare the structure between database for example

production and development region
the structure of production is changed lots of time, but some to the deve servers structure are old,

i do collect a colcount of all the tables in both server and do diff in aix

kindly suggest
regds
Paul

ARWinner · #2 (**permalink**) 02-02-10, 08:23

You can do: "export to outfile.csv of del select * from production.syscat.columns order by tabschema,tabname,colno" and compare/diff the results. Note: you will want to replace the wildcard * I used with the appropriate columns, I was just being lazy.

Andy

Cougar8000 · #3 (**permalink**) 02-02-10, 10:09

Quote:

Originally Posted by Mathew_paul

hi

is there any way to compare the structure between database for example

production and development region
the structure of production is changed lots of time, but some to the deve servers structure are old,

i do collect a colcount of all the tables in both server and do diff in aix

kindly suggest
regds
Paul

What does a COLCOUNT really gives you?

yes both tables have 10 columns, but are those 10 the same?

you have partially answered your question already btw. run db2look on both and then use diff. I have been using it for many yrs to monitor unauthorized changes to DDL and grants.