Federated Server

Rosina Porco

Federated Server
Hi

We are evaluating the possibility of purchasing IBM Websphere Federated
Server v9.1

as the solution to integrate multiple data sources , DB2 z/0s v 7,
Oracle , MSsql .



I was wondering if any one has had any experience with this , and is
willing to share it .

Installation tips/difficulties you may have encountered , Security
issues , response time issues .



Do you strictly use Stored procedure to update the other Data source ,
or do you issues direct updates from within your main code.



Any advise is helpful



Thanks



Rosie Porco : [login to unmask email]
Database Administrator, CCS
University of Ottawa
Tel. (613) 562-5800 x1397 Fax (613) 562-5998




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Carol Hynes

Re: Federated Server
(in response to Rosina Porco)
Hi Rosina,
We implemented Websphere Federated Server back when it was called
Db2 Information Integrator about 3 years ago. We use it to
retrieve/update Oracle data from mainframe CICS and COBOL Batch
programs. We use both DB2 stored procedures and DB2 batch programs.
When we implemented, you could not update Oracle from a CICS
application, so we did a work-a-round by having the CICS transaction
submit a batch program to complete the updates. That should not be a
problem with V9, but it's unlikely we will change the applications that
are already working.
I downloaded and installed V9 on a test server a few months ago. We
have it up and running successfully in Dev with plans to install for
Acceptance and Education environments in December and production most
likely in March of 07.
Just a couple of gotchas for us. The documentation refered to by a
hyper link in the download didn't exist. The documentation I found,
implied, if you were installing on a new server without an existing DB2,
it would install DB2 first then install the federated server pieces.
That didn't work. We had to first install Db2, then install the
federated server and check "work with existing" in order to get it
installed. We also had a minor problem when we upgraded from the Oracle
9 client to the Oracle 10 client. The directory structure for the
Oracle Client changed with R10 and I did not have the tpnames file
updated correctly. Other than that, it's been very smooth.
At this point we are not using any of the new features, just making
sure the new release works with the applications we had under Db2/II 8.1
SP5. If you'd like more info, feel free to email me.

Carol

_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Rosina Porco
Sent: Monday, December 04, 2006 9:55 AM
To: [login to unmask email]
Subject: [DB2-L] Federated Server



Hi

We are evaluating the possibility of purchasing IBM Websphere Federated
Server v9.1

as the solution to integrate multiple data sources , DB2 z/0s v 7,
Oracle , MSsql .



I was wondering if any one has had any experience with this , and is
willing to share it .

Installation tips/difficulties you may have encountered , Security
issues , response time issues .



Do you strictly use Stored procedure to update the other Data source ,
or do you issues direct updates from within your main code.



Any advise is helpful



Thanks



Rosie Porco : [login to unmask email]
Database Administrator, CCS
University of Ottawa
Tel. (613) 562-5800 x1397 Fax (613) 562-5998



------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm