IBM - DB2 (ODBC?) Help needed.

[Anon]

I need to get PHP on linux working with IBM DB2 on an AS/400 (2Terrabyte database, so don't bother saying "using mysql".)

I am seeing that I need to use ODBC to get this to work.

What ODBC package do I need to use?

Thanks for any help!

-Pete

[Anon]

There are many. I think iODBC has the best multi-operating system support. Check it out at http://www.iodbc.org/

[Anon]

php speaks db2 native, so to speak, just build it with the --with-ibm-db2 switch. You may need to install a version of DB2 on the local box, or map a network drive to the AS400 to get a directory to db2 so php can configure itself for that.

Avoid ODBC when possible, it tends to be much slower than a native interface.

[Anon]

I've just configuerd my red Hat 6.2
with db2 udb v7.1, php4,apache.
I've compiled php --with-ibm-db2.
After a lot of troubles i success in installing all the needed stuff.
Now, how I can connect to db2 using php
native connection?

[Anon]

I successfully configured PHP with mysql and db2. I can connect to mysql using the mysql_functions but cannot find anything similar to connect to DB2!

Where can I find information about this?

Thanks in advance.

[Anon]

You can try to download from this site:
ftp://ftp.teknoline.it/pub/php/db2tab.tar.gz
it shows how to connect to ibm-db2 database using php.

[Anon]

I have been reading mail that seems to go in circles on some of these points.
On the one hand some indicate that compiling with --with-ibm-db2 will enable communication with a DB2 database without DB2 Connect. However, there have been postings by Rasmus that suggest that this will not work with db2 on the as/400.

I would like to be able to have an aix web server running apache use php to talk to a back end db2/400 database through our firewall without db2 connect. Is there someone who has in fact successfully configured something along these lines?

[Anon]

I've been too busy programming to get a chance to test it anymore. I really would like to get db2 up and running though, just to say I had a copy running somewhere for testing.

[Anon]

the file recommended by kuang in 2000-09-07 23:45:22's message is not available anymore ;(

does anyone have the file?

i have redhat 6.2 + apache 1.3.14 + ibm db2 v 6.1 + php 4.0.3,

php installed with ibm db2, phpinfo() says it's ok, but i cant connect to a remote database..

i still dont know how to connect in native mode, all i could do is to try with odbc, but was unable to define dsn's, etc, etc.

pls help!

[Anon]

I can send the files to anyone who wants it, just drop your mails
Cheers

[Anon]

If you got a way to connect to DB2 on a AS/400 with PHP4 YES PLEASE i very much like the files you've got.

I still can't find a native or odbc driver to connect.

greetings
antispamming
huub dot daems at selektvracht dot nl

Kuang Hui wrote:

I can send the files to anyone who wants it, just drop your mails
Cheers

[hedron20]

Hi there,
I have been trying to figure out
how to connect to a remote db2 db
and came across this post. that
ftp you mentioned seems unreachable,
and ftp searches dont come up with anything
you mind sending the files to me?

thanks
[e-mail]

[Anon]

Hi to All,
Yes, I have the same problem. Howto connect to DB2 on a linux-box.
After reading a large part of the internet I think the following is the direction to a solution:
You have to use the CLI-API you have gotton from big blue's DB2. This is the same thing you are going to use for a DB2-database inside the linuxbox and for example a database on a AS400.
But the hard part is the configuration of the whole damn... thing. I have read the info on www.ibm.com/<sorry forget>. But couldn't figure it out. It has to do with db2-connect. Any way, order the cd's from ibm !RTFM! read the fine material aviable (its for real now) and you should be on your way. I don't have the time right now to figure it out.......

[Anon]

Kuang Hui,

If you could please send me the file that refrences connecting PHP to an IBM AS/400 DB2 UDB I would greatly appreciate it.

Thanks
[e-mail]

[Anon]

Try this for starters:
http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?fn=db2v7c1frm3toc.htm#ToC_7

I have messed up my system during this...

I think the smart way (IMHO) is to get the CD's from IBM for DB2-connect, I think I am going to this. There must be a lott of material on this CD's which will help me (us) getting this thing to work.

It's in the local binding to get a connection to db/400...

If you have a working installtion try to run db2cc !!!! i think that's the key.
Greetings

[Anon]

Ok, i got this working.

I installed the db2 connect package with the sdk that came with it. and I am thinking php used the sdk portion when compiling with the --with-ibm-db2 option but not sure

after messing around alot, i removed all parts of db2 except the run-time client.
then after finding some docs on the ibm web site, i ran the catalog command.
this is all you need to connect php to a db2 database. (you dont need the control center, db2cc) Some platforms come with something called Client Config Assistant, which will work, but not linux i think.

anyway the catalog instructions are here under Step C.
http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?fn=db2v7ixdb2ix72.htm#HDRTCPS3

if you can get php to compile without the Connect SDK, then you dont need connect, just the run-time client. (i will find out for sure)

Steps from scratch:
- install db2 client and configure an instance
- set up and test the db2 connection within the db2 client with the catalog command
- untar and configure apache
- untar, configure, and compile php with --with-ibm-db2 option
- reconfigure and compile apache with php support

then php should work with the odbc() functions, but its really using the native db2 interface.
I will be making detailed step-by-step and putting it on http://www.e-gineer.com

shawn

[hedron20]

If anyone is interested, the instructions are posted
http://www.e-gineer.com/instructions/phpdb2.phtml
- shawn

[Anon]

All,

After struggling with DB2 & PHP for several days (through several OS re-installs and many compiles), here are some notes that may help someone out...

1. Make sure that in either /lib or /usrlib that you don't have a .so starting with 'libdb2'. These could be from a Berkeley DB install or, in my case, they belonged to the glibc rpm (I dunno why, this is on SuSE 7.1). It's best to symlink the IBM libdb2* objects to /usr/lib before you start your PHP install.

2. You MUST set the following enviroment variables correctly, other wise the connect command will barf:

LD_LIBRARY_PATH --> to IBM libraries
DB2INSTANCE --> name of your instance

In my case, I add the following to my connect script...

putenv("LD_LIBRARY_PATH=/home/db2inst1/sqqlib/lib:$oldldpath");
putenv ("DB2INSTANCE=db2inst1");

Note that $oldldpath is set by getting the default LD_LIBRARY_PATH.

You may have to restart the webserver to get all this to stick. Also, depending on how you are setup, removing these lines from your PHP script may not cause things to break UNTIL YOU RESTART...

Then again, it may be different for you. I'm using Roxen (http://www.roxen.com) because I never got this to compile under Apache.

HTH,

Chris.

[Anon]

You might also need to set the environment variable DB2NODE if you are connection to more than one database.

Use the same methodology to put that variable in your server environment. To find out what nodes are available on your DB2 machine(s), login to DB2 using the command line interface and type 'LIST NODE DIRECTORY', it should show you the names of the configured nodes.

HTH,

Chris.

[Anon]

e-ginner updated the location of my instructions. I have tested this a few more times, but still only under redhat 7.0 and Mandrake 7.2
http://www.e-gineer.com/instructions/installing-ibm-db2-for-php4x-with-apache13x-on-linux.phtml