[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:DEC Rdb against the World
Moderator:HERON::GODFRIND
Created:Fri Jun 12 1987
Last Modified:Thu Feb 23 1995
Last Successful Update:Fri Jun 06 1997
Number of topics:1348
Total number of notes:5438

419.0. "IBM SQL" by KIKETT::NICHOLSON_PA () Fri Sep 01 1989 18:33

A current customer is about to jump ship for the AS/400 platform.  It's
a long and sordid story, but here's a paraphrasal of their latest reasoning:

The parent organization has dictated an eventual migration to a 3090 and
DB2.  They believe AS/400 SQL and DB2 SQL to be compatible (identical?).
Ergo, eventual conversion pains will be greatly eased by standardization
today on AS/400 and SQL.

Can anyone comment on IBM's flavors of SQL, or related issues?  For example,
would there be compatibility problems between IBM precompilers or compilers
across these platforms?

The customer is NOT a current Rdb/VMS user - they're running a third party
hierarchical database.

Paul
T.RTitleUserPersonal
Name
DateLines
419.1Try 800-DEC-GRIT for helpDPDMAI::DAVISGBGil Davis DTN 554-7245Fri Sep 01 1989 21:4011
    After having read the paper I got from the competitive folks
    (800-DEC-GRIT), I would hesitate to call what comes from IBM a
    'database manager'.  Call them and ask for the AS400 database review...
    
    Seems that the dictionary is pretty primitive also...
    
    It sounds like they are planning to fail.  After all...if their
    application is successful, then they HAVE to convert!  Sounds
    like....'What the heck doctor....do the filling now, and...while I'm in
    the neighborhood...I'll just stop off next week for a root canal..!"
    
419.2SNOC02::ANDERSONKThe Unbearable Lightness of BeingMon Sep 04 1989 16:372
    Have you seen the rumours on failover/restart times for AS/400
    databases?
419.3Partial AnswerKIKETT::NICHOLSON_PATue Sep 05 1989 21:0231
>    < Note 419.2 by SNOC02::ANDERSONK "The Unbearable Lightness of Being" >


>    Have you seen the rumours on failover/restart times for AS/400
>    databases?

 
    Yup.
    This would be great fodder for most customers, but we're dealing
    with a tough nut this time.  A typical scenario:  We suggested that
    the AS/400's journalling was prohibitively expensive.  At benchmark
    time, IBM declined to turn on journalling.  We *did* turn on
    journalling in our benchmark; it didn't cost that much, and we thought
    it made a strong statement about our solution.  Eventually IBM
    responded with a letter declaring that journalling on the AS/400
    costs only a few percent in CPU utilization.  The pro-IBM customer
    accepted this as "proof", and as an indication that we were
    IBM-bashing.
    
    Bottom line: Any statements we make about IBM in front of this customer
    need to be documented by "independent, authoritative" sources. 
    Probably not a bad idea for all customers, actually.
    
    Back to the original question, which was "What is the compatibility
    between AS/400 SQL and DB2 SQL?  Can code written for one platform
    easily move to the other?"  The competitive hotline came through
    with a note from the ibm_silverlake notesfile.  Note 59.2 there
    talks about SQL/400 and addresses the compatibility issue fairly
    well.  If anyone can add to that, I'll use their ammunition.
    
    Paul
419.4MIS Week article may be usefulMERIDN::MATTHEWSIt&#039;s all Atanasoff&#039;s fault!Fri Sep 08 1989 21:416
    Get ahold of someone who has back issues of MIS Week magazine -
    one of the August issues had a wonderful (?) cover story about recovery
    problems with AS/400s; some great interviews with end users who
    have gotten burned...
    
    Geo.
419.5Yet another pointerSRFSUP::MCCARTHYMore fun than kissing a badgerSun Sep 10 1989 02:3111
    Copies of the articles referred to in .-1 appear in the "Blue
    Flashes" notes of the CISM::IBM_SILVERLAKE conference (KP7 to add it
    to your notebook). They are also cross-posted in KACIE::IBM.

    You will find some information about AS/400 and 370-class db
    interoperability (of which there is not much; -ability, that is) in
    the most recent "Blue Flash" note.

    Regards,
    Larry.
419.6If you wanted ammo to convert them to Rdb/VMS instead...WIBBIN::NOYCEBill Noyce, FORTRAN/PARALLELWed Sep 13 1989 22:136
    During development of VAX SQL, DB2 compatibility was the highest
    goal.  Now that the ANSI SQL standard is out, that is a higher
    priority, but DB2 compatibility is still important.
    
    Also, we have VIDA for DB2, which will allow programs on the VAX
    to access DB2 databases as if they were using Rdb.