Re: Benchmark comparisons of IDMS and DB/2

DBMS_Plumber wrote:
> jtzecher wrote:
>
> > Does anybody have any literature that compares the performance of
> > IDMS and DB/2? Specifically, I am looking for CPU usage or MIPS
> > required to perform like tasks. That is to say, if you had two
> > functionally identical databases running side by side, which one would
> > use how many MIPS or CPU hours versus the other to do the same basic
> > work?
>
> For the same functionality, DB2 will require about an order of
> magnitude more cycles than IDMS. Always been that way. Don't expect it
> to change.
>
> But it takes two orders of magnitude more labor effort to add an
> equivalent piece of new functionality to an IDMS based application than
> to a DB2 application. Always been that way. Don't expect it to change.

I'm not surprised with your first conclusion regarding performance, but I have not seen any shop that has moved from IDMS to DB2 reduce their number of developers (although there might be some, it certainly is not the norm). It could be that they are doing more with these developers, but I would suspect that it is not an order of magnitude more than what they could have done on IDMS.

Can you point me to any emperical data to even suggest that less labor is required to add an equivalent piece of new functionality using DB2 instead of IDMS?

Thanks. --dawn Received on Fri Dec 01 2006 - 14:02:58 CET