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

This looks like typical Oracle behaviour. Just list the pro's and leave out the con's. (or list some minor con's to give the impression that this is an objective report)

What about for instance log file replication (with Oracle you need to buy extra expensive third party products), the TCO, etc. i have included some comments in your cases.

"Dr.J" wrote:

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

Looks to me there are other ways to do this like backup/restore plus some cleanup.
depends on the number of objects to be moved of course.

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

Not true, packages and stored procedures are database objects in DB2.

>
> 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. :<
>

Perhaps a good lesson not to delete your log files? 'fix data' is an obvious task I presume.

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

hardly a pro for Oracle

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

DB2 has a large database of FAQ's , How to's , problem reports , white papers, etc. on the net that can be searched and downloaded. Have a look at: http://www-3.ibm.com/software/data/db2/udb/support.html

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

no comment :)

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

--
Anton Versteeg
Certified DB2 Specialist
IBM Netherlands