DB2 (all flavors) supports integration with other databases through
DRDA. You can buy a DRDA integration for i from Oracle. That'll give you
client and server support for your Oracle boxes. With that integration
piece, you can work to your Oracle databases just like they were DB2
databases on another i or z or p or linux or windows.
Administration of DB2 on i is a little different. Everything else is
pretty much the same. API's, built in functions, and so on are all the
same. IBM has worked very hard on making the SQL language and the
interfaces the same across the entire product line. So your z COBOL
programs with embedded SQL should work without change on i after
recompilation. (Note that there's a CICS implementation for i, as well.)
All DB2's, i included, conform to SQL:1999.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of McKown, John
Sent: Wednesday, December 03, 2008 8:39 AM
To: Midrange Systems Technical Discussion
Subject: RE: Question (pre-newbie) about DB2
-----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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
