Improved performance of ODBC applications that retrieve LOB or XML objects

For ODBC applications, Db2 11 uses limited block fetch by default to retrieve small inline and large LOBs or XML objects. This new behavior can improve performance.

When limited block fetch is enabled, you can control whether LOB and XML objects are returned inline by using the new STREAMBUFFERSIZE initialization keyword.

To disable limited block fetch, set the LIMITEDBLOCKFETCH initialization keyword to 0.