IBM DB2 User Manual

currentLockTimeout
Specifies whether DB2 Database for Linux, UNIX, and Windows servers wait
for a lock when the lock cannot be obtained immediately. The data type of this
property is int. Possible values are:
integer Wait for integer seconds. integer is between -1 and 32767, inclusive.
LOCK_TIMEOUT_NO_WAIT
Do not wait for a lock. This is the default.
LOCK_TIMEOUT_WAIT_INDEFINITELY
Wait indefinitely for a lock.
LOCK_TIMEOUT_NOT_SET
Use the default for the data source.
queryDataSize
Specifies a hint that is used to control the amount of query data, in bytes, that
is returned from the data source on each fetch operation. This value can be
used to optimize the application by controlling the number of trips to the data
source that are required to retrieve data.
Use of a larger value for queryDataSize can result in less network traffic,
which can result in better performance. For example, if the result set size is 50
KB, and the value of queryDataSize is 32768 (32KB), two trips to the database
server are required to retrieve the result set. However, if queryDataSize is set
to 61440 (60 KB), only one trip to the data source is required to retrieve the
result set.
The following table lists minimum, maximum, and default values of
queryDataSize for each data source.
Table 32. Minimum, maximum, and default values of queryDataSize
Data source
Minimum
queryDataSize value
Maximum
queryDataSize value
Default
queryDataSize value
DB2 Database for
Linux, UNIX, and
Windows
4096 65535 32767
IDS 4096 10485760 32767
DB2 for i5/OS 4096 65535 32767
DB2 for z/OS Not applicable Not applicable Query data size is
always 32767.
IBM Data Server Driver for JDBC and SQLJ properties for DB2
Database for Linux, UNIX, and Windows
Some of the IBM Data Server Driver for JDBC and SQLJ properties apply only to
DB2 Database for Linux, UNIX, and Windows servers.
Those properties are:
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 Database for Linux, UNIX, and Windows servers only.
226 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