473,839 Members | 1,519 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Comparison of DB2 and Oracle?

One of my friends, Scott, is a consultant who doesn't currently have
newsgroup access so I am asking these questions for him. I'll be telling him
how to monitor the answers via Google Newsgroup searches.

Scott has heard a lot of hype about DB2 and Oracle and is trying to
understand the pros and cons of each product. I'm quite familiar with DB2
but have never used Oracle so I can't make any meaningful comparisons for
him. He does not have a lot of database background but sometimes has to
choose or recommend a database to his clients.

Scott has enough life-experience to take the marketing information produced
by IBM and Oracle with a grain of salt and would like to hear from real
DBAs, especially ones who are fluent with both products, for their views on
two questions:

1. What are the pros and cons of the current releases of DB2 and Oracle?

2. What other sources of *independent* information are available to help
someone new to databases choose between DB2 and Oracle?

This is *not* a troll and we don't want to start a flame war! Scott just
want some honest facts to help him decide which product is best at which
jobs.

--
Rhino
Nov 12 '05
137 6691

"Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:2t******** *****@uni-berlin.de...
OK, here is the deal:
When you execute a dynamic statement which depends on table T.
DB2 will hold a usage lock on T until the end of the transaction.
So noone will be able to alter T (in a non-trivial way) until this
transaction is over.
An alternate design would be to release the lock after usage.
However in the interest of keeping the cache fast the capturing of locks
needs to be minimized. Schema evolution is considered a much rarer (more
rare??) event than cache-hits

Does that answer the comment?

Cheers
Serge

Here was the behavior that was observed. (on db2 on a mainframe)
1. Issue commit;
2. Issue a select statement (like select ... from mytable where ...)
3. People try to bind their programs and no dice.
4. Minutes pass and programmers start calling because they can't get their
work done.
5. Issue a commit (or rollback).
6. People can now bind their programs.

The explanation according to the manual was that DB2 doesn't do dynamic SQL,
it takes dynamic SQL and turns it into static SQL and then binds that static
SQL and runs it. Since a commit happens minutes later access to the plan
table is serialized. OUCH!

We observed this behavior and so had to turn the system into an autocommit
system just so we didn't turn a multi million dollar machine into the
equivalent of an based 8080 PC.

This went on for at least a couple of years and then I went onto other
companies.
Jim
Nov 12 '05 #51
Jim,

I can't comment on DB2 for zOS. Would be interested to know whether this
behaviour is still in existence and whether it was condidered working as
designed or a bug (e.g. a bad lock).
The behaviour you describe seems to indicate that users also wouldn't be
able to bind static apps concurrently... ..

Cheers
Serge
Nov 12 '05 #52
Serge Rielau <sr*****@ca.ibm .com> wrote in message news:<2t******* ******@uni-berlin.de>...
Now that R correlates, for all major RDBMS that I know, quite well with
SQL as it's access language. Do you know of other languages commonly
used in an RDBMS? Yes, there could be, but there aren't.
Yes I do, and yes there are. Quel from Ingres is one of them.
They still make it available, last time I looked. Sure it's not
much used and anyone using anything other than SQL must have rocks
on their head or doing research. That's not the point, though.
The point is that relational != SQL. Period. A DML is not a
data storage theory.
There is a lot of bloat going on in the market (and I'm not excluding
any vendor)
and that's where the open source products come in...
Absolutely. But let's bot in the name of marketing subvert
theory, OK?
Not everyone needs a Winnebago. Some folks just want to commute to
work... Mind you that doesn't make Winnebagos bad


They better all have at least four wheels...
Nov 12 '05 #53
Noons wrote:
Serge Rielau <sr*****@ca.ibm .com> wrote in message news:<2t******* ******@uni-berlin.de>...
Now that R correlates, for all major RDBMS that I know, quite well with
SQL as it's access language. Do you know of other languages commonly
used in an RDBMS? Yes, there could be, but there aren't.

Yes I do, and yes there are. Quel from Ingres is one of them.
They still make it available, last time I looked. Sure it's not
much used and anyone using anything other than SQL must have rocks
on their head or doing research. That's not the point, though.
The point is that relational != SQL. Period. A DML is not a
data storage theory.

... and that's where many, many customer's installations ail.
They believe by storing their data in tables and having some RI they are
using an RDBMS.
All they have done is found persistent storage for their data which then
is "processed" using nested cursors and procedural languages.
It's the curse of providing PL/SQL, SQL PL, SPL, TSQL....
The _center piece_ of RDBMS: "relational alegbra" ends up as roadkill in
the ditch. 30 years of research and all there is to show for it is that
data is stored in tables.

