DB 2 Storage Engine Orig

MySql.DB2StorageEngineOrig History

Hide minor edits - Show changes to output

Added lines 1-90:

(:table border=1 width=100%:)
(:cellnr colspan=2 align=center style="background-color: #CCCCCC;":)[++Package Information++]
(:cellnr style="background-color: #CCCCCC;":)Summary
(:cell:)MySql DB2 Storage Engine
(:cellnr style="background-color: #CCCCCC;":)Maintainers
(:cell:)Jian CDL Li IBM China [[mailto:cdllij@cn.ibm.com|<cdllij@cn.ibm.com>]]
(:cellnr style="background-color: #CCCCCC;":)License
(:cell:)[[DB2StorageEngineLicense | BSD]]
(:cellnr style="background-color: #CCCCCC;":)Binaries
(:cell:) %newwin%[[ http://www.zend.com/en/products/dbi/ | {ZendDBi download} ]] - see Zend site here
* Zend DBi erases any uncertainty about the future of IBM i as a supported MySQL platform: it's built using the same open-source code used to build MySQL, and will be kept up to date by Zend and IBM with all features and bug fixes introduced in MySQL
* Zend supplies all binaries for ZendDBi (IBM does not provide PTFS)
(:cellnr style="background-color: #CCCCCC;":)PTFS
(:cell:)
* %newwin%[[http://www-912.ibm.com/s_dir/sline003.NSF/GroupPTFs?OpenView&Start=1&Count=30&Collapse=1#1 | {IBM i PTFs}]]  - IBM i V5R4, V6, or V7 - Latest PTF cumulative: Java, DB2
* %newwin%[[http://www-912.ibm.com/n_dir/nas4apar.nsf/c79815e083182fec862564c00079d117/67d12878076e4827862574e2003c6d4a?OpenDocument | {MySql DB2 PTFs}]] IBM i - additional IBM i PTF enabler enhancements to DB2 for IBMDB2i
** Note: If you do not understand PTFs vs. ZendDBi click the documentation link below to see the big picture.
(:cellnr style="background-color: #CCCCCC;":)Description
(:cell:)Open Source MySql code that enables DB2 backed MySql applications.
* below source supersedes standard MySql source distribution directory storage/ibmdb2i (update replacement source)
* "Zend Server -- How to install ZendDBi" [[ http://rodflohr.com/?p=119 ]]
(:tableend:)


(:table border=0 width=100%:)
(:cellnr:)[[ Attach:ibmdb2i_5.1.50.tar.gz | %blue%{Download Latest}%%]]
(:cell:)[[DB2StorageEngineChangeLog | %blue%{Changelog}%%]]
(:cell:) [[DB2StorageEngineDocument | %blue%{View Documentation}%%]]
(:cellnr colspan=3:)[[ Attach:db2i_constraints.cc.zip | %blue%{Download Patch}%%]]  - replace db2i_constraints.cc -- fix foreign key issue
(:tableend:)


(:table border=1 width=100%:)
(:cellnr colspan=5 align=center style="background-color: #CCCCCC;":)[++Available Releases++]
(:cellnr style="background-color: #CCCCCC;":)[++Version++]
(:cell:)[++State++]
(:cell:)[++Release Date++]
(:cell:)[++Downloads++]
(:cell:)
(:cellnr style="background-color: #CCCCCC;":)5.1.50
(:cell:)stable
(:cell:)2010-12-21
(:cell:)
* 20101221 SOURCE -- [[ Attach:ibmdb2i_5.1.50.tar.gz | ibmdb2i_5.1.50.tar.gz]]
* 2012-11-07 PATCH -- [[ Attach:db2i_constraints.cc.zip | %blue%{db2i_constraints.cc.zip}%%]] -- fix foreign key issue
* 2013-10-09 PATCH -- [[ Attach:ha_ibmdb2i.cc.zip | %blue%{ha_ibmdb2i.cc.zip}%%]] -- fix DROP SCHEMA using incorrect case
(:cell:)[[DB2StorageEngineChangeLog | Changelog]]
(:tableend:)


!!! Testing
A subset of the standard pear tests for MySql are used to test DB2 Storage Engine. Capabilities and behaviours across storage engines are similar but never exact, so you should not expect perfect fit porting any given MySql application to ibmdb2i.
(:table border=1 width=100%:)
(:cellnr colspan=5 align=center style="background-color: #CCCCCC;":)[++Available Releases++]
(:cellnr style="background-color: #CCCCCC;":)[++Version++]
(:cell:)[++State++]
(:cell:)[++Release Date++]
(:cell:)[++Downloads++]
(:cell:)
(:cellnr style="background-color: #CCCCCC;":)5.1.50
(:cell:)stable
(:cell:)2013-02-05
(:cell:)
* pear tests -- [[ Attach:php5.3.6.zip | php5.3.6.zip]]
* [@ pear test cases for ibmdb2i

pear run (see set-up):
call qp2term
> cd /home/minime
> unzip php5.3.6.zip
> export PATH=/usr/local/zendsvr/bin:$PATH
> export LIBPATH=/usr/local/zendsvr/lib
> cd mysqli52/, mysqli53/, etc.
> pear *.phpt

Set-up for tests:
call qp2term
> chmod 0775 /usr/local/mysql/bin/my.cnf                                (Zend shipped wrong authorisation -- ignored)
> cp /usr/local/mysql/bin/my.cnf /usr/local/mysql/bin/my.cnf-orig        (make a copy -- just in case)
> echo 'default-storage-engine=IBMDB2I' >> /usr/local/mysql/bin/my.cnf  (be careful, >> append, > is replace)
> cat /usr/local/mysql/bin/my.cnf                                        (cat will let you see your changes)
  You will need to start/stop ZendDBi server (go zendsvr/zsmenu),
  but before start/stop you most likely want to
  move/copy/delete old database info out of way new engine,
  before recreate all your PHP script tables again.
  -- http://myibmi(:10088)/phpMyAdmin/                                    (easy tool move/copy shipped Zend Server)
@]
(:cell:)[[DB2StorageEngineChangeLog | Changelog]]
(:tableend:)