EnableLobBlockingOnFetch IBM data server driver configuration keyword
Enables LOB blocking fetch against servers that support LOB blocking.
- Equivalent CLI keyword
- BlockLobs
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- N/A
- db2dsdriver.cfg configuration syntax
<parameter name="EnableLobBlockingOnFetch" value="0 | 1"/>- Default setting:
- SQL_ATTR_BLOCK_LOBS
- Equivalent statement attribute:
- SQL_ATTR_BLOCK_LOBS
- Usage notes:
-
Setting EnableLobBlockingOnFetch to 1 enables all of the LOB data associated with rows that fit completely within a single query block to be returned in a single fetch request, if the server supports LOB blocking. Clients which enable EnableLobBlockingOnFetch = 1 and bind the LOB values directly to buffers can show an increase in memory consumption depending on the amount of data retrieved for one request compared to previous releases. LOB data is described here as being associated with a row, because the LOB data of a result set is itself not contained in the row. Instead, the row contains a reference to the actual LOB data. Therefore, with blocking of result sets returning LOB data types, any rows of the result set that fit completely within the query block (where each row consists of non-LOB data, since LOB data is not stored directly in the row), will have their associated LOB data returned from the server, if the server supports blocking of result sets returning LOB data types.
If the server does not support cursor blocking with LOB columns, then only one row of LOB data will be returned in a single fetch request and the EnableLobBlockingOnFetch value is ignored.
Db2® does not support LOB blocking fetch.