I should be fine with it.. it does sell hardware.

Cheers
Serge
Nov 12 '05 #54
Comments in-line.

michael newport wrote:
Daniel,

in Ingres I wrote 4GL, in Oracle I write PL/SQL
Because you don't know how to write Java in the database?
in Ingres I wrote SQL, in Oracle I write SQL
Because you don't know how to write Java in the database?
in Ingres I ran an overnight batch from a Unix cron job, in Oracle I
schedule a dbms_job
Or dbms_scheduler
Or UNIX cron job
Or AppWorx
Or any one of a large number of other possible solutions.
in Ingres my results went to a database table, in Oracle my results go
to a database table
I'm impressed.
in Ingres I wrote a user parameterized report, in Oracle I write a
user parameterized report
Similarly impressed.
in Ingres I ran the report with a system call, in Oracle I use Oracle
Reports server (with all its nasty bugs)
Then you made a horrible choice of reporting software.
Ingres is free, Oracle is not

did I miss something ?

Regards
Michael Newport


What did you miss?

1. Security model
2. Scalability
3. Performance
4. Shared Everything Architecture
5. RAC
6. DataGuard
7. RMAN
8. User defined indexes
9. User defined operators
10. User defined locking
11. Domain indexes
12. Reverse-key indexes
13. Compressed indexes
14. Function based indexes
15. Sequences
16. User defined data types
17. Partitioning and Subpartitioning
18. Global Temporary Tables
19. External Tables
20. Index Organized Tables
21. Enterprise level support 7x24x365
22. Books at Amazon.com
(Oracle 27,707 hits, DB2 1,955 hits, Ingres 0 hits if refering to
your product)
23. Jobs at Dice.com
(Oracle 8,097 jobs, DB2 1,779 jobs, Ingres 18 jobs)
24. Jobs at Monster.com
25. Jobs at Hotjobs.com
26. Packages
27. Native compilation into C of PL/SQL
28. TAF (transparent application failover)
29. A prayer the product will still exist in 10 years.

I think I've made my point.

If you want a more valid comparison ... compare Ingres to MySQL,
PostgreSQL, Firebird, 3x5 cards. The difference will still be
more books, more jobs, and more chance it will survive 5 years.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #55

"Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:2t******** *****@uni-berlin.de...
Jim,

I can't comment on DB2 for zOS. Would be interested to know whether this
behaviour is still in existence and whether it was condidered working as
designed or a bug (e.g. a bad lock).
The behaviour you describe seems to indicate that users also wouldn't be
able to bind static apps concurrently... ..

Cheers
Serge


I can't tell you since I don't use DB2 anymore and we don't have a mainframe
where I work. I would expect that DB2 would work the same regardless of OS.
(not counting OS limitations ) IBM didn't consider it a bug. I was doing
work for American Transtech at the time (a subsidiary of ATT, certainly a
large enough customer to get attention). People couldn't bind apps
concurrently, but since the machine was fast enough people wouldn't notice.
Jim
Nov 12 '05 #56
DA Morgan wrote:
in Ingres I ran the report with a system call, in Oracle I use Oracle
Reports server (with all its nasty bugs)


Then you made a horrible choice of reporting software.


You're right. Often overlooked is Oracle's free SQLPlus & iSQLPlus which,
with it's formatting capability will satisfy, a significant percentage of
all reports. Especially when coupled with the new raw SQL grouping
functions available such as period-over-period comparisons, etc. (No need
even to go OLAP)

Sometimes the simplest solutions are best, no matter how much people sneer
at them! (I already hear the howls: but , but ... <G>)

/Hans
Nov 12 '05 #57
HansF wrote:
DA Morgan wrote:

in Ingres I ran the report with a system call, in Oracle I use Oracle
Reports server (with all its nasty bugs)


Then you made a horrible choice of reporting software.

You're right. Often overlooked is Oracle's free SQLPlus & iSQLPlus which,
with it's formatting capability will satisfy, a significant percentage of
all reports. Especially when coupled with the new raw SQL grouping
functions available such as period-over-period comparisons, etc. (No need
even to go OLAP)

Sometimes the simplest solutions are best, no matter how much people sneer
at them! (I already hear the howls: but , but ... <G>)

/Hans


Or Discoverer
Or Crystal
Or Cognos
Or Brio
Or Business Objects
Or ....

--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #58
correction you thought that you had made your point...

You can also use JAVA on Ingres.

1. Security model – same
2. Scalability - same
3. Performance - same

4. Shared Everything Architecture - equivalent
5. RAC - equivalent
6. DataGuard - equivalent
7. RMAN - equivalent
28. TAF (transparent application failover) - equivalent

