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

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 13 Nov 2002 14:38:30 -0800
Message-ID: <F001.00502C4F.20021113143830@fatcity.com>

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).

Received on Wed Nov 13 2002 - 16:38:30 CST