SQL/MX 2.x Messages Manual (H06.10+, J06.03+)

Optimizer Messages (6000 through 6999)
HP NonStop SQL/MX Messages Manual—544518-011
8-3
SQL 6020
Cause. The defaults attribute MEMORY_USAGE_SAFETY_NET is set and the
MXCMP process memory reached the set threshold.
Effect. This is a warning message. SQL/MX optimizer has reached the set threshold
and the query plan generated might be sub-optimal. As a result, there may be a slow
execution of the query.
Recovery. None.
6020 Optimizer has reached its memory threshold; the query
plan generated might not be optimal.