Re: IBMDB2I Storage Engine Question

The PTF updates the MySQL installation save file. You would need to remove the old MySQL version. Refer to Zend Server User Guide for steps how to remove MySQL. Once the old MySQL version is removed, select option "6. MySQL management menu" which should prompt you with MySQL installation dialog

Sam

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Matt Lavinder
Sent: Thursday, May 12, 2011 9:40 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] IBMDB2I Storage Engine Question

I used the PFT installer. Does that not update MySQL?


On Thu, May 12, 2011 at 2:19 PM, Sam Pinkhasov <sam@xxxxxxxx> wrote:

The IBMDB2I module requites MySql 5.1.50 which is included in the Zend
Servrer 5.1 package

Sam

Matt Lavinder <mlavinder@xxxxxxxxxxxxxxxxxxx> wrote:


When I try replacing the module with the one in the Zend Server
distribution
the engine no longer works. I tried reinstalling with the following
command:

install plugin ibmdb2i soname "ha_ibmdb2i.so";

...and I got this message:

Can't open shared library 'ha_ibmdb2i.so' (errno: 0 API version for STORAGE
ENGINE plugin is too different)

Any suggestions?


On Thu, May 12, 2011 at 1:15 PM, Sam Pinkhasov <sam@xxxxxxxx> wrote:

The latest compiled IBMDB2i Storage engine module is included in the Zend
Server 5.1 package. The module is located in the following installation
directory: /usr/local/zendsvr/bin

Sam


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]

On

Behalf Of Matt Lavinder
Sent: Thursday, May 12, 2011 7:28 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] IBMDB2I Storage Engine Question

Ok. I found the instructions on how to compile on the YiPs web site. My
mistake and apologies.


On Thu, May 12, 2011 at 12:16 PM, Matt Lavinder <
mlavinder@xxxxxxxxxxxxxxxxxxx> wrote:

I spent some time getting it to compile on the i (that was a treat)

and

then found it was included with the latest ZendServer code.

Perhaps you could go update the YiPs Wiki or post some instructions

here

on

what you did to get it to compile. I am surprised that the file on the

YiPs

site has NO instructions or make file. That is kind of disappointing.



On Thu, May 12, 2011 at 11:45 AM, Matt Lavinder <
mlavinder@xxxxxxxxxxxxxxxxxxx> wrote:

I just started using IBMDB2I and I just installed the Zend Server 5.1

PTF

before I enabled it. The issue still exists for me. Does the PTF to

patch

ZendServer not include a patch for MySQL and IBMDB2I data engine?

Maybe

you

have to do a fresh install....



On Thu, May 12, 2011 at 11:21 AM, Sam Pinkhasov <sam@xxxxxxxx> wrote:

Qq

Matt Lavinder <mlavinder@xxxxxxxxxxxxxxxxxxx> wrote:


Just trying out the IBMDB2I storage engine. I know it isn't

officially

supported anymore so don't remind me- I live on the edge. :)

I am creating a schema and table, and based on the Redbook (which

might

be
wrong), if I use all uppercase and less than 10 characters for my
database
name and table name, the object created on the system should not have
quotes
in the name But I create TEST.MYTABLE and it is placed in
"test"."mytable"
on the system. Is there a way to keep tables created in MySQL from
having
quotes around the name?

Matt
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.