db2.jcc.maxTransportObjectWaitTime
Specifies the maximum amount of time in seconds that an application waits for
a transport object if the db2.jcc.maxTransportObjects value has been reached.
Transport objects are used for the connection concentrator and Sysplex
workload balancing. When an application waits for longer than the
db2.jcc.maxTransportObjectWaitTime value, the global transport object pool
throws an SQLException.
The default value for db2.jcc.maxTransportObjectWaitTime is -1. Any negative
value means that applications wait forever.
db2.jcc.minTransportObjects
Specifies the lower limit for the number of transport objects in a global
transport object pool for the connection concentrator and Sysplex workload
balancing. When a JVM is created, there are no transport objects in the pool.
Transport objects are added to the pool as they are needed. After the
db2.jcc.minTransportObjects value is reached, the number of transport objects
in the global transport object pool never goes below the
db2.jcc.minTransportObjects value for the lifetime of that JVM.
The default value for db2.jcc.minTransportObjects is 0. Any value that is less
than or equal to 0 means that the global transport object pool can become
empty.
db2.jcc.pdqProperties
Specifies properties that control the interaction between the IBM Data Server
Driver for JDBC and SQLJ and the SQL Insight feature of pureQuery.
Set the db2.jcc.pdqProperties property only if you are using the SQL Insight
feature of pureQuery. See the IBM Data Studio Information Center for
information about valid values for db2.jcc.pdqProperties.
db2.jcc.pkList
Specifies a package list that is used for the underlying RRSAF CREATE
THREAD call when a JDBC or SQLJ connection to a data source is established.
Specify this property if you do not bind plans for your SQLJ programs or for
the JDBC driver. If you specify this property, do not specify db2.jcc.planName.
db2.jcc.pkList applies only to IBM Data Server Driver for JDBC and SQLJ type
2 connectivity on DB2 for z/OS. db2.jcc.pkList does not apply to applications
that run under CICS or IMS, or to Java stored procedures. The JDBC driver
ignores the db2.jcc.pkList setting in those cases.
Recommendation: Use db2.jcc.pkList instead of db2.jcc.planName.
The format of the package list is:
,
collection-ID.*
The default value of db2.jcc.pkList is NULLID.*.
If you specify the -collection parameter when you run
com.ibm.db2.jcc.DB2Binder, the collection ID that you specify for IBM Data
Server Driver for JDBC and SQLJ packages when you run
com.ibm.db2.jcc.DB2Binder must also be in the package list for the
db2.jcc.pkList property.
You can override db2.jcc.pkList by setting the pkList property for a Connection
or DataSource object.
Chapter 7. JDBC and SQLJ reference information 245
|
|
|
|
|
|
To Next Page
Loading...
Need help?
General