Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: 3702: Insufficient memory to parse this request
From:   Ramakrishna_Vedantam

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016