8. User defined indexes - same
9. User defined operators - same
10. User defined locking - nice but never needed
11. Domain indexes - nice but never needed
12. Reverse-key indexes - same
13. Compressed indexes - same
14. Function based indexes - nice but never needed
15. Sequences - same
16. User defined data types - same
17. Partitioning and Subpartitioning - same
18. Global Temporary Tables - same
19. External Tables - same
20. Index Organized Tables - same
21. Enterprise level support 7x24x365 - same

22. Books at Amazon.com
(Oracle 27,707 hits, DB2 1,955 hits, Ingres 0 hits if refering to
your product)
23. Jobs at Dice.com
(Oracle 8,097 jobs, DB2 1,779 jobs, Ingres 18 jobs)
24. Jobs at Monster.com
25. Jobs at Hotjobs.com

I agree that Oracle wins on the job front but that will change.
Would you rather keep your job and use Ingres ? or
keep Oracle and have your job outsourced to India ?

26. Packages - like programs ?
27. Native compilation into C of PL/SQL – never needed this

29. A prayer the product will still exist in 10 years. –
now that Ingres is Open Source it will still be here, why,

because its free

for the few things that Ingres does not have, Oracle is not worth the money ??

I know I have made my point !

Regards
Michael Newport
Nov 12 '05 #59
Jim's comment about zOS behavior is what I also remember from my
mainframe days. My recollection is that this was (is?) a characteristic
of mainframe QMF because QMF interacts directly with the user and the
SQL statements don't complete until the user closes the session. We even
had a case where a user ran a query then went to lunch without
terminating it and held locks for over an hour!

The solution I implemented was to switch to using DSNTEP2 (a freebie
supplied with DB2) as a replacement for QMF for simple queries. Heavy
duty reporting was moved to "canned" QMF procedures where knowledgeable
programmers could optimize performance and concurrency.

Phil Sherman

Serge Rielau wrote:
Jim,

I can't comment on DB2 for zOS. Would be interested to know whether this
behaviour is still in existence and whether it was condidered working as
designed or a bug (e.g. a bad lock).
The behaviour you describe seems to indicate that users also wouldn't be
able to bind static apps concurrently... ..

Cheers
Serge


Nov 12 '05 #60

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

38
25130
by: Mike | last post by:
No flame wars, please! We're planning a move from a non-relational system to a relational system. Our choices have been narrowed to Oracle and DB2. Since we're moving from non-relational to relational, then we're not currently using any relational-type operators. So I expect the end result to use simple, SQL standard commands and queries. The question: At the SQL standard level is there any
125
15531
by: Rhino | last post by:
One of my friends, Scott, is a consultant who doesn't currently have newsgroup access so I am asking these questions for him. I'll be telling him how to monitor the answers via Google Newsgroup searches. Scott has heard a lot of hype about DB2 and Oracle and is trying to understand the pros and cons of each product. I'm quite familiar with DB2 but have never used Oracle so I can't make any meaningful comparisons for him. He does not have...
133
9105
by: jonathan | last post by:
hey all, I realize that this question might pop up from time to time, but I haven't seen it a while and things might of changed, so - Right now (July 2004) how does mysql stand up in comparison to oracle? We are seriously considering migrating our multi-processor oracle system to mysql to save on licensing costs, and would need several features that mysql may or may not have:
63
25708
by: Nick Palmer | last post by:
Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB Link between the two instances. Is such a thing possible between two DB2 databases ? Thanks in advance, Nick
11
3209
by: Mark A | last post by:
Here is Mark Townsend's (Oracle Product Manager) explanation and justification for posting in the DB2 newsgroup, as posted on the Oracle newsgroup, and my response: "Mark Townsend" <markbtownsend@comcast.net> wrote in message > > By an large you will find that they > all fall into 1 of 3 categorires. > > 1) Explaining how Oracle does something when somebody asks how to do the
11
17068
by: Rosco | last post by:
Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the Ford Fairlane. I need this info to complete a school project. Thanks.
2
13792
by: Nadeem Bitar | last post by:
I've searched unsuccessfully on google and the archives for a technical comparison of Oracle and PostgreSQL. Is there any free and recent comparison that covers more than just the basic differences. Thanks, Nadeem -----BEGIN PGP SIGNATURE-----
2
14257
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers: Additional Array INSERT and SELECT Syntax Support by Pro*C/C++ and Pro*COBOL Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL Precompilers: Fix Execution Plan in Pro*C/C++ and Pro*COBOL Precompilers: Flexible B Area Length...
0
9855
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10906
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10585
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10292
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9426
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7017
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5682
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5866
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3132
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.