Personal tools
You are here: Home Forums DB2 Any one help?
Navigation
Log in


Forgot your password?
 
Document Actions

Any one help?

Up to DB2

Any one help?

Posted by abcd at September 09. 2010

Hi,
 
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. 2010

Hi,


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. 2010

Previously 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. 2010

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 Olivier Windels at September 14. 2010
Hi Kanaka,

I 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. 2010

Hello 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


Powered by Ploneboard
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls