Archives of the TeradataForum

Message Posted: Thu, 29 Apr 2004 @ 10:25:23 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

or

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>