473,799 Members | 2,924 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

1 New Member
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
1 1656
SuperKuper
7 New Member
"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

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

Similar topics

39
2905
by: Scotter | last post by:
Okay I think my title line was worded misleadingly. So here goes again. I've got quite 20 identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: (a) sync all MDB designs (and/or data) designated to match one I've added some fields/tables to OR (b) go into all designated MDBs and create new...
9
2807
by: Joost Kraaijeveld | last post by:
Hi all, I have 1 database that is required for several applications (the data must be shared ). They also have there own database. Is it possible to combine 2 databases into 1 database in DB2 7.x? -- Joost Kraaijeveld Askesis B.V. Molukkenstraat 14
8
5061
by: hikums | last post by:
By mistake, posted in informix group..Here it is now... On Windows: In db abc: 1. create wrapper drda (LIBRARY LIBDB2DRDA.a not available in windows box) 2. CREATE SERVER "AIX" TYPE DB2/AIX VERSION 8.1 WRAPPER "DRDA" AUTHORIZATION xxxxxxxx PASSWORD xxxxxxxx OPTIONS ( DBNAME 'DFP' ); 3. If the above steps are through, probably user mapping/nicknames are
0
1687
by: Henry Reardon | last post by:
I just installed DB2 Personal Developer's Edition V8.2 (FP7) over my old DB2 V7.2 instance but I'm having some problems. Can anyone help? The first problem is that my migration didn't go too well. I got this during the setup wizard: The migration of the instance "DB2" has failed. The return value is "-2". When I looked at the databases in the Control Center, they all seemed to be there, including the ones created during the install...
3
1855
by: BobTheDatabaseBoy | last post by:
can't find in the RedBook, or scouring this NG, a simple yes/no answer to the question: given mountains of existing COBOL programs which have read/written to multiple schemas, but in one z/OS(v7) instance, whether Information Integrator exists for that platform, and would allow reading/writing to schemas in multiple instances. the doc reads (to me) like II sends all data through an LUW instance.
3
3237
by: Baski | last post by:
Hi, I have few questions, 1) I have DB2 8.2 ESE, with a db2 instance and a few databases. Is it posiible to create and configure a federated server. what are the things/steps required to do so. For federation server should I have additional tool called Information Integrator or can I do without it? Does the Wrapper to connect to
5
1957
by: BobTheDataBaseBoy | last post by:
A client has 390/V7 and UDB/V8. It would be useful to use row_number() when selecting from 390, but that's not supported. It occurs to me (I'm not in CubeLand, and anyway we upgraded to V8 on z/OS) that federation (on UDB/V8) might support functions on those 390/V7 tables. Is this known? thanks
0
2047
by: vbace2 | last post by:
Using DB2 v9.1 fixpak 2 (WSE with HADR feature) on Windows 2003 Servers We are trying to set up HADR for two production databases. The two primary databases reside on two different servers. We would like to put the two standby databases on the same server. One of the databases (we will call it NICKNM) has tables federated from the other database (we will call it OTHER). I was able to set up HADR for these two databases so that the...
5
5961
by: mitrofun63 | last post by:
Hi, All In the first place sorry for mu english. I'm trying to integrate DB2 9.1.3 (with WebSphere Federation Server Relational Wrappers installed) and PostgreSQL 7.4 on SLES9 box I have configured the unixODBC library for access to Postgre database, is worked normal (test connect and select from test table via tool / usr/bin/isql is fine)
0
9685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9538
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10473
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10249
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7563
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6804
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5584
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3755
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.