An example of the DSN template for DB2 UDB. You must edit the section of the file that applies to your site.
;;DB2 UDB AS/400 or z/OS DSN template ;; [dcdb2udbas400] Driver=/ODBC_install_dir/lib/driver_library IPAddress= TcpPort= Location= Collection= 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