Re: [IDMSVENDOR-L] DB2 gets a db-key

[ca.portal.admin]

i thought DB2 did have VIA - i think you can store multiple tables in one
segmented tablespace with the children stored in the vicinity of the parent
??????? that seems fairly close .....

Chris Hoelscher
IDMS/DB2 System & Database Architect
Humana Inc
502-476-2538
[e-mail]

I refuse to repeat gossip - so listen carefully the first time






From:
Tom Hebert <[e-mail]>
To:
[e-mail]
Date:
08/24/2010 02:17 PM
Subject:
Re: [IDMSVENDOR-L] DB2 gets a db-key
Sent by:
IDMS 3rd-party providers forum <[e-mail]>



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: [phone]
Fax: [phone]
email: [e-mail]
web: http://www.obj-ex.com
""IDMS for the Java Generation""