By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,637 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,637 IT Pros & Developers. It's quick & easy.

odbc driver for db2 in OS/390 ?

P: n/a
HSP
hello, i want to replicate some updates in a db2 table in mainframe to a
Oracle database in Unix box. I'm thinking in use triggers and ODBC to
connect to Oracle database. The cost of the solution is a serious
restriction (replication is discarded due license cost).
are ODBC drivers part of the DB2 standard distribution or extra feature ?

thanks in advance for the help

Haroldo
--

---

__o
_`\<,_
(_)/ (_)
~~~~~~~~~~~~
640K Will be enough.

Bill Gates.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I do not believe that ODBC drivers are part of DB2/mainframe. I think
you need to purchase DB2 Connect in order to get the DB2 client code
with the ODBC drivers in it. You wouldn't be able to use ODBC drivers
against the mainframe natively anyway, because of data conversion
issues. That is the idea behind DB2 Connect.

Larry Edelstein

HSP wrote:
hello, i want to replicate some updates in a db2 table in mainframe to a
Oracle database in Unix box. I'm thinking in use triggers and ODBC to
connect to Oracle database. The cost of the solution is a serious
restriction (replication is discarded due license cost).
are ODBC drivers part of the DB2 standard distribution or extra feature ?

thanks in advance for the help

Haroldo
--

---

__o
_`\<,_
(_)/ (_)
~~~~~~~~~~~~
640K Will be enough.

Bill Gates.


Nov 12 '05 #2

P: n/a
HSP
Thanks Larry!!

"Larry" <la***@nospam.net> escribió en el mensaje
news:yH******************@fe11.lga...
I do not believe that ODBC drivers are part of DB2/mainframe. I think you
need to purchase DB2 Connect in order to get the DB2 client code with the
ODBC drivers in it. You wouldn't be able to use ODBC drivers against the
mainframe natively anyway, because of data conversion issues. That is the
idea behind DB2 Connect.

Larry Edelstein

HSP wrote:
hello, i want to replicate some updates in a db2 table in mainframe to a
Oracle database in Unix box. I'm thinking in use triggers and ODBC to
connect to Oracle database. The cost of the solution is a serious
restriction (replication is discarded due license cost).
are ODBC drivers part of the DB2 standard distribution or extra feature ?

thanks in advance for the help

Haroldo
--

---

__o
_`\<,_
(_)/ (_)
~~~~~~~~~~~~
640K Will be enough.

Bill Gates.

Nov 12 '05 #3

P: n/a
RdR
Hi Haroldo,

Federation might be a little less expensive than Replication (if it is DPROP
for z/OS). You will need Websphere Information Integrator Advanced Edition
and Websphere Information Integrator Classic Federation. (Of course DB2/UDB
but can be out of the mainframe). The ODBC drivers I believe are included. I
know cost is an issue but it is really the matter of how much the issues you
try to solve costs to you or how much it is costing you and the implications
not solving those issues.

Thanks,

RdR

"HSP" <hs*@hotmail.com> wrote in message
news:d0**********@news1.nivel5.cl...
hello, i want to replicate some updates in a db2 table in mainframe to a
Oracle database in Unix box. I'm thinking in use triggers and ODBC to
connect to Oracle database. The cost of the solution is a serious
restriction (replication is discarded due license cost).
are ODBC drivers part of the DB2 standard distribution or extra feature ?

thanks in advance for the help

Haroldo
--

---

__o
_`\<,_
(_)/ (_)
~~~~~~~~~~~~
640K Will be enough.

Bill Gates.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more DB2 Database Questions on Bytes