Re: IBMDB2I Storage Engine Question

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

On May 12, 2011, at 11:24 AM, web400-request@xxxxxxxxxxxx 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. :)

First point - the storage engine is still _owned_ AND _supported_ by IBM. The only thing that has changed is that Oracle are no longer distributing binaries of MySQL for IBM i and AIX. period - end of story.

> 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?

This is happening because your MySQL databases are currently being stored in a case-insensitive part of the IFS - this is the default for the Zend install and if you want to use the storage engine it is a really _bad_ default. In a case-insensitive directory, the names fed through (as you have seen) are in lower-case - not upper as you expected/hoped. If you create the data directory in QOpenSys (which is a case sensitive directory) then the upper case names etc. are preserved as you want them to be.  This might seem couter-intuitive (OK - it is counter-intuitive) but that's how it works. You do not not have to reinstall - you can simply move the data directory and then change the location in the config file Mycnf.cfg (I think that's the name).


Jon Paris