skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Connection Option Descriptions
  
Connection Option Descriptions
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, for example, Password, do not have equivalent options that appear on the GUI. They are in the list of descriptions alphabetically by their attribute names.
The following table lists the connection string attributes supported by the DB2 Wire Protocol driver.
Table 15. DB2 Wire Protocol Attribute Names
Attribute (Short Name)
Default
None
None
None
None
None
1 (Enabled)
0 (No Encryption)
32
-1
1024
None
None
None
0
None
None
None
0 (Automatic)
0 (Disabled)
0
3
None
None
None
1 (READ_COMMITTED)
None
1000
0 (Disabled)
0 (No Encryption)
0 (Non-Atomic)
0 (Connection)
0 (Disabled)
0 (Disabled)
PUBLIC
1 (Enabled)
native
None
4 (ISO 8559-1 Latin-1)
localhost
None
None
None
0
0 (Disabled)
None
15
None
100
0
NULLID
DD
None
0 (disabled)
None
0
0 (Ignore Errors)
50000
None
None
0 (disabled)
1 (enabled)
1 (enabled)
-10
This section includes the following topics:
* Accounting Info
* Add to Create Table
* Alternate ID
* Alternate Servers
* Application Name
* Application Using Threads
* Authentication Method
* Batch Size
* Bulk Binary Threshold
* Bulk Character Threshold
* Catalog Schema
* Character Set for CCSID 65535
* Client Host Name
* Client User
* Collection
* Concurrent Access Resolution
* Connection Pooling
* Connection Reset
* Connection Retry Count
* Connection Retry Delay
* Current Function Path
* Data Source Name
* Database Name
* Default Isolation Level
* Description
* Dynamic Sections
* Enable Bulk Load
* Encryption Method
* Failover Granularity
* Failover Mode
* Failover Preconnect
* Fetch Time Stamp With Time Zone as Timestamp
* Field Delimiter
* Grant Execute to [check box]
* Grant Execute to [field]
* GSS Client Library
* Host Name In Certificate
* IANAAppCodePage
* Ip Address
* Key Password
* Keystore
* Keystore Password
* Load Balance Timeout
* Load Balancing
* Location Name
* Login Timeout
* Max Pool Size
* Min Pool Size
* Package Collection
* Package Name Prefix
* Package Owner
* Password
* Program ID
* Query Timeout
* Record Delimiter
* Report Codepage Conversion Errors
* Tcp Port
* Truststore
* Truststore Password
* Use Current Schema for Catalog Functions
* User Name
* Validate Server Certificate
* With Hold Cursors
* XML Describe Type