News
Abstract
Improved Toolbox JDBC driver support for blocked INSERTs
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > Improved Toolbox JDBC driver support for blocked INSERTs
Prior to this enhancement, the driver did not take advantage of the variable length information on blocked inserts (it already did on data retrieval).
- This enhancement improves blocked insert efficiency when inserting into VARCHAR, VARGRAPHIC, and VARBINARY columns when using "batched insert".
- CLOBs cannot be used with "batched insert", so CLOBs cannot take advantage of this support.
- If you explicitly specify “true” on the “variable field compression” property, you’ll need to change to receive the enhancement.
Figure 1. Toolbox JDBC Property details
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
21 January 2020
UID
ibm11171168