Error: Failure 3710 Insufficient memory to parse this request
Error: Failure 3710 Insufficient memory to parse this request, during optimizer phase.
For your query the max Parser memory size limit exceeded. Current values for MaxParseTreeSegs – DBS Control record fields do not allocate enough parser memory to process the request
We have to increase the MaxParseTreeSegs DBS control setting to higher number. The max Parser memory limit is determined by the value of the MaxParseTreeSegs field in DBS Control.
When you make this change, no restart is needed for the change to take effect. Any new session after changing this parameter will use the newer limit let for MaxParseTreeSegs.