Installing MySQL on i5/OS

IMG_2933

prequisites
software:
5722SS1 *BASE IBM i Version 5 Release 4 (V5R4)
5722SS1 30 Qshell
5722SC1 *BASE IBM Portable Utilities for IBM i
5722SS1 13 System Openness Includesa
a. System Openness Includes are not necessary but may be useful. This licensed program
provides all source includes for APIs that ship with IBM i.
5722SS1 33 Portable Application Solutions Environmentb
b. IBM Portable Utilities for IBM i is not necessary but might be useful. For more information,
refer to 3.3, “IBM i PASE, runtime environment” on page 44.
5799PTL *BASE iSeries Tools for Developersc

ptfs:
——PTF LIST FOR iSeries RELEASE 710———-
First ensure database PTF level 2 (WRKPTFGRP SF99701) and
Cumulative PTF Package 0096 are applied (WRKPTFGRP SF99710).
Then apply these additional PTF’s:

PTF APAR APAR-DATE DESCRIPTION
————————————————————
SI40254|SE43885||2010-06-24|OSP-DB-UNPRED Unicode index
not reporting cardinality

SI40585|SE44293||2010-08-03|OSP-DB-UNPRED Support
QIBM_SRVRMODE_SBS in storage engine
————————————————————

——PTF LIST FOR IBM i RELEASE 610———-
First ensure database PTF level 14 (WRKPTFGRP SF99601) and
Cumulative PTF Package 0047 are applied (WRKPTFGRP SF99610).
Then apply these additional PTF’s:

PTF APAR APAR-DATE DESCRIPTION
———————————————————–
SI34313|SE36603||2009-02-27|OSP-COMM AF_UNIX bind() fails for
ccsid 1208

SI37766|SE40876||2010-02-11|OSP-DB-UNPRED Cannot create tables
through storage engine

SI35185|SE37610||2009-05-04|OSP-DB Enablement For Future
Enhancement

SI35422|SE37970||2009-06-25|OSP-DB-MSGSQL7017 can’t update
IASP object after TEMP TABLE

SI40255|SE43887||2010-06-24|OSP-DB-UNPRED Unicode index
not reporting cardinality

SI40584|SE44292||2010-08-03|OSP-DB-UNPRED Support
QIBM_SRVRMODE_SBS in storage engine
———————————————————–

——PTF LIST FOR iSeries RELEASE 540———-
First ensure database PTF level 26 (WRKPTFGRP SF99504) and
Cumulative PTF Package 0117 are applied (WRKPTFGRP SF99540).
Then apply these additional PTF’s:

PTF APAR APAR-DATE DESCRIPTION
————————————————————
SI37763|SE40873||2010-02-11|OSP-DB-UNPRED Cannot create tables
through storage engine

SI35184|SE37609||2009-05-04|OSP-DB Enablement For Future
Enhancement

SI40257|SE43884||2010-06-24|OSP-DB-UNPRED Unicode index
not reporting cardinality

SI40583|SE44291||2010-08-03|OSP-DB-UNPRED Support
QIBM_SRVRMODE_SBS in storage engine

installing:

1 CRTSAVF FILE(QGPL/MYSQLINST) TESXT(‘MySQL Save file’)
2 downloadmysql-5.4.2-beta-i5os-power-64bit.savf
3 ftp to system
4 put mysql-5.4.2-beta-i5os-power-64bit.savf mysqlinst
5 RSTLIB MYSQLINST DEV(*SAVF) SAVF(QGPL/MYSQLINST) MBROPT(*ALL) ALWOBJDIF(*ALL)
6 check library using: DSPLIB LIB(MYSQLINST)
7 run  MYSQLINST/INSMYSQL
*  DIR(‘/QOpenSys/usr/local/mysql’) sets the installation location for the MySQL files. The directory will be created if it does not already exist.
*  DATADIR(‘/QOpenSys/usr/local/mysql/data’) sets the location of the directory that will be used to store the database files and binary logs. The default setting is /QOpenSys/usr/local/mysql/data. Note that if the installer detects an existing installation (due to the existence of /etc/my.cnf), then the existing setting will be used instead of the default.
*  USRPRF(MYSQL) sets the user profile that will own the files that are installed. The profile will be created if it does not already exist.
8 DLTLIB LIB(MYSQLINST)

 

Start PASE terminal:

call qp2term

Start mysql:

/QOpenSys/usr/local/mysql/mysql/bin/mysqld_safe &

Change password for root user:

/QOpenSys/usr/local/mysql/mysql-5.4.2-beta-i5os-power-64bit/bin/mysqladmin -u root password ‘mypass’

Installing the IBMDB2I Storage Engine plug-in component for MySQL
1. Run the following MySQL SQL command:
mysql>
install plugin ibmdb2i soname “ha_ibmdb2i.so”;

stop mysql:

/QOpenSys/usr/local/mysql/mysql-5.4.2-beta-i5os-power-64bit/bin/mysqladmin -u root -pmypass shutdown

 

0 Comments

Leave a reply

Your email address will not be published. Required fields are marked *

*