User Guide

16 Chapter 1 Advanced Data Source Management
ODBC: DB2/6000 options (Solaris)
The following table describes ColdFusion options for the MERANT IBM DB2/6000
ODBC driver:
Configuring system and services files (UNIX)
You must add some settings that are necessary for the Client Enabler software
libraries to work.
To configure system and services files:
1 Add the following settings to the /etc/system file:
set msgsys:msqginfo_msgmax = 65535
set msgsys:msqginfo_msgmnb = 65535
set msgsys:msqginfo_msgseg = 8192
set msgsys:msqginfo_msgssz = 16
2 You must restart the server for the settings to take effect.
3 Add the following settings to the /etc/services file:
dbserver1 50000/tcp # DB2 connection service port
• dbserver1 is the Connection Service name.
• 50000 is the port number for the Connection Port. The port number used on
the client must match the port number used on the server.
• tcp is the communication protocol that you are using.
If you are planning on supporting a UNIX client that is using Network Information
Service (NIS), you must update the services file located on your NIS master server.
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. You can
find the client software on the DB2 version 5.2 Software Development Kit CD-ROM.
Refer to the documentation that comes with the software for details.
Option Description
Data Source Name A name for your ODBC data source.
Description Descriptive information about the data source.
Database Name The name of the DB2/6000 database.
Cursors Preserve cursors at the end of each transaction. Select this
option if you want cursors to be held at the current position
when the transaction ends. Doing so can impact the
performance of your database operations.