Articles & Content

Archives

DB2 10 Hash Access: Access Path or Collision Course? - B06

Topic: 2012 NA

Subtopic: DB2 for z/OS



Hash Access is a new DB2 10 access path which could reduce the number of GETPAGE requests for a random access. But not all table spaces are candidates for this new feature. This presentation will cover the internals of hash organization and compare it to the index and table structures we’re all used to. Then, we will discuss tips on how to determine which table spaces are good candidates and provide some rules of thumb on how to best define your hashing structures. We will also look at some performance statistics.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.