Re: IBMDB2I Storage Engine Question

[Matt Lavinder <mlavinder@xxxxxxxxxxxxxxxxxxx>]

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.