RE: MySQL on i

DRDA is the DB2 abstraction layer. It is the same for DB2 on z, i, p,
intel, whatever. Distributed Relational Database Architecture was
intended to be a standard by which ALL databases interfaced. However
Oracle, which was the only other extant database at the time, choose to
support a different standard. To date, there is no standard. Each
manufacturer has his own. DRDA is published and widely available,
however, which is different from the others.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Monday, October 06, 2008 3:53 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: MySQL on i


On 6-Oct-08, at 4:08 PM, midrange-l-request@xxxxxxxxxxxx wrote:

But DB2 would need a similar abstraction layer because it can run on
LUW and on the i - which are entirely different animals.

Well for one thing the code that runs on i is not the same code base as
the others (although some of it may be these days).

More to the point - with MySQL it is an integral part of the design - to
the extent that you can build your own custom storage engine if you want
to. While DB2 may have some internal abstraction - to the best of my
knowledge this is not surfaced. So while it may happen under the hood
it makes no difference to the end user because they can't choose which
one to use.


Jon Paris

www.Partner400.com
www.SystemiDeveloper.com


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