DB2 Version 9.7 for Linux, UNIX, and Windows

FET_BUF_SIZE CLI/ODBC 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

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, and 256K). CLI applications round up any other values in the range of 64K-256K, 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.