CLI allocates a single request buffer per session. The allocation takes place when the session is first established.
DBCHCL automatically:
- Expands the buffer if it is too small to hold the request being prepared.
- Shrinks the buffer if Request Buffer Length is less than Current Request Buffer Length.
Set the size of the send queue buffer (through which data is sent to the Teradata Database internally) with the environment variable TCP_BUF_SIZE.
Use environment variable COPANOMLOG to acquire log information and size values of the send/receive queue buffer.
See the Teradata Tools and Utilities Installation Guide for the appropriate operating system for information how to set TCP_BUF_SIZE.