ZendDBi Installation and Upgrade Instructions 
                                =============================================
 
 
ZendDBi is a MySQL 5.1.59 distribution created by Zend and IBM. This package also includes the latest IBMDB2i storage engine, which enables PHP applications that 
use MySQL to actually store data in DB2/400. 

Supported IBM i Systems:
- V6R1
- V7R1

Installation - The following procedure will install the ZendDBi package:

1.      Log on to the IBM i system with QSECOFR user profile.
	a. Create the SAVF files in the QGPL library for the PTF save file:
            - CRTSAVF FILE(QGPL/ZENDDBI)


2.      Transfer ZendDBi by binary FTP to the SAVF file in QGPL.
        This can be done by executing the following steps:

	a. Verify that FTP is running on your IBM i system by running the following command and looking for 'FTP' or '21' in the Local Port column:
            - NETSTAT *CNN

	b. Open a command prompt and change the directory to the directory that contains the files you extracted from the ZIP file.

	c. Run the FTP command, specifying the name of your i5/OS system. e.g:
	   FTP IBM i_system_name/TCP address

	d. If prompted, enter a valid user profile and password.
	   Enter the following bin command to specify a binary transfer
	     -  bin

    e. Change the directory to QGPL
         - cd qgpl 

	f. Transfer the ZendDBi save file to the IBM i system by running:
	     - put zenddbi.savf ZENDDBI


3.	 Install by running following commands:
	 - RSTLIB SAVLIB(ZMYSQL) DEV(*SAVF) SAVF(QGPL/ZENDDBI)
         - CHGCURLIB ZMYSQL
         - CALL ZMYSQLINS1 
         - CHGCURLIB *CRTDFT 


Upgrade - The following procedure will upgrade an old version of MySQL (5.1.xx) installed in the ZMYSQLlibrary:

1.	 Upgrade by running the following commands (The upgrade is valid only for minor versions of MySQL 5.1) 
         - Stop MySQL subsystem using the following MySQL management menu option:  
             - GO ZMYSQL/ZCMYSQL ->option 5 and then ->option 2

         - Exit from MySQL management menu by clicking the function key F3

  	 - Restore the ZendDBi library
	     - RSTLIB SAVLIB(ZMYSQL) DEV(*SAVF) SAVF(QGPL/ZENDDBI)

	 - Run the Upgrade program
             - CHGCURLIB ZMYSQL
             - CALL ZMYSQLUPG1
             - When you get the upgrade display screen, enter only the MySQL root password that was defined 
               before the upgrade process.  
	
         - After the upgrade program ends, change the current library
            - CHGCURLIB *CRTDFT

2.   Verify the ZendDDBID job/daemon running status by entering the following command:
          - WRKACTJOB JOB(ZENDDBID)
                

3.   Access the ZendDBi management menu by entering entering the following command:
          - GO ZMYSQL/ZCMYSQL



IBMDB2i Storage Engine installation - This procedure will explain how to installl IBMDB2i Storage Engine in ZendDBi:

1.      Start QSH command entry and type the following commands to install the IBMDB2i Storage Engine:  
                - QSH
                - cd /usr/local/mysql/bin
                - mysql -u root -p <password>
                - install plugin ibmdb2i soname "ha_ibmdb2i.so";
2.      Use the following link that allows using phpMyAdmin application to create MySQL tables in DB2 using IBMDB2i Storage Engine
                - http://Your_IBMi_server:10088/phpmyadmin   


Additional ZendDBi/MySQL Reference materials

APAR II14442 lists all the PTF requirements to enable the new query engine. Further information about usage and maintenance can be found in the following resources:

    -  Discovering MySQL -Redbook: http://www.redbooks.ibm.com/abstracts/sg247398.html?Open

    -  Using IBM DB2 for i as a Storage Engine of MySQL -Redbook: http://www.redbooks.ibm.com/abstracts/sg247705.html?Open