Hi,

Can anybody give me all the steps needed to create a federated database and how to access data from such a database.

We have UDB 7.1 on Linux. The server name is DEVT.

I have 2 databases DEVPGM and DEVPLD and I want to write a select statement joining the tables from these 2 databases.

I tried :
Creating wrappers : Success
Creating Server : It says the node name is not valid
what are the other steps involved ?

Thanks

We ran into the same situation with DB2 Ver 7 on Windows. Since the default to Instance isn't in the node directory it can't locate the Node. So what we did is catalog another node on the same server and then catalog the databases to that node and referenced them.

Are those 2 databases create on the same machine?

What were the commands you used to create the federation?

You may as well catalog it as a local node ..

Thank you all for the replies...

The 2 database are on same machine created with commands like :

Create database devpgm on '/database/...../.../devpgm' catalog...

and the commands used for creating federation are :
Creating wrappers 'CREATE WRAPPER DRDA' : Success
Creating Server 'CREATE SERVER "DEVMF4" TYPE DB2/390 VERSION 7.1 WRAPPER "DRDA" AUTHID valid_id PASSWORD valid_passwd OPTIONS ( NODE 'MSNODE', DBNAME 'DEVPLD' ) : It says the node name is not valid
Are there any other steps involved ?


Sathya : How do I catalog it as a local node ? And after that how do I access data ?

Thanks

Just as you catalog a remote node as tcpip, you may catalog a local node

db2 catalog local node <nodename>

Then you should be able to use the node just as you would any remote node ..

If I understand right, cataloging as local node will continue using inter process communications which will not be the case for a tcpip node


HTH

Sathyaram