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

This is an example of a DSN to access DB2 UDB on Windows or UNIX:

;;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