Informix Error -29046: SNA buffer size (size) is not valid.
Cause and resolution
SNA buffer size (size) is not valid.
The send buffer that the Informix connectivity network module allocated is less than the minimum DRDA required size, which is 512 bytes, or more than the maximum size, which is 32,767 bytes.
Check the sqlhosts file on the Gateway computer. If the send buffer size is configurable through the sqlhosts file, make sure that the send buffer size is configured to be from 512 bytes to 32,767 bytes, inclusive.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-29046 fires when the send buffer the Informix connectivity network module allocated is smaller than the DRDA minimum (512 bytes) or larger than the maximum (32,767 bytes) — per the official guidance.
- A send buffer size outside the 512-32,767 byte DRDA range, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check
sqlhostson the Gateway computer, per the official guidance, and if the send buffer size is configurable there, set it within 512-32,767 bytes.
Examples
N/A
No specific triggering statement is documented beyond an out-of-range SNA buffer size.
Diagnostic Checks
- Check the send buffer size configured in
sqlhosts, and set it within 512-32,767 bytes.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -29046 in this set yet.
The SNA send buffer size was outside the DRDA-required 512-32,767 byte range — reconfigure
it in sqlhosts.