federation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Baski - 01 Mar 2006 12:08 GMT

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.

Reply to this Message

Serge Rielau - 01 Mar 2006 13:14 GMT

> Hi,
>
[quoted text clipped - 7 lines]
> 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

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Michael Rudolph - 01 Mar 2006 16:39 GMT

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
[quoted text clipped - 3 lines]
> 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
'REMOTEDBNAMEFromCatalog', 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.NICKNAME FOR REMOTEDB.REMOTESCHEMA.REMOTEOBJECT

You can test then with
SELECT count(*) from LOCALSCHEMA.NICKNAME

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

Reply to this Message

Michael Rudolph - 22 Mar 2006 13:46 GMT

> Hi,
>
[quoted text clipped - 5 lines]
>> 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

Reply to this Message