Teradata Database Message 7550 - 7550 - Analytics Database - Teradata Vantage

Message

Hash join operation is aborted due to non availability of segments.

Explanation

This error is reported when concurrent hash join operations are executed in parallel. As per design hash join consumes few hundred segments, but when a number of hash joins are executed at the same time results in consumption of all 64K segments(SEGSDB) allocated for a Vproc.

Generated By

AMP Software(STPHJIN).

For Whom

End User, Site support representative.

Notes

None

Remedy

If the site encounters this too often, disable hash join flag in dbscontrol gdo.