15.00 - 7550 Hash join operation is aborted due to non availability of segments. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

7550 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.

Remedy:

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