But they can be the same. That's what the DB2 Storage Engine for IBM i
does. It takes MySQL tables and stores them natively in DB2 tables on i.
This makes the tables accessible via DB2 and MySQL at the same time.
And just to throw it in, it is possible to expose an existing DB2 table
via MySQL (although IBM did not include the process in the storage
engine). Currently, the process is ugly and error prone, but it does
work. I am working on a tool to automate the process and plan to release
it to the community for free.
Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi
Young i Professionals
http://www.youngiprofessionals.com
"Dennis Lovelady" <iseries@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/01/2009 09:30 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc
Subject
RE: MySQL on i using DB2
So the short answer is yes you can do exactly what you are asking.
I must apologize; I read something into the question that wasn't there.
I thought the op wanted to connect to DB2 data (i.e. a library/file
object)
using a mySQL connection. I was thrown off by this confusion:
"Could I write a application ... i and have it access the
> mySQL database (actually DB2)"
Actually this is NOT DB2, or my prior response applies. mySQL may exist
on
a DB2 machine (the i), but that does not make it a DB2 database. The two
may coexist, but are not the same. They contain different data, different
tables, et cetera.
Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I don't want to belong to any club that would accept me as a member."
-- Groucho Marx
midrange.com
