LOBFileThreshold CLI/ODBC and IBM data server driver configuration keyword
Specifies the maximum number of bytes of LOB data buffered when SQLPutData() is used.
- db2cli.ini keyword syntax:
- LOBFileThreshold = positive integer
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="LOBFileThreshold" value="positive integer"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- 25 MB
- Equivalent connection attribute:
- SQL_ATTR_LOB_FILE_THRESHOLDAttention: The equivalent connection attribute is available in Db2® version 11.5.4 and later versions.
- Usage notes:
This option specifies the maximum number of bytes of LOB data
that CLI will
buffer in memory on calls to SQLPutData().
If the specified cache size is exceeded, a temporary file will be created
on disk to hold the LOB data before it is sent to the server.