skip to main content
DataDirect Connect Drivers : DB2 Driver : Connection Properties
  
Connection Properties
This section lists the JDBC connection properties supported by the DB2 driver and describes each property.
property=value
You can use these connection properties with either the JDBC Driver Manager or DataDirect Connect Series for JDBC data sources unless otherwise noted.
Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.
Note: The data type listed for each connection property refers to the Java data type used for the property value in a JDBC data source.
The following table provides a summary of the connection properties supported by the DB2 driver and their default values.
Table 21. DB2 Driver Properties
Property
Default
empty string
None
true
None
None
empty string
clearText
false
2048 (rows)
2 (result sets contain synonyms and remarks)
SYSCAT (DB2 for Linux/UNIX/Windows)
SYSIBM (DB2 for z/OS)
QSYS2 (DB2 for i)
None
empty string
empty string
None
auto
5
1 (second)
1 (data type check is performed if column value is null)
false
null
-1 (default class configured for the server is used as the optimization class)
None
None
200 (prepared statements)
false
noEncryption
nonAtomic
connect
false
PUBLIC
true
empty string
empty string
None
1000 (KB of memory)
false
1
None
None
None
false
streaming
None
0 (no timeout)
2048 (KB of memory)
0 (driver’s internal prepared statement pooling is not enabled)
0 (driver’s internal prepared statement pooling is not enabled)
null
null
empty string
null
None
50000
empty string
0 (query does not time out)
false
0 (no additional processing to determine the correct table name for each column in the result set)
false
None
None
false
None
None
false
None
true
true
None
This section includes the following topics:
* AccountingInfo
* AddToCreateTable
* AllowImplicitResultSetCloseForXA
* AlternateID
* AlternateServers
* ApplicationName
* AuthenticationMethod
* BatchPerformanceWorkaround
* BulkLoadBatchSize
* CatalogIncludesSynonyms
* CatalogOptions
* CatalogSchema
* CharsetFor65535
* ClientHostName
* ClientUser
* CodePageOverride
* ConcurrentAccessResolution
* ConnectionRetryCount
* ConnectionRetryDelay
* ConvertNull
* CreateDefaultPackage
* CurrentFunctionPath
* CurrentQueryOptimization
* Database
* DatabaseName
* DynamicSections
* EnableCancelTimeout
* EncryptionMethod
* FailoverGranularity
* FailoverMode
* FailoverPreconnect
* Grantee
* GrantExecute
* HostNameInCertificate
* ImportStatementPool
* InitializationString
* InsensitiveResultSetBufferSize
* JavaDoubleToString
* JDBCBehavior
* KeyPassword
* KeyStore
* KeyStorePassword
* LoadBalancing
* LobStreamingProtocol
* LocationName
* LoginTimeout
* LongDataCacheSize
* MaxPooledStatements
* MaxStatements
* OptimizationProfile
* OptimizationProfileToFlush
* PackageCollection
* PackageOwner
* Password
* PortNumber
* ProgramID
* QueryTimeout
* ReplacePackage
* ResultSetMetaDataOptions
* SendStreamAsBlob
* ServerName
* SpyAttributes
* StripNewlines
* TrustStore
* TrustStorePassword
* UseCurrentSchema
* User
* ValidateServerCertificate
* WithHoldCursors
* XMLDescribeType