Need idea on Hash Partitioning In Server Jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu Aug 25, 2005 6:33 am
Need idea on Hash Partitioning In Server Jobs
Give me an idea on Hash partition with an example :D :D
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi,
Can you please give more details?
(I assume you ment parallel job is this so?)
Can you please give more details?
(I assume you ment parallel job is this so?)
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Hi,
If you need information regarding partition out guide gives more information.
If this partition is selected for a key, hashing algorigthm is aplied over that particular column. (You can find hasing algorighm in net.
one sample link...
http://www.partow.net/programming/hashf ... sOfHashing)
The record set are seperated based on the result of the hashing and sent to individual partition. so a bunch of record with a same type flows in to a partiton. So it is recomended to use this partition at place where join/merge or key based operatin.
regards
kumar
If you need information regarding partition out guide gives more information.
If this partition is selected for a key, hashing algorigthm is aplied over that particular column. (You can find hasing algorighm in net.
one sample link...
http://www.partow.net/programming/hashf ... sOfHashing)
The record set are seperated based on the result of the hashing and sent to individual partition. so a bunch of record with a same type flows in to a partiton. So it is recomended to use this partition at place where join/merge or key based operatin.
regards
kumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hash partitioning (or a hybrid, such as range-hash partitioning) is found in some database products. It is this you are asking about, or DataStage parallel jobs?
What do you understand by the term "hashing"?
What do you understand by the term "hashing"?
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.
Hi,
Seems I misunderstood and you need an Idea on partitioning of hash files in server jobs.
Are you refering to distributed hash files?
Seems I misunderstood and you need an Idea on partitioning of hash files in server jobs.
Are you refering to distributed hash files?
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org