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.

Hi,

Are those federated databases or just two independent databases like for instance: one for homologation and the other for production environment?

Olivier

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

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

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

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