FET_BUF_SIZE CLI/ODBC and IBM data server driver configuration keyword
Specifies the default query block size to optimize the data flow.
- db2cli.ini keyword syntax:
- FET_BUF_SIZE = 64K | 96K | 128K | 160K | 192K | 224K | 256K
- IBM data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="FET_BUF_SIZE" value="64K | 96K | 128K | 160K | 192K | 224K | 256K |..|10208k"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- FET_BUF_SIZE = 64K
- Equivalent connection attribute:
- SQL_ATTR_FET_BUF_SIZE
- Usage notes:
-
CLI allows query block size only in multiples of 32K (that is 64K, 96K, 128K, 160K, 192K, 224K, till 10208K in multiples of 32K). CLI applications round up any other values in the range of 64K-10208K, to the next nearest 32K boundary.
Application can obtain the value it has set for this attribute using
SQLGetConnectAttr(). If application has not set any value, the default query block size is returned.