Some of the IBM® Data Server Driver for JDBC and SQLJ properties
apply only to DB2® for Linux, UNIX, and Windows servers.
Those properties are:
- alternateGroupDatabaseName
- Specifies the database names for alternate groups to which an application can connect. The data
type of this property is String. For a connection to a DB2 for z/OS® data server, this value is the location
name for a data sharing group. For a connection to a DB2 for Linux, UNIX, and Windows data server, each of these values is the
database name for a single-member or multiple-member database instance. If more than one database
name is specified, the database names must be separated by commas.
For connections to DB2 for z/OS, only one value can be specified.
- alternateGroupPortNumber
- Specifies the port numbers for alternate groups to which an application can connect. The data
type of this property is String. For a connection to a DB2 for z/OS data server, this value is the TCP/IP
server port number that is assigned to the data sharing group. For a connection to a DB2 for Linux, UNIX, and Windows data server, each of these values is the
TCP/IP server port number that is assigned to a single-member or multiple-member database instance.
If more than one port number is specified, the port numbers must be separated by commas.
For
connections to DB2 for z/OS, only one value
can be specified.
- alternateGroupServerName
- Specifies the host names for alternate groups to which an application can connect. The data type
of this property is String. The data type of this property is String. For a connection to a DB2 for z/OS data server, this value is the domain name
or IP address that is assigned to the data sharing group. For a connection to a DB2 for Linux, UNIX, and Windows data server, each of these values is the
domain name or IP address that is assigned to a a single-member or multiple-member database
instance. If more than one host name is specified, the host names must be separated by commas.
For
connections to DB2 for z/OS, only one value
can be specified.
- connectNode
- Specifies the target database partition server that an application
connects to. The data type of this property is int. The value can
be between 0 and 999. The default is database partition server that
is defined with port 0. connectNode applies to IBM Data Server Driver for JDBC and SQLJ type 4 connectivity to DB2 for Linux, UNIX, and Windows servers
only.
- currentExplainSnapshot
- Specifies the value for the CURRENT EXPLAIN SNAPSHOT special register.
The CURRENT EXPLAIN SNAPSHOT special register enables and disables
the Explain snapshot facility. The data type of this property is String.
The maximum length is eight bytes. This property applies only to connections
to data sources that support the CURRENT EXPLAIN SNAPSHOT special
register, such as DB2 for Linux, UNIX, and Windows.
- currentQueryOptimization
- Specifies a value that controls the class of query optimization
that is performed by the database manager when it binds dynamic SQL
statements. The data type of this property is int. The possible values
of currentQueryOptimization are:
- 0
- Specifies that a minimal amount of optimization is performed to
generate an access plan. This class is most suitable for simple
dynamic SQL access to well-indexed tables.
- 1
- Specifies that optimization roughly comparable to DB2 for Linux, UNIX, and Windows Version
1 is performed to generate an access plan.
- 2
- Specifies a level of optimization higher than that of DB2 for Linux, UNIX, and Windows Version
1, but at significantly less optimization cost than levels 3 and above,
especially for very complex queries.
- 3
- Specifies that a moderate amount of optimization is performed
to generate an access plan.
- 5
- Specifies a significant amount of optimization is performed to
generate an access plan. For complex dynamic SQL queries, heuristic
rules are used to limit the amount of time spent selecting an access
plan. Where possible, queries will use materialized query tables
instead of the underlying base tables.
- 7
- Specifies a significant amount of optimization is performed to
generate an access plan. This value is similar to 5 but without the
heuristic rules.
- 9
- Specifies the maximum amount of optimization is performed to generate
an access plan. This can greatly expand the number of possible access
plans that are evaluated. This class should be used to determine if
a better access plan can be generated for very complex and very long-running
queries using large tables. Explain and performance measurements
can be used to verify that a better plan has been generated.
- enableAlternateGroupSeamlessACR
- Specifies whether failover to an alternate group is seamless or non-seamless. The data type of
this property is boolean. Possible values are:
- false
- Failover is non-seamless. false is the default.
With non-seamless behavior,
if an application that is currently connected to a primary group is executing a transaction, and the
entire primary group goes down, the IBM Data Server Driver for JDBC and SQLJ fails over to alternate group. If failover is successful, the driver throws an
SQLException with SQL error code -30108.
- true
- Failover is seamless.
With seamless behavior, if an application that is currently connected to
a primary group is executing a transaction, and the entire primary group goes down, the IBM Data Server Driver for JDBC and SQLJ fails over to alternate group. If the
transaction is eligible for seamless failover, the connection is retried. If the connection is
successful, no SQLException is thrown.
For connections to DB2 for z/OS, only
one value can be specified.
- enableTimeoutForCursors
- For DatabaseMetaData or ResultSet methods
that use Statement objects in their implementations,
specifies whether the commandTimeout and queryTimeoutInterruptProcessingMode
property values control the timeout behavior for those Statement objects.
Examples
of methods that use Statement objects in their
implementations are:
- ResultSet.updateRow
- ResultSet.insertRow
- ResultSet.deleteRow
- DatabaseMetaData.getProcedures
- DatabaseMetaData.getTables
- DatabaseMetaData.getColumns
The data type of this property is int. Possible values are:
- com.ibm.db2.jcc.DB2BaseDataSource.YES (1) or com.ibm.db2.jcc.DB2BaseDataSource.NOT_SET
(0)
- A Statement object that is used in the implementation
of a DatabaseMetaData or ResultSet method
is controlled by the commandTimeout and queryTimeoutInterruptProcessingMode
properties. This behavior is the default behavior.
- com.ibm.db2.jcc.DB2BaseDataSource.NO (2)
- A Statement object that is used in the implementation
of a DatabaseMetaData or ResultSet method
is not controlled by the commandTimeout and queryTimeoutInterruptProcessingMode
properties.
- optimizationProfile
- Specifies an optimization profile that is used during SQL optimization.
The data type of this property is String. The optimizationProfile
value is used to set the OPTIMIZATION PROFILE special register. The
default is null.
optimizationProfile applies to DB2 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 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:
- The connection is to a DB2 for Linux, UNIX, and Windows server
that uses a partitioned database environment.
- 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 for Linux, UNIX, and Windows then
directs the SQL statement to different partitions as needed.
DB2 10.5 for Linux, UNIX, and Windows