RE: OT: Getting data out of DB2...any DB2 DBAs out there?

Stephane,

If you could have get some db2 odbc driver on your oracle server, you could use hetereogenous services without implementing the transparent gateway product.

We are using the Heterogenous services to query a ms sqlserver from 9i using a sqlserver odbc driver. We did not implement the transparent gateway.

-Mandar

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Wednesday, November 13, 2002 2:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OT: Getting data out of DB2...any DB2 DBAs out there?
>
>
> Stephane - I think there are two methods, the flat file, and Oracle
> Heterogeneous Services (formerly Gateways). Heterogeneous
> Services allows
> you to query the other system just like it was an Oracle
> database, but isn't
> cheap, so it may depend on how much data, how often, etc.
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Wednesday, November 13, 2002 3:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Beside Oracle, we have db2 mainframe and db2 udb on
> aix.
>
> I've asked asomeone working with DB2 mainframe and
> there is spufi which is like sqlplus and DB2
> Interactive wich is more like the command center on
> db2 udb.
>
> I'll more details tomorrow.
>
>
> --- Thomas Day <tday6_at_csc.com> a écrit : >
> > I used to use SPUFI (SP?) with TSO/MVS but that was
> > many years ago. I
> > would hope that there's something better.
> >
> >
> >
> >
> >
> > "Grabowy,
> >
> >
> > Chris" To:
> > Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > <cgrabowy cc:
> >
> >
> > @fcg.com> Subject:
> > OT: Getting data out of DB2...any DB2 DBAs out
> > there?
> > Sent by: root
> >
> >
> >
> >
> >
> >
> >
> >
> > 11/13/2002
> >
> >
> > 02:15 PM
> >
> >
> > Please
> >
> >
> > respond to
> >
> >
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Off topic post, please delete if not interested.
> >
> >
> > I am trying to get data out of a DB2 database that I
> > do not have access to.
> > The original spec called for me to create a flat
> > file, which they parse,
> > and query the DB2 DB to get the specific requested
> > data, and "spool" the
> > requested data into a flat file, which is then FTPed
> > back to me.
> >
> >
> > I would prefer to send them (in Oracle/UNIX terms) a
> > shell script calling
> > SQL*Plus that uses some SQL to get the data I need,
> > which is spooled to a
> > flat file. Since this is on MVS, I assume it will
> > have to be some SQL
> > wrapped in JCL. I just do not know of an equivilent
> > SQL*Plus in DB2, since
> > I don't even know how to spell DB2.
> >
> >
> > Since I will be proposing this approach, I was
> > hoping to have an example
> > JCL job in my proposal. So I was wondering if
> > anyone has some example jobs
> > that they would be willing to share?????
> >
> >
> > Many thanks!!
> >
> >
> > Chris
> >
> >
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Thomas Day
> > INET: tday6_at_csc.com
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> > hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
> =====
> Stéphane Paquette
> DBA Oracle et DB2, consultant entrepôt de données
> Oracle and DB2 DBA, datawarehouse consultant
> stephane_paquette_at_yahoo.com
>
> __________________________________________________________
> Lèche-vitrine ou lèche-écran ?
> magasinage.yahoo.ca
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar A. Ghosalkar
  INET: mghosalk_at_byer.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).