Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:

DB2 PHP Generator online Help

Prev Return to chapter overview Next

How to connect to DB2

Connection properties

Specify the connection parameters for a database you want DB2 PHP Generator to work with.


Script connection properties

These parameters will be used by the generated web application. By default they are the same as parameters used by DB2 PHP Generator but you can change them if necessary. For example, if you are working with a remote database located at your web hosting and your database server and web server are installed on the same computer, you have to specify the value of the Host parameter as localhost.


To setup a connection to a DB2 database stored on a remote server, you need:


1. Get any DB2 client with ODBC driver installed on your computer. We recommend to use clients with the DB2 Command Line Processor (CLP) tool. It seems that IBM Data Server Runtime Client is the best solution in this situation. It is free and is not overloaded with various drivers. To obtain this client, visit the publisher's site and download IBM Data Server Runtime Client (Windows 32-bit AMD and Intel x86).


2.  Get this database catalogued by db2 on the client machine. The DB2 client can work only with catalogued databases assumed with cataloged nodes (servers). To work with a DB2 database with DB2 PHP Generator, you have to get this database catalogued on the client machine (the operation is accomplished only once) and to specify the name of user registered on DB2 server and the corresponding password. To catalogue a DB2 database, follow the steps below:


2.1 Catalog the node of server. To get all the catalogued nodes of the client machine, enter the following command to the DB2 Command Window or similar (It's time to use DB2 Command Line Processor ;) ):

db2 list node directory


To catalog a new server node, use the following command:

db2 catalog tcpip node <nodename> remote <hostname or ip address> 

server <db2servicename> [remote <instance_name> ostype <OSname>]


  nodename – the node name to be used on your computer

  hostname or ip address – hostname/ipaddress of server storing the DB2 database

  db2servicename – ServiceName or port number of db2instance (db2 get dbm cfg | grep SVCENAME)

  instance_name – instance name of db2 database.

  OSname – Solaris,windows, AIX, Linux etc.



db2 catalog tcipnode testnode remote testhost server 50000

db2 catalog tcipnode testnode remote testhost server 50000 remote db2inst1


2.2 Catalog the necessary database on the corresponding node. To get the list of catalogued databases, use the following command:

db2 list db directory


To add the necessary database to the catalog, enter the following command:

db2 catalog database <dbname> as [<db_alias>] at node <nodename> 


  dbname – database name

  db_alias – optional database alias, if you want database name different on client.

  nodename – nodename you created on first step



db2 catalog database testdb as testdb at node testnode

db2 catalog database sample at node testnode


Prev Return to chapter overview Next