Network buffer size
The IFX_NETBUF_SIZE environment variable specifies the size of each network buffer in the common network buffer pool and the private network buffer pool.
The default buffer size is 4 kilobytes.
The IFX_NETBUF_SIZE environment variable allows the database server to receive messages longer than 4 kilobytes in one system call. The larger buffer size reduces the amount of overhead required to receive each packet.
- Loading a table
- Inserting rows greater than 4 kilobytes
- Sending simple large objects
The b option for sqlhosts allows the client to send and receive greater than 4 kilobytes. The value for the sqlhosts option should typically match the value for IFX_NETBUF_SIZE.
onstat -g afr global | grep net
The size field in the output shows the network buffer size in bytes.