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

I don't see how # 4 is hardly a pro for Oracle. I would think you would want to limit access to root or not overload the root user with things that aren't root. Same with Oracle user, limit access.

Does DB2 still have the concurrency problem where an application issuing dynamic SQL locks out those people trying to compile or bind their programs with the database? (until the app or user issues a commit - so basically putting everything in autocommit mode - ugh) I just remember working with DB2 on an Amdhal main frame and if one just issued a select statement from an application the programmers working in Cobol or C couldn't get their work done until you issued a commit. Since our application issued dynamic sql all over the place we had to go to a lot of extra work to commit all over the place. Basically, the problem was that DB2 did not really do dynamic sql - it would create a plan on the fly and bind to that then run the bound plan, but problem was that it was an insert into the plan table (probably have the table name wrong) and that locked anyone else from binding a plan until a commit statement was issued. So the whole database serielized around this one little table. (Great for static sql, very effecient)

Jim

"Anton Versteeg" <av_at_nospam.for.me> wrote in message news:3CD25A7B.854E4BF7_at_nospam.for.me...
> 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
>
>
Received on Fri May 03 2002 - 06:57:43 CDT