サポートと今すぐチャット
サポートとのチャット

Spotlight on DB2 6.9.3 - Getting Started Guide

Post Threshold Hash Joins alarm

The predefined Post threshold Hash Joins alarm becomes active when a hash join request was limited because of concurrent use of sort heap space (shared or private).

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

If this value is larger than 5% of total hash join overflows, increase the sort heap threshold (SHEAPTHRES configuration parameter).

 

Related topics

 

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択