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