Example of an odbc.ini File for DB2 UDB on Windows or UNIX

An example of the DSN template for DB2 UDB on Windows or UNIX. You must edit the section of the file that applies to your site.

;;UDB Windows or UNIX template
;;
[dcdb2udbwin]
Driver=/ODBC_install_dir/lib/driver_library
IPAddress=
TcpPort=
Database=
SecurityMechanism=0
WorkArounds2=131072
;;
;; Advanced options
;;
AddStringToCreateTable=
AlternateID=
CatalogSchema=
IsolationLevel=CURSOR_STABILITY
CharsetFor65535=0
ReportCodePageConversionErrors=0
ApplicationUsingThreads=1
UseCurrentSchema=1
WithHold=1
;;
;; Bind options - for DSNs used with bind20 utility
;;
GrantExecute=1
GrantAuthid=PUBLIC
DynamicSections=64
;;
;; Optional Failover options 
;;
LoadBalancing=0
AlternateServers=
ConnectionRetryCount=0
ConnectionRetryDelay=3