View previous topic :: View next topic
|
Author |
Message |
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
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. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
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. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Guptae,
RC/Migrator, if you have DB2 CA products.
Sushanth |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello All,
Thanks for ur input but the problem is we Dont ahve BMC tool. We have only DB2 Admin tool here. |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
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. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
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. |
|
Back to top |
|
|
|