ca.portal.admin

Re:DB2 gets a db-key

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

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 Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DB2 gets a db-key
"Amazing!

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.=20

IDMS is still the best,

Tom Hebert
ObjEx, Inc.
28248 N Tatum Blvd
Ste B1-268
Cave Creek, AZ=A0 85331
Tel: 01 (908) 813-2866
Fax: 01 (208) 567-1879
email: Tom.Hebert@obj-ex.com
web: http://www.obj-ex.com
""IDMS for the Java Generation""

Outcomes