ZendDBi Istallation 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. 
 

Installation - This proccess will install/upgrade the ZendDBi package

1.      Log on to the IBM i system with QSECOFR user profile.
	a. Stop the Zend Server subsystem using the following Zend Server setup menu options:  
            - 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

If you have an old version of MySQL (5.1.xx) installed in the ZMYSQL library then skip to step 4

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

4.	 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 2
  	     - Exit from MySQL management menu by clicking the function key F3
  	     - RSTLIB SAVLIB(ZMYSQL) DEV(*SAVF) SAVF(QGPL/ZENDDBI)
             - CHGCURLIB ZMYSQL
             - CALL ZMYSQLUPG1
             - CHGCURLIB *CRTDFT

5.    	Check if ZendDDBI subsystem was started by running:
             - WRKACTJOB SBS(ZENDDBI)

6.      Use the following command to access ZendDBi management menu options:
             - GO ZMYSQL/ZCMYSQL