Anton, I am not in a stage I have to select an Enterprise database. I just wondered IF (Adabas is faster, as I was told) and WHY (IBM and others don't ask for TPC tests for Mainframe DBs).
Should I regret asking that? -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Anton Britz Sent: Wednesday, October 10, 2007 6:46 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: ADABAS vs IMS vs DB2 Who is faster? Hi, Phew... why did I not just stay out of this in the first place ? Ok...as Andy Rooney said on 60 minutes, "All we need is a leader with integrity, can listen and make reasonably conclusions"... so let me try and do some of this : You are suppose to first find out why people are asking you the question but I am going to skip that part and just assume I am in a bar , after a football game and somebody just wants to show he knows something.. The Questions that was asked in this thread : a) I spoke few days ago with an ADABAS specialist that claimed that ADABAS is much faster and has low overhead compared to IMS and DB2 Answer : Yes b) The relative speed that is important is the one for *YOUR* workload. Anything else is meaningless noise. Thoroughly research the *features* important to you and go with the product that provides the best feature to price ratio for you. Answer : Yes.. from a Capacity point of view.. when you are thinking of upgrading your CPU. This argument is not applicable to the original question c) IMS is a hierarchal database, and thus uses vastly different data storage/retrieval paradigms when compared to ADABAS or DB2. Answer : True but again, that is not what the original requestor wanted to know. d) "ADABAS doesn't scale to really large applications the way DB2 does and it doesn't let you keep the database up while some portion of the database is having utilities run." Not true.. I know of some sites that could not convert Adabas Databases to DB2. IBM kids told them to convert but after 6 months decided they need other IBM kids to help them and kept the data in Adabas. e) Moral Compass ? Answer: I said enough about this posting f) Did I stumble into a dark closet and find myself trapped in a job interview? Answer : No, you are in a bar and everybody thinks they are experts and wants to be treated as such and you contributed to making this discussion a bar environment. Get you self a beer from the barman... She is Blonde and she would love to talk to people like you. g) ADABAS fully supports a sysplex and can actually scale quite well ? Answer: Kelly, your Mother should be proud of you but it depends who asks the question and if they really know what a SYSPLEX is etc. etc. etc. h) I wonder why TPC-C tests are only done for the distributed platforms databases (or their DP versions). Within its members are IBM, Oracle (MF version) Sybase(the same) and others. Maybe, because TPC heard (too early, I must say) that the mainframe is dead? Answer: Because that is where the cooperates are spending money these days. Not sure why you are still in the "Which Database should I run on my Mainframe" stage.. Everybody wants to make the Mainframe data available to the WEB at this point or they want to run applications on "cheap" distributed Operating Systems ex. Like my DVR's at home.. it's all Motorola DCH6416 boxes and if you go to the Motorola Web site, they allow you to write Java applications for the DVR in you house. IN YOUR HOUSE. http://broadband.motorola.com/dvr/ Summary: In any case, as I said in my opening statement ,you need to first find out why you are being asked the question and I did not do that but very few of us really know what Israel is up too these days. Enough said... and this is my last posting, for those that had enough of this serious talk in a bar. Anton Britz On Wed, 10 Oct 2007 11:50:30 -0400, Jon Brock <[EMAIL PROTECTED]> wrote: >. . . except that you haven't done anything to answer the original >question, from Itschak: " I spoke few days ago with an ADABAS >specialist that claimed that ADABAS is much faster and has low overhead >compared to IMS and DB2. Is this true?" ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html