Any one help?
Up to DB2Any one help?
Posted by abcd at September 09. 2010Hi,
I have two database which reside on two different subsystem respectively.
I would like to generate a list of matching and non matching tables list
And one more is
I need to find out
columns list,indexes list ,views list ,keys list for given 2 identical tables,
Do we have any sql to generate this report from SYSIBM tables.
Thank you in advance.
Re: Any one help?
Posted by Olivier Windels at September 14. 2010Hi,
Are those federated databases or just two independent databases like for instance: one for homologation and the other for production environment?
Olivier
Re: Any one help?
Posted by abcd at September 14. 2010Previously Olivier Windels wrote:
Hi,
Are those federated databases or just two independent databases like for instance: one for homologation and the other for production environment?
Olivier
Hello Mr.Oliver,
yes i have federation setup between 2 identical tables.so i need to compare the objects of the 2 tables using syscatalog information.
Any help is appriciable.
Thanks &Regards
kanaka
Re: Any one help?
Posted by abcd at September 14. 2010Hello Mr.Oliver,
yes i have federation setup between 2 identical
tables.so i need to compare the objects of the 2 tables using
syscatalog information.
Any help is appriciable.
Thanks &Regards
kanaka
Re: Any one help?
Posted by Olivier Windels at September 14. 2010I have no practical experience with federated databases, but I think you'll find what you need in these topics:
- http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg.im.iis.db.fed.overview.doc/topics/cfpint25.html
- http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.swg.im.iis.db.found.conn.fw.opt.doc/topics/rfpapcat.html
Since all the information you need resides in the global catalog, you'll just have to mount your select according to the global catalog views. Just select the information from the local table and the other referenced by its nickname... add a clause like "where not exists" and you should have what's in one and not the other.
Good luck!
Olivier
Re: Any one help?
Posted by abcd at September 14. 2010Hello Mr Oliver,
Do u have any sample code to do such kind of selection?
or do u have any sample SQLs for this case ?(just two independent databases like for instancejust two independent databases like for instance)
if so please provide those i am just checking the different options for starting point.
Regards
kanaka