User Guide

106 Administering ColdFusion Server
Native Driver: DB2 Universal Database 5.2/6.1 Options (Solaris, Linux)
ColdFusion native drivers are the same for both Windows NT and UNIX. To see
ColdFusion options for the DB2 Universal Database 5.2/6.1 native driver, see the table
in “Native Driver: DB2 Universal Database 5.2/6.1 Options (Windows)” on page 105.
ODBC: DB2/6000 Options (Solaris)
The following table describes ColdFusion options for the DB2/6000 ODBC driver. You
set these options when you configure a ColdFusion data source. See “Adding Data
Sources for ColdFusion” on page 82 for more information about adding data sources
to ColdFusion.
Configuring System and Services Files (UNIX)
Add the following settings to the /etc/system file. These settings are necessary for the
Client Enabler software libraries to work.
set msgsys:msqginfo_msgmax = 65535
set msgsys:msqginfo_msgmnb = 65535
set msgsys:msqginfo_msgseg = 8192
set msgsys:msqginfo_msgssz = 16
You must reboot the server for these settings to take effect.
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
•
tcp is the communication protocol that you are using
The port number used on the client must match the port number used on the server. If
you are planning on supporting a UNIX client that is using Network Information
Services (NIS), you must update the services file located on your NIS master server.
MERANT IBM DB2/6000 ODBC Options
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 —Enable this
option if you want cursors to be held at the current position
when the transaction ends. Doing so may impact the
performance of your database operations.