Saturday, January 09, 2010

Set up a DB2 Windows Apache PHP stack

This is a really quick guide. Feel free to ask questions in the comments or on the DB2 Express-C forum.

  1. Install DB2 Express-C
  2. Install Apache HTTP Server 2.2.x
  3. Install PHP 5.3.x (VC6, thread-safe)
  4. Get the compiled IBM_DB2 extension (VC6, thread-safe, not nts)
  5. Copy the unzipped DLL to the extensions directory of your PHP installation. For example:

    C:\Program Files\PHP\ext
  6. Open the php.ini of your PHP installation. For example:

    C:\Program Files\PHP\php.ini
  7. Add these lines at the end:

    [IBM_DB2]

    extension=php_ibm_db2.dll
  8. Restart your web server:


  9. Create a text file in your Apache htdocs folder. For example, in:

    C:\Program Files\Apache Software Foundation\Apache2.2\htdocs
  10. Call it test.php and paste the following into it:

    <?php

    echo phpinfo();

    ?>
  11. Open http://localhost/test.php in your web browser
  12. If you see the following, your installation is ready for use:



Additional Resources

Cheers,

Leons Petrazickis
DB2 Express-C Community Team