Re: Which one is better? Oracel 9i or DB2 7.2??

From: Dr.J <jizwang_at_ameritech.net>
Date: Thu, 02 May 2002 23:55:42 GMT
Message-ID: <2mkA8.1185$t%5.437402@newssvr28.news.prodigy.com>

It is all depending on your own situation (in house skills, budgets..). feature wise, Oracle 9i has an edge. We have been using Oracle for over 6 years and UDB on AIX for about 2 years. Oracle is much more feature rich and DBA friendly, yet much more expensive. more specific:

case1: if you move a bunch tables/indexes from PROD to QA, not entire DB   Oracle: export a schema to a single file and import it   DB2: export hundrands/thousands of tables/indexes using db2move and ftp them over and import all

case2: backup/recovery
  Oracle save all its store procedures, package into the databse so that you can simply recover them along with your data   DB2; packages/procedures stored on a filesystem. database recovery doesn't mean you are in business

case3: if the only backup you have is an online copy and no logfiles   Oracle: you can bring up (open) database and then fix data   DB2: you are toasted (or restore data and leave DB in rollforward pending mode, send log controlfile to IBM, let them modified it and then try to bring your DB out of rollforward pending). I am still waiting for IBM to send my controlfile back. :<

case4: installation, instance creation and patching (tech. DBA task)   Oracle: un-privileged id under UNIX
  DB2: needs "root" privilege

case5: vendor tech.support
  Oracle: excellent web support, past ticket, other experience, plus phone   DB2: open PMR on web. not much more. phone call-back support.

case6: pre-sale support
  Oracle: nothing to none, if you are spending less than 1 mil.   DB2: excellent sales team. good relationship building.

Dr.J

Daniel Morgan wrote:

> KPNG wrote:
>

>> Hi All,
>>
>> I'm comparing these two brand database server for our new trading system.
>>
>> I know that both of them are famous and occupied large market share. But
>> can some tell me, or has link to the research document which can compare
>> these two products objectively.
>>
>> K.P

>
> Making a decision between them based on a comparison will not get you very
> much. The products are reasonably similar. I would suggest that you
> concentrate your efforts on examining your internal infrastructure and
> resources to see which one you can best implement and support.
>
> No matter which one is technically superior, or faster, or whatever ... if
> your developers don't know how to use it ... and your DBAs and SysAdmins
> don't know how to install and configure it ... you will just make an
> expensive mess.
>
> Daniel Morgan
Received on Thu May 02 2002 - 18:55:42 CDT