MaxLOBBlockSize CLI/ODBC and IBM data server driver configuration keyword
Specifies the maximum return block size for LOB or XML data.
- db2cli.ini keyword syntax:
- MaxLOBBlockSize = 0 | ... | 2147483647
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="MaxLOBBlockSize" value="0 | ... | 2147483647"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- There is no limit to the data block size for LOB or XML data.
- Equivalent connection or statement attribute:
- SQL_ATTR_MAX_LOB_BLOCK_SIZE
- Usage notes:
- During data retrieval, the server will include all of the information for the current row in its
reply to the client even if the maximum block size has been reached.
If both MaxLOBBlockSize and the db2set registry variable DB2_MAX_LOB_BLOCK_SIZE are specified, the value for MaxLOBBlockSize will be used.