Archives of the TeradataForum
Message Posted: Thu, 29 Apr 2004 @ 10:25:23 GMT
3702 Insufficient memory to parse this request. Explanation: The request was more complex than the Teradata Parser could process.
Remedy: Simplify the request and resubmit it.
Ensure You Have Allocated Enough Parser Memory for Large Joins If you plan to join more than 32 tables, use the DBS Control Utility to increase the value for the DBSControl Record MaxParseTreeSegs performance field to at least 200 to allocate additional Parser memory for code generation. The upper limit on MaxParseTreeSegs is 1 000.
MaxParseTreeSegs defines the number of 64 Kbyte tree memory segments the Parser allocates when parsing a Teradata SQL statement.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|