I think that every one will be excited to know that there is a "update" to
the ibmdb2 storage engine.
The update forces the library(schema) and file(table) to be UPPERCASE if
the MySQL code is installed in a case insensitive file system, ie *not
/QOpenSys
no need to change your MySQL code.
The code for the storage engine are on the YiPs site (
http://174.79.32.155/wiki/MySql/DB2StorageEngine )
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.
I think this is a big advancement. I truly hated the "library"
and "filename" issues.
here are some snippets from the release notes:
* MySql IBMDB2i Storage update for MySQL 5.1.50 (see "Resolved Issues"
section for more details)
MySql IBMDB2i Storage
Fixes for better IBM i interoperability:
- Force UPPER case when installed in IFS case insensitive file system (ie.
Zend default install is case insensitive /usr/local/mysql)
- Add support for zoned decimal like mysql numeric(12,2).
Installation instructions
- Stop MySQL daemon
- Rename /usr/local/mysql/lib/plugin/ha_ibmdb2i.so.0.0.0 to
ha_ibmdb2i.so.0.0.0_old
- Copy /usr/local/zendsvr/bin/ha_ibmdb2i.so.0.0.0 to
/usr/local/mysql/lib/plugin
Note: If the user wants to regain full control over MySql created
UPPER/"lower" case, the entire Zend MySql installation must be moved
to a case sensitive IFS file system (ie. start with /QOpenSys/).
--
Bryan
> One of the more annoying parts the integration is indeed the "" around
> the object name. That is normal, and no you cannot change it to the
> best of my knowledge. When you created the table, IBM i created the
> collection for you called "test" (quotes part of the name). You can
> access the data in "test" with any IBM tool or DBU etc without trouble.
> I do it quite a bit.
midrange.com
