Re: Company thought DB2 will be better than Oracle.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 13 Sep 2003 15:00:42 -0700
Message-ID: <1063490424.999085_at_yasure>

Mark A wrote:

Speculating about the properties of a product you are not that familiar
with is like trying to jog across quick sand. While
I have worked extensively with DB2 it was some years ago so I try to
step gingerly when discussing specifics. But to
address your statement ... Oracle doesn't lock blocks. Period. You
couldn't do it if you tried. And with Oracle dropping
rollback segments in favor of undo almost all of the traditional
concerns are gone. I haven't seen an ORA-01555 in more
than a year. And that's in development. Haven't seen one in production
on a 9i server since its release.

I do think we should be careful that what started out as one thing has
the potential to turn into a flame war. I'd suggest
everyone remember this are tools not religions, take a deep breath, and
step back form the abyss. Lets be sure to keep
this discussion professional.

-- 
Daniel Morgan
    

I think it is worth noting that issue raised about DB2 concurrency was
talking about DB2 for OS/390. The person was referring to a development
environment with lots of ad-hoc queries. Most shops have figured out how to
deal with these issues, although apparently there are some who lack
experienced DBA's.

Hopefully, the person who complained about DB2 for OS/390 concurrency
problems does not suggest that anyone use Oracle for OS/390 to run a
business (even though it is an "available" product).

  

Well I know I was running Oracle on Amdahl's at Boeing a few years back and likely they still do. But I agree.

If anyone has followed this thread ... they should remember as I have pointed out ... my comment was directed
to DB2 on Windows and a statement that I wouldn't recommend it. I said nothing about OS/390 or AS/400.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sun Sep 14 2003 - 00:00:42 CEST