JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

Data type: String
Default: empty string
For example: password=eye0weU$s
properties
The properties property specifies the location of the properties file that contains keyword-value
pairs that specify property values for configuring the Type 4 driver. For more information, see
“Creating and Using a Properties File” (page 37).
queryExecuteTime
This property is used to specify the value in time (milliseconds). Any query that takes more than
the specified time will be logged in the log file. If this property is specified, a separate log file is
created. The default log file name is t4sqlmxQueryExecuteTime.log and will be created in
the user.home directory.
If you want to explicitly specify a log file, see the “T4QueryExecuteLogFile” (page 50).
Set this property on a DataSource object, ConnectionPoolDataSource object, or a
DriverManager object.
Data type: int
Units: Number of milliseconds
Default: None
Range: 1 to 9,223,372,036,854,775,807 (2**63-1)
For example: java -Dt4sqlmx.queryExecuteTime = 10
reserveDataLocators
The reserveDataLocators property sets the number of data locators to be reserved for a
process that stores data in a LOB table. Set this property on a DataSource object,
ConnectionPoolDataSource object, or DriverManager object.
Data type: int
Units: number of data locators to be reserved
Default: 100
Range: 1 to 9,223,372,036,854,775,807 (2**63 -1)
Do not set a value much greater than the number of data locators actually needed. If the specified
value is 0 (zero) or less, the default value (100) is used.
Base the setting of the value of the reserveDataLocators property on the application profile
being run. If the application inserts a large number of LOB items, a higher value of the
reserveDataLocators property can prevent frequent updating of the ZZ_DATA_LOCATOR
value in the LOB table. However, if the application inserts only a small number of LOB items, a
smaller value is better. If a large value is used, holes (unused data-locator numbers) might occur
in the LOB table.
Also, the administrator should avoid setting high values for the reserveDataLocators (for
example in the range of trillions or so). Setting high values prevents other Type 4 applications that
use LOB table from reserving data locators.
For additional information about data locator use, see “Reserving Data Locators” (page 56).
To change this value for a JDBC application, specify this property from the command line. For
example, the following command reserves 150 data locators for program class myProgramClass.
java –Dt4sqlmx.reserveDataLocators=150 myProgramClass
46 Type 4 Driver Properties