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

Need to setup a federation b/w 2 databases. Please help.

P: 1
Hi,
I am new to DB2.
We recently migrated from Oracle to DB2. And now, I want to setup what we call a DB link (in Oracle) in DB2.

I have done some research / read some posts in this forum already.

And I came to know that we need to setup federated access, create wrappers, create servers and then nicknames.

My question is:
I enabled federation using the command

update dbm cfg using federated yes

But I am having difficulty in understanding wrappers. Can you please help?

OS is Windows XP. DB2 has a single instance called DB2 and I have both of my databases in that instance. One is EDW, the other is EDW_STG.

I need to write queries where EDW tables are joined with tables in EDW_STG.

Specific questions:
1. Am I on the right path with federating, wrapper, server and nicknames?
2. For the above scenario, how do I create wrappers, server and nickname?
3. Am I missing anything?


Thank you for all your assistance and support
Prem
Apr 4 '08 #1
Share this Question
Share on Google+
1 Reply


P: 7
"A wrapper is a mechanism by which a federated server can interact with certain types of data sources." - it simply points to the location where interface modules to the other data source are stored.
Apr 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.