Compare structures in two Subsystems

guptae

Hi All,

We have prepare a subsytem A by gen of another subsystem B.
Would you please advise how can i compare the structure of these two subsytem like Table ,Indexes, Views,Columns. I need to check if any Alter/Change has been done after Generation of DDL .

Currently I am running the sql for catalogue Table like
SYSTABLE, SYSTABLESPACE , SYSINDEX & Views and then Comparing the output.

DB2 Version:V9NFM
Please advise.

GuyC · Posted: Tue Feb 02, 2010 6:56 pm Post subject:

Do you have any tools ?
BMC Change manager does this for you.

I'm sure tools exists to generate a DDL from the catalogue (like OSC). Then you just have to compare the text file.

sushanth bobby · Posted: Tue Feb 02, 2010 7:09 pm Post subject:

Guptae,

RC/Migrator, if you have DB2 CA products.

Sushanth

guptae · Posted: Wed Feb 03, 2010 11:37 am Post subject:

Hello All,

Thanks for ur input but the problem is we Dont ahve BMC tool. We have only DB2 Admin tool here.

Srihari Gonugunta · Posted: Wed Feb 03, 2010 12:35 pm Post subject:

Ekta,
Even from DB2 admin tool, you will be able to generate the DDL. Check for option GEN/DDL from admin tool. Its long time I used it, But I am pretty sure it is available in DB2 Admin tool.

guptae · Posted: Wed Feb 03, 2010 12:37 pm Post subject:

Hello Srihari ,

Thanks BUt I already mention that we already gen the ddl & build new subsytem . Now i want to compare both the subsystem & check if anything has been altered or missed.