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

[biexplorer]

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

[SuperKuper]

"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.