I used the "mod_php4-4.0.4pl1-1.src.rpm" from SuSE Linux 7.1 to create a rpm.

Installed Apache: 1.3.19-6
          gcc   : 2.95.2-149
          DB2 Connect Enterprise Edition: V7.1

Add library directories to /etc/ld.so.conf:
1. /usr/IBMdb2/V7.1/lib
2. /usr/IBMdb2/V7.1/include

Connect to db2 under the console of DB2 Connect works!

Modifications in /usr/src/packages/SPECS/mod_php.spec:
1. outcomment all things for roxen and adabase
2. configure-options:
./configure  --prefix=/usr --bindir=/usr/bin --libdir=/usr/lib '--with-exec-dir=%{libdir}/php/bin' --with-mysql=/usr --with-gd=yes --with-tiff-dir=/usr --with-jpeg-dir=/usr --with-png-dir=/usr --with-xpm-dir=/usr/X11R6 --with-pdflib=/usr --with-zlib=yes --with-xml --with-ttf --with-ftp --with-curl --with-gd=yes --with-ibm-db2=/home/db2inst1/sqllib --enable-bcmath --enable-trans-sid --enable-track-vars --enable-magic-quotes --enable-safe-mode --enable-sockets --enable-calendar --enable-ftp --enable-memory-limit --with-config-file-path=/etc/httpd --with-apxs=/usr/sbin/apxs --with-exec-dir=/usr/lib/apache/bin i386-suse-linux-gnu

Start producing rpm:
   rpm ?bb ?/usr/src/packages/SPECS/mod_php4.spec? 

Try to install the rpm:
   rpm -i "mod_php4-4.0.4pl1-1.i386.rpm"

When I do this I get the messages:
  error: failed dependencies:	
          /usr/bin/php is needed by mod_php4-4.0.4pl1-1
          libdb2.so.1 is needed by mod_php4-4.0.4pl1-11     
          libstdc++-libc6.1-1.so.2 is needed by mod_php4-4.0.4pl1-1
  
- the folder "/usr/bin/php" really doesn't exist
- i located the file "libdb2.so.1" in the folder "/usr/IBMdb2/V7.1/lib/"
-  i located the file "libstdc++-libc6.1-1.so.2" in the folder "/usr/lib/"

What's the problem?????

On the machine I generated the rpm php is working, but I can't get the connect to DB2 via PHP.

phpinfo():
  ODBC library: db2
  ODBC_INCLUDE: -I/home/db2inst1/sqllib/include
  ODBC_LFLAGS:  -L/home/db2inst1/sqllib/lib
  ODBC_LIBS:    -ldb2

Error-message when I try connect DB2 via PHP:
  Warning: SQL error: , SQL state in SQLConnect in /usr/local/httpd/htdocs/PHP/connect_test_db2.php on line 10

line 10 in the script: $conn = odbc_connect($dsn,$user,$passwd);

Is there a mistake or is the problem the failed dependencies from the rpm-installation????