DB2 v5 mvs to oracle AIX rs6000

N. - Neil - Briggs

DB2 v5 mvs to oracle AIX rs6000
Hello All,

Can anybody please advise me as to the best way to "push/pull" data from a
DB2 subsystem version 5 running on os390 to Oracle running on a unix rs6000.

I have currently got jobs set up that unload the data from the DB2 tables to
sequential flat files which are then sent to the rs6000 box via tcp/ip.
Using this approach I cannot vouch for the consistancy of the data if there
is a problem with the tcp/ip transmission.

I wolud like to know if there is a similar way to have the 2 DBMS connect to
each other similar to DB2 to DB2 using DRDA. I have read about DB2's CLI
that is able to communicate to ODBC, is this an approach worth trying?

The data is to be transferred by a batch process once a day to a not so
critical system, so there is reluctance from the management to spend money
on purchasing products such as data joiner and Oracles gateway.

I am really in the dark about this, so if anybody can shed any light, I
would be very grateful.


Regard
Neil Briggs

Ed Long

Re: DB2 v5 mvs to oracle AIX rs6000
(in response to N. - Neil - Briggs)
We have similar activities and have tried several options.
1: Tape. This is our default.
2: DB2 connect looks like our next option.
3: Neon has a product as well.
4: We have not had many problems with FTP at all.
You don't specify how much data, Is it Gb. or Terabytes?

> -----Original Message-----
> From: Briggs, N. - Neil - [SMTP:[login to unmask email]
> Sent: Friday, October 08, 1999 6:50 AM
> To: [login to unmask email]
> Subject: DB2 v5 mvs to oracle AIX rs6000
>
> Hello All,
>
> Can anybody please advise me as to the best way to "push/pull" data from a
> DB2 subsystem version 5 running on os390 to Oracle running on a unix
> rs6000.
>
> I have currently got jobs set up that unload the data from the DB2 tables
> to
> sequential flat files which are then sent to the rs6000 box via tcp/ip.
> Using this approach I cannot vouch for the consistancy of the data if
> there
> is a problem with the tcp/ip transmission.
>
> I wolud like to know if there is a similar way to have the 2 DBMS connect
> to
> each other similar to DB2 to DB2 using DRDA. I have read about DB2's CLI
> that is able to communicate to ODBC, is this an approach worth trying?
>
> The data is to be transferred by a batch process once a day to a not so
> critical system, so there is reluctance from the management to spend money
> on purchasing products such as data joiner and Oracles gateway.
>
> I am really in the dark about this, so if anybody can shed any light, I
> would be very grateful.
>
>
> Regard
> Neil Briggs

James Campbell

Re: DB2 v5 mvs to oracle AIX rs6000
(in response to Ed Long)
Hi Neil,

We use FTP for a similar process. If you are worried about integrity,
write a little CRC generator. Run it on the MVS side, FTP the CRC value
to the unix side (this also make a conveient "all the data has been
sent" indicactor if needed) and rerun the CRC (of course, you'll have to
take the EBCDIC to ASCII conversion into account) on the unix side and
compare it to the MVS CRC check. If they match, good; if not, not.

/* standard disclaimer */
James Campbell
DBA
Hansen Corporation, Tooronga
+61 3 9261 1802
[login to unmask email]

-----Original Message-----
From: Briggs, N. - Neil - [mailto:[login to unmask email]
Sent: Friday, October 08, 1999 8:50 PM
To: [login to unmask email]
Subject: DB2 v5 mvs to oracle AIX rs6000


Hello All,

Can anybody please advise me as to the best way to "push/pull" data from
a
DB2 subsystem version 5 running on os390 to Oracle running on a unix
rs6000.

I have currently got jobs set up that unload the data from the DB2
tables to
sequential flat files which are then sent to the rs6000 box via tcp/ip.
Using this approach I cannot vouch for the consistancy of the data if
there
is a problem with the tcp/ip transmission.

I wolud like to know if there is a similar way to have the 2 DBMS
connect to
each other similar to DB2 to DB2 using DRDA. I have read about DB2's CLI
that is able to communicate to ODBC, is this an approach worth trying?

The data is to be transferred by a batch process once a day to a not so
critical system, so there is reluctance from the management to spend
money
on purchasing products such as data joiner and Oracles gateway.

I am really in the dark about this, so if anybody can shed any light, I
would be very grateful.


Regard
Neil Briggs