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
another DB2 database comes along with DB2 8.2 ESE.
2) If my requirement is only to access another DB2 database from my DB2
database, should I create a federated server for that. Or is there any
other method????
Thanks in anticipation.
Baski. 3 3239
Baski wrote: 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 another DB2 database comes along with DB2 8.2 ESE.
To the best of my knowledge federated connectivity to IBM products is
included. You need WS II only when you leave the IBM family.
2) If my requirement is only to access another DB2 database from my DB2 database, should I create a federated server for that. Or is there any other method????
You have to update the FEDERATED setting in the DBM CONFIGURATION to YES.
That should be sufficient.
There are examples for simple federation on developerWorks. Just google
for it.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Hi, 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 another DB2 database comes along with DB2 8.2 ESE.
you can install WebSphere Information Integrator on top of your
existing DB2 UDB. WII is some extension for DB2, if no existing DB2 is
found, one will be installed. The setup of the wrappers can be done in
one installation or at a later time. The wrappers
are contained in the WII setup files. As for DB2 no wrappers are needed,
i'm not sure if the WII package is needed
Then (and perhaps without WII installed) the following command and a
restart of the instance will enable federation support:
UPDATE DATABASE MANAGER CONFIGURATION USING FEDERATED YES
If the remote database are cataloged correctly, the following commands
creates local nicknames for the remote objects:
Create wrapper
CREATE WRAPPER db2 LIBRARY 'libdb2drda.a' (dependent on OS)
Add Server to wrapper
CREATE SERVER REMOTEDB TYPE DB2/UDB VERSION 8.2 WRAPPER DB2 AUTHID
"remoteuser " PASSWORD "****" OPTIONS(ADD DBNAME
'REMOTEDBNAMEFr omCatalog', PASSWORD 'Y')
Create user mapping
CREATE USER MAPPING FOR "localuser" SERVER "REMOTEDB" OPTIONS ( ADD
REMOTE_AUTHID 'remoteuser', ADD REMOTE_PASSWORD '*****')
Create Nicknames
CREATE NICKNAME LOCALSCHEMA.NIC KNAME FOR REMOTEDB.REMOTE SCHEMA.REMOTEOB JECT
You can test then with
SELECT count(*) from LOCALSCHEMA.NIC KNAME
2) If my requirement is only to access another DB2 database from my DB2 database, should I create a federated server for that. Or is there any other method????
Don't know of any other on DB level.
Michael
PS: The installation requires an X-Server. If someone knows, if there is
also a possibility of an automatic installation (response-file,
commandline, whatever) please let me know! This would
be very helpful.
Michael Rudolph wrote: Hi,
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 another DB2 database comes along with DB2 8.2 ESE.
Found in Redbook sg247073 "DB2 II Performance Monitoring, Tuning and
Capacity Planning Guide":
"The DB2 federated server allows you to access and join data from
relational and
non-relational data sources. By setting the database manager configuration
parameter FEDERATED to YES, the DB2 instance (without DB2 II) allows
federated access to other DB2 sources, Informix, and any OLE DB source.
Attention: If you need access to other non-relational or non-IBM relational
sources such as Oracle, Sybase, Teradata, or Microsoft SQL databases as
well as generic ODBC access, then you need to install DB2 II."
So it should be possible without further software like WII.
Cheers Michael This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: RavenCross |
last post by:
we are in need of a game developer rather quickly. Candidates will be
responsible in assisting in all coding from marketing, developing new
games, maintaining and updating existing games in the Space
Federation. Interested candidates can apply and start work anytime
with us.we mostly need still mech pictures. Space Federation is an
endeavor to bring free internet games to the public. With over 290,708
registered players playing daily, we...
|
by: spencer |
last post by:
My client is going through a large project to replace existing data
warehouse physical infastructure which is running DB2 8.1.6. In the
past we had a much more distributed environment where we had certain
portions of the data warehouse on a physically different server. We
utilized federation to allow the joining of tables on seperate
instances. We found that this worked ok in situations where the tables
were not that large say under...
|
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.
|
by: bspdan |
last post by:
Hi - I'm having some federation difficulties and am looking for some
help. On AIX 5.3, I'm running DB2 ESE 8.2 FP12 with Federation
enabled. Oracle client 10.2.0.2. I can connect to a remote oracle
instance using sqlplus, so I'm pretty confident the Oracle client is
OK. I'm able to create a NET8 wrapper, and to create a Server using
that wrapper. Control Center is able to discover all instances listed
in my tnsnames.ora, so I'm...
|
by: zgh1970 |
last post by:
Hi, All,
We have a database on db2 udb aix.
The database has federated server to db2 mainframe.
Now We have already catalog database of db2/400 on the db2 UDB aix
server.
I tried to create new federation server for db2as/400.
It seam has problem.
1. can the db2 mainframe and db/400 have the same wrapper?
Our existing db2 mainframe uses the wrapper with library libdb2drda.a
This wrapper is used by db2 mainframe
| |
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
|
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...
|
by: dif1754 |
last post by:
My Windows DB2 Server 9.x is connected, via federation, to a remote AS/
400 system:
I created several nicknames to remote tables and I can query them.
Problem is, during the night, my remote AS/400 is rebooted and DB2
Server cannot connect back to it.
Is there any DB2 parameter I must set to reconnect automatically to
the remote federated AS/400.
|
by: Kozy |
last post by:
Hello everyone,
I have a problem with federation between Oracle and DB2. Once every few weeks my DB2 federation request "dies". What happens is DB2 thinks it is still geting information from oracle, but on Oracle there is nothing executing. This connection then stays active for undefined amount of time ( 5 days was the last accurance).
Killing the process doesnt work, all I can do to remove it is to restart the server.
Db2stop force...
|
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,...
|
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...
| |
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
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...
| |