CATALOG TCPIP NODE lochness REMOTE lochness SERVER 50000 WITH  Redbook system 

   catalog database 

CATALOG DATABASE itsodb AS itsodb AT NODE lochness WITH  Redbook sample 

database 

After installing your DB2 Administration Client, you should configure it to access 

a remote DB2 server using the Configuration Assistant. Start the graphical 

interface through the DB2 Control Center or by using the command 

db2cc.

 For 

more detailed information, please refer to the IBM DB2 UDB manual 

Quick 

Beginnings for DB2 Clients V8

, GC09 4832.

4.2  Other software product

Environment setup includes all the software used in the target system. In the 

migration planning, all the required software has been identified. All the identified 

software should be installed and configured.

The sample application used in this book is written in PHP. Therefore, we prepare 

the target system for the PHP application.

4.2.1  PHP adjustment for Unified ODBC with DB2 support

When migrating a PHP application from MySQL to DB2 on Linux, some 

preparations and verifications have to be accomplished first for unified ODBC 

with DB2 support. If a precompiled package of PHP is used, by default only a 

predefined set of functions and database support is integrated. In order to use 

the IBM DB2 libraries, PHP has to be recompiled using the 

  with ibm db2

configuration option.

Note:

 All commands and procedure descriptions provided in this section 

refers to SuSE Linux 8.1. This can vary for other versions or Linux 

distributions.

Adjustment steps:

1. Backup php.ini and httpd.conf:

To ensure the configuration files of PHP and Apache are not lost when 

installing the new PHP version, we recommend backing up the 

/etc/php.ini

and 

/etc/httpd/httpd.conf

 files.

 Chapter 4. Installation 

83