Connection option descriptions
- Last Updated: July 18, 2024
- 3 minute read
- DataDirect Connectors
- ODBC
- IBM Db2 8.0
- Documentation
The following connection option descriptions are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name, along with its short name, is listed immediately underneath the GUI name.
In most cases, the GUI name and the attribute name are the same; however, some exceptions exist. If you need to look up an option by its connection string attribute name, please refer to the alphabetical table of connection string attribute names.
Also, a few connection string attributes do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.
The following tables provide a summary of supported connection options by functionality, including their attribute names, short names, and default values.
User ID/password (No Encryption) options
General options
The following table summarizes general options that can apply to all connections that use data sources.
| Attribute (Short Name) | Default |
|---|---|
| DataSourceName (DSN) | No default value |
| Description (n/a) | No default value |
| IPAddress (IP) | No default value |
| TCPPort (PORT) | 50000 |
User ID/password (No Encryption) options
The following table summarizes options that are required for user ID/password authentication.
| Attribute (Short Name) | Default |
|---|---|
| AuthenticationMethod (AM) | 0 |
| Collection (COL) | No default value |
| Database (DB) | No default value |
| Location (LOC) | No default value |
| LoginID (UID) | No default value |
| Password (PWD) | No default value |
Kerberos authentication options
The following table summarizes options that are required for Kerberos authentication.
| Attribute (Short Name) | Default |
|---|---|
| AuthenticationMethod (AM) | 0 |
| GSSClient (GSSC) | native |
TLS/SSL encryption options
The following table summarizes the connection options used to enable TLS/SSL.
| Attribute (Short Name) | Default |
|---|---|
| CryptoLibName (CLN) | No default value |
| CryptoProtocolVersion (CPV) | TLSv1.3,TLSv1.2 |
| EnableFIPS (EF) | 0 (Default provider) |
| EncryptionMethod (EM) | 0 (No Encryption) |
| HostNameInCertificate (HNIC) | No default value |
| KeyPassword (KP) | No default value |
| Keystore (KS) | No default value |
| KeystorePassword (KSP) | No default value |
| OpenSSLConfigFile (OSSLCNF) |
install_dir\drivers\openssl.cnf (Windows) install_dir/lib/openssl.cnf (UNIX/Linux) |
| OpenSSLProviderPath (OSSLPP) |
install_dir\drivers (Windows) install_dir/lib (UNIX/Linux) |
| SSLLibName (SLN) | No default value |
| Truststore (TS) | No default value |
| TruststorePassword (TSP) | No default value |
| ValidateServerCertificate (VSC) | 1 (Enabled) |
Failover options
The following table summarizes the connection options that control how failover works with the driver.| Attribute (Short Name) | Default |
|---|---|
| AlternateServers (ASRV) | No default value |
| ConnectionRetryCount (CRC) | 0 |
| ConnectionRetryDelay (CRD) | 3 |
| FailoverGranularity (FG) | 0 (Non-Atomic) |
| FailoverMode (FM) |
0 (Connection) |
| FailoverPreconnect (FP) | 0 (Disabled) |
| LoadBalancing (LB) | 0 (Disabled) |
Bulk load options
The following table summarizes the DataDirect Bulk Load related connection options.
| Attribute (Short Name) | Default |
|---|---|
| BulkLoadBatchSize (BLBS) | 1024 |
| BulkBinaryThreshold (BBT) | 32 |
| BulkCharacterThreshold (BCT) | -1 |
| BulkLoadFieldDelimiter (BLFD) | No default value |
| BulkLoadRecordDelimiter (BLRD) | No default value |
| EnableBulkLoad (EBL) | 0 (Disabled) |
Binding options
The following table summarizes the connection options required for creating or modifying bind packages.| Attribute (Short Name) | Default |
|---|---|
| DynamicSections (DS) | 1000 |
| PackageCollection (PC) | NULLID |
| PackageOwner (PO) | No default value |
| GrantExecute (GE) | Enabled |
| GrantAuthid (GA) | PUBLIC |
Timeout options
The following table summarizes timeout options.
| Attribute (Short Name) | Default |
|---|---|
| LoginTimeout (LT) | 15 |
| QueryTimeout (QT) | 0 |
Pooling options
The following table summarizes pooling options.
| Attribute (Short Name) | Default |
|---|---|
| ConnectionReset (CR) | 0 (Disabled) |
| LoadBalanceTimeout (LBT) | 0 (Disabled) |
| MaxPoolSize (MXPS) | 100 |
| MinPoolSize (MNPS) | 0 |
| Pooling (POOL) | 0 (Disabled) |
Client monitoring options
The following table summarizes client monitoring options.
| Attribute (Short Name) | Default |
|---|---|
| AccountingInfo (AI) | No default value |
| ApplicationName (AN) | No default value |
| ClientUser (CU) | No default value |
| ClientHostName (CHN) | No default value |
| ProgramID (PID) | No default value |
Additional options
The following table summarizes additional options.
| Attribute (Short Name) | Default |
|---|---|
| AddStringToCreateTable (ASCT) | No default value |
| AlternateID (AID) | No default value |
| ApplicationUsingThreads (AUT) |
|
| CatalogSchema (CS) | No default value |
| CharsetFor65535 (CF6) | 0 |
| ConcurrentAccessResolution (CAR) | 0 (Automatic) |
| CurrentFunctionPath (CFP) | No default value |
| DefaultIsolationLevel (DIL) | 1 (READ_COMMITTED) |
| ExtendedOptions (XO) | No default value |
| FetchTSWTZasTimestamp (FTSWTZAT) | 0 (Disabled) |
| IANAAppCodePage (IACP) LINUX ONLY | 4 (ISO 8559-1 Latin-1) |
| KeepAlive (KA) | 0 (Disabled) |
| MinLongVarcharSize (MINLVS) | No default value |
| PackageNamePrefix (PNP) | DD |
| ReportCodepageConversionErrors (RCCE) | 0 (Ignore Errors) |
| UseCurrentSchema (UCS) |
0 (Disabled) |
| VarcharThreshold (VT) | No default value |
| WithHold (WH) | 1 (Enabled) |
| XMLDescribeType (XDT) | -10 |