CA IDMS IUA EIUA

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

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

    Posted 08-24-2010 07:30 AM
    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
    choelscher@humana.com

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






    From:
    Tom Hebert <tom.hebert@GMAIL.COM>
    To:
    IDMSVENDOR-L@LISTSERV.IUASSN.COM
    Date:
    08/24/2010 02:17 PM
    Subject:
    Re: [IDMSVENDOR-L] DB2 gets a db-key
    Sent by:
    IDMS 3rd-party providers forum <IDMSVENDOR-L@LISTSERV.IUASSN.COM>



    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""