Π£ΡΡΠ°Π½ΠΎΠ²ΠΊΠ°
Π§ΡΠΎΠ±Ρ ΡΠΎΠ±ΡΠ°ΡΡ ΠΌΠΎΠ΄ΡΠ»Ρ ibm_db2, Π½Π΅ΠΎΠ±Ρ
ΠΎΠ΄ΠΈΠΌΠΎ ΡΡΡΠ°Π½ΠΎΠ²ΠΈΡΡ Π² ΡΠΈΡΡΠ΅ΠΌΡ
ΡΠ°ΠΉΠ»Ρ Π·Π°Π³ΠΎΠ»ΠΎΠ²ΠΊΠΎΠ² ΠΈ Π±ΠΈΠ±Π»ΠΈΠΎΡΠ΅ΠΊΠΈ Π΄Π»Ρ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠΈ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠΉ Π‘Π£ΠΠ DB2.
Π‘ΠΈΡΡΠ΅ΠΌΠ° DB2 Π½Π΅ ΡΡΡΠ°Π½Π°Π²Π»ΠΈΠ²Π°Π΅Ρ ΠΈΡ
ΠΏΠΎ ΡΠΌΠΎΠ»ΡΠ°Π½ΠΈΡ, ΠΏΠΎΡΡΠΎΠΌΡ, Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎ, ΠΏΡΠΈΠ΄ΡΡΡΡ
Π²Π΅ΡΠ½ΡΡΡΡΡ ΠΊ ΡΡΡΠ°Π½ΠΎΠ²ΡΠΈΠΊΡ DB2 ΠΈ Π΄ΠΎΠ±Π°Π²ΠΈΡΡ ΡΡΠΈ Π½Π°ΡΡΡΠΎΠΉΠΊΠΈ.
ΠΠ»ΠΈΠ΅Π½Ρ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠΈ ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠΉ (Application Development Client) DB2 Π²ΠΊΠ»ΡΡΠ°Π΅Ρ ΡΠ°ΠΉΠ»Ρ Π·Π°Π³ΠΎΠ»ΠΎΠ²ΠΊΠΎΠ²
ΠΈ Π΄ΠΎΡΡΡΠΏΠ΅Π½ Π΄Π»Ρ Π±Π΅ΡΠΏΠ»Π°ΡΠ½ΠΎΠ³ΠΎ ΡΠΊΠ°ΡΠΈΠ²Π°Π½ΠΈΡ Ρ Β»Β ΡΠ°ΠΉΡΠ° ΠΏΠΎΠ΄Π΄Π΅ΡΠΆΠΊΠΈ
ΡΠ΅Π»ΡΡΠΈΠΎΠ½Π½ΠΎΠΉ ΡΠΈΡΡΠ΅ΠΌΡ ΡΠΏΡΠ°Π²Π»Π΅Π½ΠΈΡ Π±Π°Π·Π°ΠΌΠΈ Π΄Π°Π½Π½ΡΡ
IBM DB2 Universal Database (DB2 UDB).
ΠΡΠ»ΠΈ ΡΠ°ΠΉΠ»Ρ Π·Π°Π³ΠΎΠ»ΠΎΠ²ΠΊΠΎΠ² ΠΈ Π±ΠΈΠ±Π»ΠΈΠΎΡΠ΅ΠΊΠΈ Π΄Π»Ρ ΡΠ°Π·ΡΠ°Π±ΠΎΡΠΊΠΈ DB2-ΠΏΡΠΈΠ»ΠΎΠΆΠ΅Π½ΠΈΠΉ Π΄ΠΎΠ±Π°Π²Π»Π΅Π½Ρ
Π² ΠΎΠΏΠ΅ΡΠ°ΡΠΈΠΎΠ½Π½ΡΡ ΡΠΈΡΡΠ΅ΠΌΡ Linux ΠΈΠ»ΠΈ Unix, Π² ΠΊΠΎΡΠΎΡΠΎΠΉ Π±Π°Π·Π° DB2 ΡΠΆΠ΅ Π±ΡΠ»Π° ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π°,
Π½ΡΠΆΠ½ΠΎ Π·Π°ΠΏΡΡΡΠΈΡΡ ΠΊΠΎΠΌΠ°Π½Π΄Ρ db2iupdt -e, ΡΡΠΎΠ±Ρ ΠΎΠ±Π½ΠΎΠ²ΠΈΡΡ
ΡΠΈΠΌΠ²ΠΎΠ»ΠΈΡΠ΅ΡΠΊΠΈΠ΅ ΡΡΡΠ»ΠΊΠΈ Π½Π° Π½ΠΈΡ
Π² ΡΡΠΎΠΌ ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ΅ DB2.
ΠΠΎΠ΄ΡΠ»Ρ ibm_db2 β ΡΡΠΎ ΠΌΠΎΠ΄ΡΠ»Ρ Β»Β PECL, ΡΠ°ΠΊ ΡΡΠΎ ΡΠ»Π΅Π΄ΡΠΉΡΠ΅ ΠΈΠ½ΡΡΡΡΠΊΡΠΈΠΈ
Β«Π£ΡΡΠ°Π½ΠΎΠ²ΠΊΠ° PECL-ΠΌΠΎΠ΄ΡΠ»Π΅ΠΉΒ» Π΄Π»Ρ Π΅Π³ΠΎ ΡΡΡΠ°Π½ΠΎΠ²ΠΊΠΈ Π² PHP.
Π§ΡΠΎΠ±Ρ ΡΠΊΠ°Π·Π°ΡΡ ΡΠ°ΡΠΏΠΎΠ»ΠΎΠΆΠ΅Π½ΠΈΠ΅ ΡΠ°ΠΉΠ»ΠΎΠ² Π·Π°Π³ΠΎΠ»ΠΎΠ²ΠΊΠΎΠ² ΠΈ Π±ΠΈΠ±Π»ΠΈΠΎΡΠ΅ΠΊ DB2,
ΠΊΠΎΠΌΠ°Π½Π΄Ρ configure Π·Π°ΠΏΡΡΠΊΠ°ΡΡ ΠΊΠ°ΠΊ ΠΏΠΎΠΊΠ°Π·Π°Π½ΠΎ Π½ΠΈΠΆΠ΅:
bash$ ./configure --with-IBM_DB2=/path/to/DB2
ΠΠΎ ΡΠΌΠΎΠ»ΡΠ°Π½ΠΈΡ,
configure ΠΈΡΠΏΠΎΠ»ΡΠ·ΡΠ΅Ρ
ΠΏΡΡΡ
/opt/IBM/db2/V8.1.
ΠΠ°ΠΌΠ΅ΡΠ°Π½ΠΈΠ΅:
ΠΠ°ΠΌΠ΅ΡΠ°Π½ΠΈΠ΅ Π΄Π»Ρ ΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°ΡΠ΅Π»Π΅ΠΉ IIS
ΠΡΠ»ΠΈ Π΄ΡΠ°ΠΉΠ²Π΅Ρ ibm_db2 ΡΠ°Π±ΠΎΡΠ°Π΅Ρ Π½Π° ΡΠ΅ΡΠ²Π΅ΡΠ΅ Microsoft Internet Information
Server (IIS), Π²ΠΎΠ·ΠΌΠΎΠΆΠ½ΠΎ, ΠΏΠΎΡΡΠ΅Π±ΡΠ΅ΡΡΡ ΡΠ΄Π΅Π»Π°ΡΡ ΡΠ»Π΅Π΄ΡΡΡΠ΅Π΅:
-
Π£ΡΡΠ°Π½ΠΎΠ²ΠΈΡΠ΅ DB2 Ρ ΡΠ°ΡΡΠΈΡΠ΅Π½Π½ΠΎΠΉ Π±Π΅Π·ΠΎΠΏΠ°ΡΠ½ΠΎΡΡΡΡ ΠΎΠΏΠ΅ΡΠ°ΡΠΈΠΎΠ½Π½ΠΎΠΉ ΡΠΈΡΡΠ΅ΠΌΡ.
-
ΠΠΎΠ±Π°Π²ΡΡΠ΅ ΠΏΡΡΡ ΠΊ ΠΈΡΠΏΠΎΠ»Π½ΡΠ΅ΠΌΠΎΠΌΡ ΡΠ°ΠΉΠ»Ρ PHP Π² ΡΠΈΡΡΠ΅ΠΌΠ½ΡΡ
ΠΏΠ΅ΡΠ΅ΠΌΠ΅Π½Π½ΡΡ ΠΎΠΊΡΡΠΆΠ΅Π½ΠΈΡ PATH (ΠΏΠΎ
ΡΠΌΠΎΠ»ΡΠ°Π½ΠΈΡ C:\php\).
-
Π‘ΠΎΠ·Π΄Π°ΠΉΡΠ΅ Π΅ΡΡ ΠΎΠ΄Π½Ρ ΡΠΈΡΡΠ΅ΠΌΠ½ΡΡ ΠΏΠ΅ΡΠ΅ΠΌΠ΅Π½Π½ΡΡ ΠΎΠΊΡΡΠΆΠ΅Π½ΠΈΡ,
ΡΠΎΠ΄Π΅ΡΠΆΠ°ΡΡΡ ΠΏΡΡΡ ΠΊ PHP.INI (Π½Π°ΠΏΡΠΈΠΌΠ΅Ρ: PHPRC = C:\php\).
-
ΠΠΎΠ±Π°Π²ΡΡΠ΅ ΡΡΡΡΠ½ΡΡ Π·Π°ΠΏΠΈΡΡ ΠΏΠΎΠ»ΡΠ·ΠΎΠ²Π°ΡΠ΅Π»Ρ IUSR_COMPUTERNAME Π² Π³ΡΡΠΏΠΏΡ DB2USERS.
jean dot ferreira at gmail dot com ΒΆ12 years ago
==Installation ibm_db2 in PHP5, using Data Server Driver Package and pecl on Debian / Ubuntu==
==Advantages==
#You do not need DB2 (database) installed
#The ibm_db2 driver is downloaded and automatically compiled by pecl
==Steps==
#1- Install packages
apt-get install php-pear ksh zip
#2- Make directory
mkdir /opt/ibm
#3- Download Data Server Driver Package (dsdriver), as the architecture
(https://www-304.ibm.com/support/docview.wss?rs=4020&uid=swg27016878&wv=1)
#4- Decompress dsdriver at /opt/ibm/
tar -xvf v10.5fp1_linuxx64_dsdriver.tar.gz (linux64)
or
tar -xvf v10.5fp1_linuxia32_dsdriver.tar.gz (linux32)
#5- Change permission instalation script - /opt/ibm/dsddriver
chmod 755 installDSDriver
#6- Run the installation script
ksh installDSDriver
#7- Download and install the driver using the pecl
pecl install ibm_db2
downloading ibm_db2-1.9.5.tgz ...
Starting to download ibm_db2-1.9.5.tgz (157,720 bytes)
................done: 157,720 bytes
5 source files, building
running: phpize
Configuring for:
PHP Api Version: 20090626
Zend Module Api No: 20090626
Zend Extension Api No: 220090626
#8- Configure the installation directory
DB2 Installation Directory? : /opt/ibm/dsdriver
Build process completed successfully
Installing '/usr/lib/php5/20090626/ibm_db2.so'
install ok: channel://pecl.php.net/ibm_db2-1.9.5
configuration option "php_ini" is not set to php.ini location
You should add "extension=ibm_db2.so" to php.ini
#9- Change php.ini
vim /etc/php5/apache2/php.ini
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
extension = ibm_db2.so
extension = /usr/lib/php5/20090626/ibm_db2.so
#10- Reboot the Apache
service apache2 restart
kpfitzgerald at gmail dot com ΒΆ15 years ago
Actually a much simpler way on SLES 11 SP1 and DB2 Express C is to execute the following.
pecl install ibm_db2
when it asks for your path put in your location of SQLLIB not your db2 install. usually found here...
/home/db2inst1/sqllib
to verify execute
pecl list
Should show the following:
Installed packages, channel pecl.php.net:
=========================================
Package Version State
ibm_db2 1.9.1 stable