DB2 Version 9.7 for Linux, UNIX, and Windows

LOBFileThreshold CLI/ODBC configuration keyword

Specifies the maximum number of bytes of LOB data buffered when SQLPutData() is used.

db2cli.ini keyword syntax:: LOBFileThreshold = positive integer
Default setting:: 25 MB
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.