Federated databases on different instances on the same machine

[thomasb]

When setting up federation between two databases on the same instance
everything works fine.

When trying to do the same between two databases on different instances
on the same machine I get into trouble.
[IBM][CLI Driver][DB2/NT] SQL1013N The database alias name or
database name "UDB" could not be found. SQLSTATE=42705

"db2 list db directory" gives me

System Database Directory

Number of entries in the directory = 8

....
Database 3 entry:
Database alias = TMASTER
Database name = TMASTER
Database drive = D:\DB2
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

Database 4 entry:
Database alias = TEMPPROD
Database name = TEMPPROD
Node name = TEST
Database release level = a.00
Comment =
Directory entry type = Remote
Authentication = SERVER
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =

.....

Database 7 entry:
Database alias = UDB
Database name = UDB
Database drive = D:\DB2
Database release level = a.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
"db2 list db directory on d:\db2" gives me
Local Database Directory on d:\db2

Number of entries in the directory = 5

Database 3 entry:
Database alias = TMASTER
Database name = TMASTER
Database directory = SQL00003
Database release level = a.00
Comment =
Directory entry type = Home
Catalog database partition number = 0
Database partition number = 0

Database 4 entry:
Database alias = UDB
Database name = UDB
Database directory = SQL00023
Database release level = a.00
Comment =
Directory entry type = Home
Catalog database partition number = 0
Database partition number = 0
I'm trying to create a Server definition in TEMPPROD to access tables
in UDB.

Windows 2003, UDB 8.2 ESE

I have earlier (succesfully) set up federation between UDB and DB2 on
z/OS on the same machine.

I guess the problem is related to "Indirect" and "Remote" but I can't
figure out in what way!

Can anyone of you experts out there tell me?

[Tim]

Hi

You will need to ensure that you catalog the other instance despite the
fact its on the same machine and then catalog the other database under
that instance. So if you have two instances A and B with databases a
and b under each respective instance to create a nickname on a for a
table in b you would have to catalog instance B on A, catalog database
b on A and then at that point you should be able to create a server for
b on a. At least that's what I do on Linux and it works without any
problems for both databases under the same instance, another instance
on the same machine or an instance on a remote machine.

regards
tim