Insufficient memory to parse request during Optimizer phase.

Tools
Fan

Insufficient memory to parse request during Optimizer phase.

Hello,

i'm running BTEQ via MVS Batch (BTQMAIN program).
From yesterday, i'm getting below error for my SQL:

Failure 3710 Insufficient memory to parse this request, during Optimizer phase.
Statement# 1, Info =0

I figured out that it has something to do with MaxParseTreeSegs. But don't know how to use it in my case. I don't have much access to teradata which is behind the seen.

Is there any way to tackle this issue. May be by including some statement at the top of my SQL query?

Please suggest!

Thanks,
Tushar Saxena
4 REPLIES
Enthusiast

Re: Insufficient memory to parse request during Optimizer phase.

ifact one of our developr faced the same error.
it has got something to do with maxparsetreeseg. what is the current value that is set in your system? i suggest you ask ur dba to increase it to 4000 and then give it a shot.
if u still find the error then u may have to revisit your SQL statement.
IMP: when ever you are trying to use a join avoid using sel * from.... . i mean it is better to restrict the col's.

cheers
TD_DBA
Fan

Re: Insufficient memory to parse request during Optimizer phase.

Hello TD_DBA,

is there anyway to add some statement at top of my sql to revise maxparesetreeseg for particular case? is thr any way to avoid invlovement of DBA?

Thanks,
Tushar Saxena

Re: Insufficient memory to parse request during Optimizer phase.

Hi..

You can try to use the following DIAGNOSTIC command before your query:

DIAGNOSTIC NOSATTC ON FOR SESSION;

Best regards,
Cezar
Teradata Brazil
Fan

Re: Insufficient memory to parse request during Optimizer phase.

Hello Cezar

Thanks for replying, but it didn't work :(
I wish there is some magical statement that can solve the purpose.

Thanks and Regards,
Tushar Saxena