Re: DB2 vs MySQL ... Oh I have learned a lot!

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Yeah, Mike, there is a lot of space management and all that is done for 
us on the i - there are lots of knobs in DB2 for LUW that need to be 
set, to optimize performance.

I haven't worked in those myself but did work alongside a fellow who 
did, when testing the new query engine in 2001 - he said there's a lot 
to do for that version.

Cheers
Vern

On 1/13/2016 4:06 PM, Mike Jones wrote:
> >From a developer perspective I tend to agree with Joe.  Although, I'd be
> willing to bet that DB2 LUW has a larger development budget than the DB2
> for i team.
>
> >From an administrator perspective, DB2 LUW, at a glance, looks like it
> needs a lot more baby sitting and administration.
>
> Mike
>
>
> > date: Wed, 13 Jan 2016 15:14:10 -0600
> > from: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
> > subject: Re: DB2 vs MySQL ... Oh I have learned a lot!
> >
> > Hi Joe
> >
> > There are some things that IBM i got first - so we're not so much the
> > redheaded stepchild anymore. It was something recent - maybe
> > row-column-access-control - I forget at the moment.
> >
> > Vern
> >
> > On 1/13/2016 12:16 PM, Joe Pluta wrote:
> > > -snip-
> > >
> > > Me, I'm more upset that DB2 LUW always outpaces DB2 for i, but I've
> > > learned to live with being the last one at the table.  Even a slightly
> > > backward version of DB2 is indeed one heck of a powerful engine, and
> > > there's absolutely nothing in the industry like the embedded RPG
> > > integration.
> > >
> > > In my (not so) humble opinion, of course.  :)