Teradata Database Message 5778 - 17.10 - 5778 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
A response buffer of at least 65,000 bytes is needed for a high-performance transfer.
Explanation
A response buffer of at least 65,000 bytes is needed for a high-performance LOB transfer. The query (SELECT ?) with a Locator passed in is usually used for a high performance LOB transfer. The query must also be sent in with MultipartRecord as the response mode.
Generated By
Optimizer modules (OptRet).
For Whom
End user
Notes
None
Remedy
Make the response mode MultipartRecord and the response buffer at least 65,000 bytes.