Re: Question (pre-newbie) about DB2

John

In general, the link Elvis sent has its top parent, http://www.iseries.ibm.com/db2 - excellent place to get all you need to know right now.

As to Oracle, they do sell a component that installs on the iSeries that can use DRDA to talk to any Oracle database. 25K for the privilege.

IBM does sell a middleware that installs on a PC that makes any ODBC/OLEDB database look like DB2 - can use DRDA for that too.

There is also JDBC.

<verndor response>
And we have a product, RPG2SQL Integrator, that can do the same as IBM's middleware, just that it uses function calls instead of embedded SQL in COBOL or RPG. See our site at http://www.rjssoftware.com or call us at 888.RJS.SOFT toll-free. You can ask for me or Richard or one of the sales folks.
</verndor response>

On that db2 site listed above, there is an excellent article by Kent Milligan and another person - link is

http://www.ibm.com/partnerworld/wps/whitepaper/i5os/db2/access

It is about heterogeneous access to data from the iSeries - it does mention our product in passing, along with the JDBC approach and, of course, the IBM one.

HTH
Vern

McKown, John wrote:

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of jim t
Sent: Wednesday, December 03, 2008 8:29 AM
To: Midrange Systems Technical Discussion
Subject: Re: Question (pre-newbie) about DB2

It sound like you are a Database Administrator. If that is the case then I have bad news: The System I does not required database administrators for tuning the files/databases.

Nope. I'm a sysprog or "system administrator". I.e. I install the OS and
do maintenance on it. I also install other vendor software. I
occasionally write little utility programs in various languages (REXX
and assembler mainly, but I am also familiar with COBOL, Perl, Python,
C, Java, and other less popular languages).

I was mainly wondering how the DB2 on i might differ from UDB on
Linux/UNIX/Windows.

Also, we are mainly an Oracle shop (Linux, Windows, and AIX). How well
does DB2 on the i "play" with Oracle on other platforms?

--
John McKown Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)
Administrative Services Group
9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john.mckown@xxxxxxxxxxxxxxxxx * www.HealthMarkets.com

Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential or proprietary information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.