Deploy IBMDB2Express-C and PHP on UbuntuLinux

This Best Practices article provides detailed methods for installing and configuring IBMDB2Express-C software, PHPHypertextPreprocessor, and ApacheHTTPServer on systems running the UbuntuLinux operating system.

This article provides detailed methods for installing and configuring the IBM DB2 Express-C software, PHP Hypertext Preprocessor, and Apache HTTP Server on a system running the Ubuntu Linux operating system.

After completing the installation and configuration steps in this article, you will have a full-featured PHP Web application that uses DB2 Express-C as the backend data.

Run Ubuntu Linux®Operating System Integration with IBM®DB2®With the powerful functions of Express-C and Apache HTTP Server and PHP programming language, Express-C can provide a powerful, flexible, and reliable application development platform. This platform is ideal for small businesses, developers, instructors, and students as these software components are free and usable.

This document describes how to install and configure the IBM DB2 Express-C software (DB2 Express-C), PHP Hypertext Preprocessor, and Apache HTTP Server on Ubuntu Linux.

In this article, you will use the popular Advanced Packaging Tool (APT) package management system to download, install, and configure necessary software components. APT is a recommendation system for managing software installation on Ubuntu, which greatly simplifies all aspects of software package management.

This article describes how to install Apache 2 HTTP Server with built-in PHP 5 support. This article describes how to install the _ db2 extension for PHP. You can use the PEAR pecl utility to download and recompile the PHP module to enable support for the _ db2 PECL extension.

This article describes how to download and install DB2 Express-C 9.7 Fix Pack 4. The details include settings of default DB2 instances and creation of samples for testing. This article also provides a sample PHP script to test the connection with the Web server and retrieve data from the sample.

You can deploy an IBM DB2 database Server using the PHP programming language and an Apache HTTP Server to develop and provide dynamic Web pages. This article provides instructions on installing and configuring IBM DB2 Express-C and Apache HTTP Server and PHP on the Ubuntu operating system.

IBM DB2 Express-C is a mature core technology based on DB2 for Linux, UNIX, and Windows, but is available for free download, use, and redistribution. DB2 Express-C is simple, flexible, powerful, and reliable. It is an ideal choice for small businesses, developers, teachers and students. DB2 Express-C provides the following features:

• Supports Linux, Windows, Solaris, and Mac operating systems.
• Effectively manage relationships and XML data.
• Self-service management and automatic performance optimization
• Provides a solid foundation for building and deploying various websites and applications that use relational database data. You can use PHP, C/C ++, Java™. NET®Ruby on Rails, Python, and other programming languages to develop websites and applications.
• Full interoperability with other DB2 versions.
• An optional low-cost product with higher resource limits, 24x7 IBM customer support, and other features (such as high-availability clusters and replication ).

Ubuntu is one of the most popular and fastest-growing open-source operating systems in the market. This operating system is available for organizations and individuals on servers, desktops, laptops, and netbooks. PHP Hypertext Preprocessor is an integrated programming language used to develop Web applications. PHP has become a popular Web application development language due to its focus on performance, portability, and ease of use. Apache HTTP Server provides secure, effective, and scalable HTTP services. All services comply with the latest HTTP standards. Since April 1996, Apache HTTP Server has become the most popular open-source Web Server on the Internet and is maintained by the Apache HTTP Server Project.

Like DB2 Express-C, you can obtain and deploy the Ubuntu operating system, PHP, and Apache HTTP Server for free.

Many websites on the Internet Use PHP and Apache Server. Adding DB2 Express-C to PHP and Apache Server on the Ubuntu operating system brings a powerful combination of technologies to build dynamic and data-driven sites and applications.

DB2 Express-C server requirements

Software requirements

In this article, the following software stack is used to deploy the dynamic web page of the database DRIVER:

• DB2 Express-C Version 9.7 Fix Pack 4
• PHP 5
• Ubuntu 10.04 Long Term Support (LTS)
• Apache HTTP Server Version 2.0

DB2 Express-C only supports the LTS version of the Ubuntu operating system.

Hardware requirements

You can run DB2 Express-C on a system of any number of processors and memory. However, DB2 Express-C limits the total resource utilization, as shown below:

• Processor: 2-core
• Memory: 2 GB

Disk requirements

The disk space required by DB2 Express-C depends on the installation type you select and the file system type you own. The DB2 Setup Wizard provides a size estimate based on the components you select during a typical, streamlined, or custom installation.

Remember to provide disk space for communication products, databases, and other software.

Memory Requirements

Memory Requirements are affected by the size and complexity of the database system, the scope of database activities, and the number of clients accessing the system. At a minimum, a DB2 database system requires 256 mb ram. For systems that only run one DB2 product and DB2 GUI tool, at least 512 mb ram is required. However, we recommend that you use 1 gb ram to improve performance. These requirements do not include any other memory requirements for other software running on your system. The page feed (also known as switch) feature must be enabled for the DB2 database server. Most systems have a reasonable minimum swap or swap space of 25%-50% of RAM. You may need more swap or page feed space to prevent excessive memory usage.