Re: Question for DBA who do both Oracle and DB2

I think (IMHO) in a simple environment DB2 UDB 7.2 seems to be very easy to implement. (Assuming one has read the admin books etc)

1.Program install is very easy for DB2 ; which is not the case with Oracle(9.0.2) with its java rqmnts; In Unix, you need X windows to setup oracle(AFAIK)...Db2 install is cmdline...

2.Instance creation is a breeze in DB2 ; To an extent its similar in Oracle too.
But Oracle can be bit intimidating.

3.In DB2 u create databases within an instance, while in Oracle , generally instance and DB are the same.I am not sure how you compare those...

4. Simple object creation: Both the DBs are very similar.

Unfortunately , no real world install is "Simple". Even if it seems to be simple
over time, you would need to do something which is not simple; IMHO, thats when
you need the flexibility of Oracle.Over time, once u learn the database , these above differences cease to be an issue.Although DB2 is quickly catching up, its a Cesna compared to Oracle being the F-16/747.

I will stop here as I think I answered ur question.May be I shouldnt have written that last paragraph...

willjamu_at_mindspring.com (James Williams) wrote in message news:<3d9d6cc0.35267670_at_nntp.mindspring.com>...
> On Thu, 03 Oct 2002 17:45:12 +0000, buckeye234 <member_at_dbforums.com>
> wrote:
>
> They are both very powerful. Having worked with both I would say
> Oracle is easier on admininster. Go to db2mag.com and look for an
> article Oracle showing ADMIN difference's. If you read it you will see
> from that article only that Oracle is easier to admin.
>
> >
> >This question is for DBA's who do both Oracle administration and DB2
> >administration.
> >
> >Ignoring the difference in features between Oracle and DB2/UDB and
> >assuming the most basic use of each, which database is easier to
> >administer in a UNIX environment? I am talking about setting installing
> >the database software on the UNIX server, creating databases and then
> >creating objects whithin the database. Just the most basic stuff.
> >
> >If you do, or have done, both, I'd be interested to hear what you see.
> >
> >BTW: I have searched this newsgroup and found numerous comparisons of
> >Oracle and DB2, but they mostly compared features, differences in the
> >RDBMS implementations, and are rather involved. I am really only
> >interested in "Ease of Administration" at this point.
> >
> >Thnaks in advance for you input.
> >Patrick
> >
> >--
> >Posted via http://dbforums.com
> >
Received on Fri Oct 04 2002 - 09:25:51 CDT