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 1. DB2 Driver Properties
Property Default
AccountingInfo empty string
AddToCreateTable None
AllowImplicitResultSetCloseForXA true
AlternateID None
AlternateServers None
ApplicationName empty string
AuthenticationMethod clearText
BatchPerformanceWorkaround false
BulkLoadBatchSize 2048 (rows)
CatalogOptions 2 (result sets contain synonyms and remarks)
CatalogSchema SYSCAT (DB2 for Linux/UNIX/Windows)

SYSIBM (DB2 for z/OS)

QSYS2 (DB2 for i)
CharsetFor65535 None
ClientHostName empty string
ClientUser empty string
CodePageOverride None
ConcurrentAccessResolution auto
ConnectionRetryCount 5
ConnectionRetryDelay 1 (second)
ConvertNull 1 (data type check is performed if column value is null)
CreateDefaultPackage false
CryptoProtocolVersion

No default value
CurrentFunctionPath null
CurrentQueryOptimization -1 (default class configured for the server is used as the optimization class)
Database None
DatabaseName None
DynamicSections 200 (prepared statements)
EnableCancelTimeout false
EncryptionMethod noEncryption
FailoverGranularity nonAtomic
FailoverMode connect
FailoverPreconnect false
Grantee PUBLIC
GrantExecute true
GSSPluginName empty string
GSSPluginObject None
HostNameInCertificate empty string
ImportStatementPool empty string
InitializationString None
InsensitiveResultSetBufferSize 1000 (KB of memory)
JavaDoubleToString false
JDBCBehavior 1
KeepAlive false
KeyPassword None
KeyStore None
KeyStorePassword None
LoadBalancing false
LobStreamingProtocol streaming
LocationName None
LoginTimeout 0 (no timeout)
LongDataCacheSize 2048 (KB of memory)
MaxPooledStatements 0 (driver’s internal prepared statement pooling is not enabled)
MaxStatements 0 (driver’s internal prepared statement pooling is not enabled)
OptimizationProfile null
OptimizationProfileToFlush null
PackageCollection empty string
PackageOwner null
Password None
PortNumber 50000
ProgramID empty string
ProxyHost empty string
ProxyPassword empty string
ProxyPort

0

ProxyUser empty string
QueryTimeout 0 (query does not time out)
RandomGenerator secureRandom
RegisterStatementPoolMonitorMBean false
ReplacePackage false
ResultSetMetaDataOptions 0 (no additional processing to determine the correct table name for each column in the result set)
SecureRandomAlgorithm None
SendStreamAsBlob false
ServerName None
SpyAttributes None
StripNewlines false
TrustStore None
TrustStorePassword None
UseCurrentSchema false
User None
ValidateServerCertificate true
WithHoldCursors true
XMLDescribeType None