Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - Getting Started Guide

Hash Loops alarm

The predefined Hash Loops alarm becomes active when a single partition of a hash join is larger than the available sort heap. This could indicate that you have a poorly performing hash join.

This alarm has been predefined with a Low severity level. The underlying metric for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

Try increasing the SHEAPTHRES for the instance or the SORTHEAP for the database or partition to alleviate this issue.

Related topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating