FET_BUF_SIZE
The FET_BUF_SIZE environment variable lets you override the default setting for the size of the fetch buffer for all data except simple large
objects. When set, FET_BUF_SIZE is effective for the entire environment.
n
represents the size of the buffer in bytes.
When set to a valid value, the environment variable overrides the previously set value. The default setting for the fetch buffer is dependent on row
size.
If the buffer size is set to less than the default size or is out of the range of the small integer value, no error is raised. The new buffer size is
ignored.
For example, to set a buffer size to 5,000 bytes, set the FET_BUF_SIZE environment variable by entering the following command:
setenv FET_BUF_SIZE 5000