DB2 gets a db-key

Discussion created by ca.portal.admin on Aug 24, 2010
Latest reply on Aug 24, 2010 by ca.portal.admin
IBM has finally given in - DB2 10 will include hash key support: =
is a technique that turns a key into a physical location of a row, =
in one-page access for a matching row on an equal predicate."" Sound

The year is 2010. What year did the IDMS db-key become available?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
IDMS 3rd-party providers forum


Re: DB2 gets a db-key

Not only is it in IDMS but Cullinet had that capability in their first SQL
offering, Enterprise DB for VAX and UNIX back in 1988! The decision makers
in the relational marketplace yawned. Some might say they were SLOW by
taking 22 years to figure out that B-Trees are not the only way to index
data but not me. That would be rude. Like you, I too am pleased to see
them learn something from IDMS. Dare we dream? Could VIA SETs be next?

BTW I think ORACLE does have a hash key mechanism of some sort. From the
10g performance and tuning page: ""Support for hash partitioned global
indexes has been added in Oracle 10g"". 10g? Wasn't that recent? Well at
least they're ahead of DB2.

IDMS is still the best,

Tom Hebert
ObjEx, Inc.
28248 N Tatum Blvd
Ste B1-268
Cave Creek, AZ  85331
Tel: 01 (908) 813-2866
Fax: 01 (208) 567-1879
""IDMS for the Java Generation""