Federated Database - DB2/AIX to DB2/390

Bill Gallagher

Federated Database - DB2/AIX to DB2/390
Hi,

Can anybody point me to a good reference on how to set up a federated
database between DB2 on AIX and DB2 on OS/390? I have not dealt with
federated database at all, so it's all a bit fuzzy to me right now.

TIA,

-------------------------------------------------------
Bill Gallagher
Database Administrator
Information Technology
Infrastructure / Operations
Phoenix Life Insurance Company
860-403-1773
[login to unmask email]



Mindy Hickman

Re: Federated Database - DB2/AIX to DB2/390
(in response to Bill Gallagher)
Check out
http://www7b.boulder.ibm.com/dmdd/library/techarticle/0206purnell/0206purnel
l.html

-----Original Message-----
From: Bill Gallagher [mailto:[login to unmask email]
Sent: Wednesday, December 11, 2002 12:38 PM
To: [login to unmask email]
Subject: Federated Database - DB2/AIX to DB2/390


Hi,

Can anybody point me to a good reference on how to set up a federated
database between DB2 on AIX and DB2 on OS/390? I have not dealt with
federated database at all, so it's all a bit fuzzy to me right now.

TIA,

-------------------------------------------------------
Bill Gallagher
Database Administrator
Information Technology
Infrastructure / Operations
Phoenix Life Insurance Company
860-403-1773
[login to unmask email]








D A

Re: Federated Database - DB2/AIX to DB2/390
(in response to Mindy Hickman)
Hi Bill,
you asked for a reference, but I can give you example I used yesterday to
do this on Windows:

(first you need to have a local database which has FEDERATED option set to
yes and of course you need to have a connection to db2 on os/390 defined on
your aix and the ddcsmvs packages bound)

CONNECT TO SAMPLE;
CREATE WRAPPER DRDA;

CREATE SERVER "GTIDSN1F" TYPE DB2/390 VERSION 7 WRAPPER "DRDA"
AUTHID <os390uid> PASSWORD <os390pwd>
OPTIONS ( NODE 'TCP0000', DBNAME 'GTIDSN1L');

CREATE USER MAPPING FOR <aixuid> SERVER "GTIDSN1F"
OPTIONS( REMOTE_AUTHID <os390uid>, REMOTE_PASSWORD <os390pwd>);

CREATE NICKNAME "rem"."a" FOR "GTIDSN1F"."DADAM"."A";

SELECT * FROM "rem"."a";

Hope this helps,
Daniel

On Wed, 11 Dec 2002 13:38:10 -0500, Bill Gallagher
<[login to unmask email]> wrote:

>Hi,
>
>Can anybody point me to a good reference on how to set up a federated
>database between DB2 on AIX and DB2 on OS/390? I have not dealt with
>federated database at all, so it's all a bit fuzzy to me right now.
>
>TIA,
>
>-------------------------------------------------------
>Bill Gallagher
>Database Administrator
>Information Technology
>Infrastructure / Operations
>Phoenix Life Insurance Company
>860-403-1773
>[login to unmask email]
>
>
>
the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can