By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

Federated databases on different instances on the same machine

P: n/a
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?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.