Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 31 Jan 2014 @ 08:22:59 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Recommended MaxParseTreeSegs parameter value
From:   Bodla, Sravan Kumar

Hi Forum,

Could you please let us know what should be the default value for MaxParseTreeSegs parameter in DBS Control.

And also, please let us know what is the recommended value?

The users are not able to execute some of the complex queries and facing '3710: Insufficient memory to parse this request, during QueryRewrite phase' issue.

We have asked user to reduce the complexity of the query/tune it.

In the manual its mentioned as default is 1000 and range is 12 to 12000. However, like to know, the recommended value and does this requires a system restart to take effect?



GCC International - Technical Consultant ?

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