IBMdb2i Installation?

[skrantz71]

Could someone point my in the right direction how to install IBMdb2i?

Is this included in Zend Server? Is there something I should download?

Thanks in advance

[kent_zacharias]

IBMdb2i is also on my project list. The goal is to enable access to DB2 data from/to PHP software packages Drupal and Magento.

It is my understanding that IBMdb2i support must come from IBM and not Zend.

One task required for V5R4M0 is installation of APAR "II14442 - INFOAPAR for MYSQL on IBM I".

[kent_zacharias]

See also manual "Using IBM DB2 for i as a Storage Engine of MySQL" an IBM redbook - SG24-7705-00.

[erich_hieden]

[...]It is my understanding that IBMdb2i support must come from IBM and not Zend. [...]

AFAIK it's unclear, who is supporting the storage engine. At first the support was done (poorly) by MySQL. Since dropping the storage engine and the IBM i builds, IBM and Zend have not yet said, who is going to pick it up. Please correct me if I'm wrong here.

BTW be aware that there are a few errors in this redbook, but it's an absolute must to read it, in order to know what you can do and what not.

Regards

[kentatzend]

Ok now we can officially comment on this!

For the past five years, IBM and Zend have collaborated to deliver a PHP-based, open-source ecosystem around the Power Systems IBM i platform. The goal has been to provide a tested, pre-configured, optimized, and supported technology stack that enables IT organizations to web-enable their existing applications, databases, and/or business logic that resides on IBM i systems. Mission accomplished!

Looking ahead, IBM and Zend will sustain this commitment to the IBM i community for the foreseeable future. Furthermore, we are expanding our strategic alliance in new and important ways that will keep the platform open, vibrant, and growing.

• IBM will continue to deliver Zend Server for IBM i with every IBM i shipment. Zend Server 5.5 for IBM i will be GA by year end—a release that fills the application deployment gap in the PHP application lifecycle. Zend will continue to provide the first year of support for Zend Server CE at no additional charge with follow on support subscriptions for additional years.
• Zend will provide "Zend DBi" as a drop-in replacement for MySQL on the IBM i platform. Zend DBi will be shipped as part of Zend Server for IBM i and freely downloadable as a standalone package. The build will remain open-source and be updated over time to implement relevant bug fixes and features that become available for MySQL on other platforms. Commercial support will also be available for purchase.
• IBM will continue to maintain and deliver, via Zend Server and as a standalone package, the DB2 Storage Engine for MySQL for IBM i. This offering will evolve along with the custom build of MySQL on IBM i delivered with Zend Server.
• IBM and Zend are developing an open-source toolkit alternative, based in XML. It is available in beta now as part of Zend Server 5.1 for IBM i and downloadable from the Young i Professionals site: (http://www.youngiprofessionals.com/wiki/XMLSERVICE). The XML toolkit will GA by year end.

Zend and IBM hope this will address any fears people have about the continued support for MySQL and he DB2 storage engine.

[erich_hieden]

Kent, you can't imagine how glad I am to hear this! If i didn't marry a month ago I'd make a proposal to you. :-)

[erich_hieden]

In a more serious tone: Do you know, where I can file bugs for the existing storage engine (aka IBMDB2i)?

[kentatzend]

Good question .... I'm not sure but I'll find out.