JDBC Type 4 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

password Property
The password property sets the Guardian password value for to MXCS. The password is encrypted
when it is passed to MXCS.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object. For information about how to set properties, see How to Specify JDBC Type
4 Properties.
Data type: String
Default: empty string
For example: password=eye0weU$s
properties Property
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.
reserveDataLocators Property
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. For information about how to set properties, see How to Specify JDBC Type
4 Properties.
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) could occur in the LOB table.
These holes represent unused space.
Also, the administrator should avoid setting high values for the reserveDataLocators (for example