I've been working with ibmdb2i, but not sure about 32 vs 64 bit. I've found
that mysql support is very responsive about the ibmdb2i storage engine,
since this is very new and they want it to work for everyone. Try opening a
support ticket on mysql.com, specify ibmdb2i storage engine as product, and
Kyle Joiner will probably have your answer very quickly.
John Valance
JValance Consulting
jvalance@xxxxxxxxxxx
802-355-4024
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of web400-request@xxxxxxxxxxxx
Sent: Sunday, January 03, 2010 1:00 PM
To: web400@xxxxxxxxxxxx
Subject: WEB400 Digest, Vol 8, Issue 2
Send WEB400 mailing list submissions to
web400@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/web400
or, via email, send a message with subject or body 'help' to
web400-request@xxxxxxxxxxxx
You can reach the person managing the list at
web400-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of WEB400 digest..."
*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.
Today's Topics:
1. MySQL IBMDB2I Storage Engine - Where is ha_ibmdb2i.so plugin
? (Richard Schoen)
2. Re: MySQL IBMDB2I Storage Engine - Where is
ha_ibmdb2i.soplugin ? (Mike Pavlak)
3. Re: MySQL IBMDB2I Storage Engine - Where is ha_ibmdb2i.so
plugin ? (Richard Schoen)
----------------------------------------------------------------------
message: 1
date: Sat, 2 Jan 2010 17:55:39 -0600
from: "Richard Schoen" <richard@xxxxxxxxxxxxxxx>
subject: [WEB400] MySQL IBMDB2I Storage Engine - Where is
ha_ibmdb2i.so plugin ?
Using the the "Using IBM DB2 for I as a Storage Engine of MySQL" Redbook
I downloaded all the PTFs required for V5R4 and installed the V5.1.42
64-bit MySQL version as mentioned in the Redbook. It didn't actually
mention V5.1.42, but did mention 64-bit version J
MySQL works just fine and it's running V5.1.42. I have verified this.
When I try to register the IBMDB2I storage engine plugin "ha_ibmdb2i.so"
component, I get the following error from MySQL .
Command issued:
----------------------------------------------------
install plugin ibmdb2i soname "ha_ibmdb2i.so";
Error Text:
-----------------------------------------------------
ERROR 1126 (HY000): Can't open shared library
'/QOpenSys/usr/local/mysql51/my
sql-5.1.42-i5os-power-64bit/lib/plugin/ha_ibmdb2i.so' (errno: 2
0509-
022 Cannot load module
/QOpenSys/usr/local/mysql51/mysql-5.1.42-i5os-power-64
bit/lib/plugin/ha_ibmdb2i.so.
0509-021 Addit)
I scanned the IFS and specifically the MySQL subfolders and there is no
module file named: ha_ibmdb2i.so
I also looked inside the TAR file and there was no ha_ibmdb2i.so module
there either.
Can someone tell me how I get a hold of ha_ibmdb2i.so or at least tell
me where I'm off ?
Also: I did check the 32-bit download and it appears to have this plugin
in the install files.
Do I need the Enterprise MySQL version t use the DB2i capability ?
Me confused J
Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx <mailto:richard@xxxxxxxxxxxxxxx>
Web Site:
http://www.rjssoftware.com <
http://www.rjssoftware.com/>
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------
message: 2
date: Sat, 2 Jan 2010 17:13:01 -0800
from: "Mike Pavlak" <Mike.Pavlak@xxxxxxxx>
subject: Re: [WEB400] MySQL IBMDB2I Storage Engine - Where is
ha_ibmdb2i.soplugin ?
This might help:
http://www.ibmsystemsmag.com/print/print.aspx?print_page=%2Fibmi%2Ffebru
ary09%2Ffeatures%2F24086printp1.aspx&string_referer=/ibmi/february09/fea
tures/24086p2.aspx
Regards,
Mike
mike.p@xxxxxxxx Cell: (408)679-1011 Office: (815)722-3454
Zend Server for IBM i Beta avilable at
http://www.zend.com/en/products/server/zend-server-5-new-ibmi
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Richard Schoen
Sent: Saturday, January 02, 2010 5:56 PM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] MySQL IBMDB2I Storage Engine - Where is
ha_ibmdb2i.soplugin ?
Using the the "Using IBM DB2 for I as a Storage Engine of MySQL" Redbook
I downloaded all the PTFs required for V5R4 and installed the V5.1.42
64-bit MySQL version as mentioned in the Redbook. It didn't actually
mention V5.1.42, but did mention 64-bit version J
MySQL works just fine and it's running V5.1.42. I have verified this.
When I try to register the IBMDB2I storage engine plugin "ha_ibmdb2i.so"
component, I get the following error from MySQL .
Command issued:
----------------------------------------------------
install plugin ibmdb2i soname "ha_ibmdb2i.so";
Error Text:
-----------------------------------------------------
ERROR 1126 (HY000): Can't open shared library
'/QOpenSys/usr/local/mysql51/my
sql-5.1.42-i5os-power-64bit/lib/plugin/ha_ibmdb2i.so' (errno: 2
0509-
022 Cannot load module
/QOpenSys/usr/local/mysql51/mysql-5.1.42-i5os-power-64
bit/lib/plugin/ha_ibmdb2i.so.
0509-021 Addit)
I scanned the IFS and specifically the MySQL subfolders and there is no
module file named: ha_ibmdb2i.so
I also looked inside the TAR file and there was no ha_ibmdb2i.so module
there either.
Can someone tell me how I get a hold of ha_ibmdb2i.so or at least tell
me where I'm off ?
Also: I did check the 32-bit download and it appears to have this plugin
in the install files.
Do I need the Enterprise MySQL version t use the DB2i capability ?
Me confused J
Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx <mailto:richard@xxxxxxxxxxxxxxx>
Web Site:
http://www.rjssoftware.com <
http://www.rjssoftware.com/>
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
midrange.com
