User Guide

Chapter 4: Managing Data Sources 107
Installing and Configuring DB2 Client Enabler (UNIX)
Before you can create a ColdFusion data source with the DB2 native driver, you must
install the DB2 version 5.2 Client Enabler Software and create an instance. The client
software can be found on the DB2 version 5.2 Software Development Kit CDROM.
Refer to the documentation that comes with the software for details. You should be
familiar with DB2 to successfully complete this process. Gather the following
information before you begin:
• Host name where the DB2 database server resides
• Node name
• Database name
• Database alias
• Database userid and password
• Service name from the
/etc/services file on client and host
Set environment variables
After you install the Client Enabler, there will be a directory with some scripts in it that
you need to run to set up your environment. Environment variables need to be set to
run the command line tool db2. Look in the <installdir>/sqllib directory for the
db2profile and db2cshrc scripts.
For sh or ksh run:
.<installdir>/sqllib/db2profile
For csh run:
source <installdir>/sqllib/db2cshrc
Catalog a TCP/IP node
You must add an entry to the client’s node directory to describe the remote node.
This entry specifies the chosen alias (
node_name), the hostname (or ip_address), and
the servicename (or port_number) that the client will use to access the remote server.
1. Run the db2 command line utility db2
2. At the db2 prompt enter the following:
db2 => catalog tcpip node dbserver1node remote db2unixhost server
db2server1
db2 =>terminate
Catalog the database
Before a client application can access a remote database, the database must be
cataloged on the server node and on any client nodes that will connect to it. When you
create a database, it is automatically cataloged on the server with the database alias