× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.