Executive summary
The goal of this document is to provide a step-by-step approach to installing and configuring IBM DB2 Express-C software (DB2 Express-C), PHP Hypertext Preprocessor, and Apache HTTP Server on the Ubuntu Linux operating system (Ubuntu).
In this document, you use the popular Advanced Packaging Tool (APT) package management system to download, install, and configure the necessary software
components. APT is the recommended system for managing software installations on Ubuntu, greatly simplifying all aspects of software package management.
The document explains how to install the Apache 2 HTTP Server with built-in PHP 5 support. The installation of the ibm_db2 extension for PHP is covered. You use the PEAR pecl utility to download and recompile the PHP module to enable support for the ibm_db2 PECL extension.
Downloading and installing DB2 Express-C 9.7 Fix Pack 4 is covered at length. The instructions include the setup of a default DB2 instance and creation of a sample database for testing. Sample PHP scripts are provided to test the connections to the web server and to retrieve data from the sample database.
After completing all the steps, you will have a fully functioning PHP web application server with DB2 Express-C as the back-end data server.
Introduction
You can deploy IBM DB2 database servers that use the PHP programming language and Apache HTTP Server to develop and serve up dynamic web pages. This best practices paper provides the installation and configuration instructions for IBM DB2 Express-C on an Ubuntu operating system, with the Apache HTTP Server and PHP.
IBM DB2 Express-C is based on the proven core technology of DB2 for Linux, UNIX, and Windows but is free to download, use, and redistribute. DB2 Express-C is simple, flexible, powerful, and reliable. It is ideal for small businesses, developers, instructors, and students. DB2 Express-C offers the following features:
- Support for Linux, Windows, Solaris, and Mac operating systems.
- Efficient management of both relational and XML data.
- Self-management capabilities and automatic performance optimization.
- A solid base for building and deploying various types of websites and applications that use relational database data. You can develop the websites and
applications by using PHP, C/C++, Java™, .NET®, Ruby on Rails, Python, and other programming languages.
- Full interoperability with other DB2 editions.
- An optional low-cost offering that includes higher resource limits, 24x7 IBM customer support, and additional features including high availability clustering and replication.
The Ubuntu operating system is one of the most popular and fastest-growing open source operating systems on the market today. This operating system is available to organizations and individuals on servers, desktops, laptops, and netbook computers.
PHP Hypertext Preprocessor is an interpreted programming language that is primarily intended for the development of web applications. PHP is popular for web application development because of its focus on performance, portability, and ease of use.
The Apache HTTP Server provides secure, efficient, and extensible HTTP services that conform to current HTTP standards. Apache HTTP Server has been the most popular open source web server on the Internet since April 1996 and is maintained by the Apache HTTP Server Project.
As with DB2 Express-C, you can obtain and deploy the Ubuntu operating system, PHP, and the Apache HTTP Server free of charge.
A significant number of websites on the Internet use PHP with the Apache Server. Adding DB2 Express-C on the Ubuntu operating system to PHP and the Apache Server creates a powerful combination of technologies for building dynamic data-driven sites and applications.
Download the full report for more on deploying IBM DB2 Express-C with PHP on Ubuntu Linux.
Download the report to get started! #Db2