Re: Question for DBA who do both Oracle and DB2

I haven't administered DB2 databases, but I feel that you can't separate the differences in features when talking about the differences in administering database systems. If one system lacks a certain feature that another system has, then the first system can become harder to administer simply because one has to work around the lack of features. Since I don't know didly about DB2, I'll just give an example in Oracle. Oracle 9i introduced many features to make administration of the database easier when compared to 8i, such as Automated Undo Management, Automatic Segment Space Management, Dynamic SGA, etc. These different features make administration different on the two different versions of the same vendor's database.

Just my 3.14159265 cents worth,
Brian

buckeye234 wrote:
>
> 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 Thu Oct 03 2002 - 15:53:32 CDT