One of the most important utilities in the Teradata regime is dbscontrol. Failure 3710 occurs when there is insufficient memory to parse this request, during the optimizer phase.
This happens when the query you are executing crosses the max parser memory size limit defined in dbscontrol. Current values for MaxParseTreeSegs stored in dbccontrol record fields do not allocate enough parser memory to process the request. In this recipe, we will use the dbscontrol parameter to display and change the MaxParseTreeSegs database parameters.
Changing their values without consulting Teradata engineers is not recommended. Each database is designed with these unique values based on the configuration and software version, so, take precautions when you change these values.
Some of the parameters, when changed, require a system...
