IBM DB2 User Manual

optimizationProfile applies to DB2 Database for Linux, UNIX, and Windows
servers only.
optimizationProfileToFlush
Specifies the name of an optimization profile that is to be removed from the
optimization profile cache. The data type of this property is String. The default
is null.
plugin
The name of a client-side JDBC security plug-in. This property has the Object
type and contains a new instance of the JDBC security plug-in method.
pluginName
The name of a server-side security plug-in module.
retryWithAlternativeSecurityMechanism
Specifies whether the IBM Data Server Driver for JDBC and SQLJ retries a
connection with an alternative security mechanism if the security mechanism
that is specified by property securityMechanism is not supported by the data
source. The data type of this property is int. Possible values are:
com.ibm.db2.jcc.DB2BaseDataSource.YES (1)
Retry the connection using an alternative security mechanism. The IBM
Data Server Driver for JDBC and SQLJ issues warning code +4222 and
retries the connection with the most secure available security
mechanism.
com.ibm.db2.jcc.DB2BaseDataSource.NO (2) or
com.ibm.db2.jcc.DB2BaseDataSource.NOT_SET (0)
Do not retry the connection using an alternative security mechanism.
retryWithAlternativeSecurityMechanism applies to IBM Data Server Driver for
JDBC and SQLJ type 4 connectivity connections to DB2 Database for Linux,
UNIX, and Windows only.
useTransactionRedirect
Specifies whether the DB2 system directs SQL statements to different database
partitions for better performance. The data type of this property is boolean.
The default is false.
This property is applicable only under the following conditions:
v The connection is to a DB2 Database for Linux, UNIX, and Windows server
that uses the Database Partitioning Feature (DPF).
v The partitioning key remains constant throughout a transaction.
If useTransactionRedirect is true, the IBM Data Server Driver for JDBC and
SQLJ sends connection requests to the DPF node that contains the target data
of the first directable statement in the transaction. DB2 Database for Linux,
UNIX, and Windows then directs the SQL statement to different partitions as
needed.
IBM Data Server Driver for JDBC and SQLJ properties for DB2
for z/OS
Some of the IBM Data Server Driver for JDBC and SQLJ properties apply only to
DB2 for z/OS servers.
Those properties are:
228 Application Programming Guide and Reference for Java
™

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability