In the aggregation i have used hash partition. Now my warning is
"Hash table has grown to 32768 entries". This is only a warning. but what should i do now to eliminate these warnings
Hash table (hash partition)
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Process data containing fewer distinct reference key values would be one way. Use more partitions would help too. Finding a different strategy, such as a sparse lookup or a Join or Merge stage might be another alternative.
As you note, it is only an alert. You could create a message handler to demote its severity from Warning to Informational.
As you note, it is only an alert. You could create a message handler to demote its severity from Warning to Informational.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
Hash table (hash partition)
What is message hnadler and how can i create itray.wurlod wrote:Process data containing fewer distinct reference key values would be one way. Use more partitions would help too. Finding a different strategy, such as a sparse lookup or a Join or Merge stage might be another alternative.
As you note, it is only an alert. You could create a message handler to demote its severity from Warning to Informational.
In the director job log, right-mouse click on the message you wish to handle and one of the options is, if I recall correctly, "message handler" or something very similar. The documentation also details how to create and use message handlers.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: