What is the difference bn DB2 and Oracle?

Answer 1

One thing they both have in common is that they are both powerful and excellent SQL database management systems, evolved from years of constant research and improvement. They are both more than capable of handling large amounts of data and heavy workloads on Linux, Unix, and Windows, provided the DBAs and sysadmins are adequately trained. Proof of the capabilities of both Oracle and DB2 can be found at http://tpc.org which publishes the results of strictly regulated database benchmarks that must be independently audited for accuracy in all areas.

Although limited editions of many database products, including DB2 and Oracle, are available for production use at no cost, DB2 Express-C edition is far less limited: Express-C allows the use of dual-core CPUs, 64-bit addressing, up to 4GB of system RAM, and no data size limit whatsoever.

Oracle stores its tables within schemas of an instance, while DB2 has the concept of a database that sits above the tables but below the instance level.

Oracle manages usernames and passwords within the DBMS, while DB2 uses O/S level groups, usernames, and passwords for authenticating connections to DB2. However, DB2's authentication can be adjusted to use LDAP, Active Directory, or third party authentication plugins like Kerberos.

Each DBMS offers a different dialect of proprietary SQL that you may decide to use in your applications. However, it is possible to minimize or even eliminate proprietary SQL in favor of ANSI standard SQL. Some shops will even go as far as to demand that proprietary SQL in the application be kept to a minimum just in case they decide to migrate to a different DBMS someday.

Oracle and DB2 offer different types of storage enhancements for their tables. As with most differences between the two, the pros and cons of each difference are hotly debated.

On the high end, when a database is partitioned across multiple machines for improved scalability, DB2 uses a shared-nothing architecture in its Data Partitioning Feature, while Oracle Real Application Cluster requires a shared disk.

In about a month, IBM will be releasing version 9 of DB2 for Linux, Unix, and Windows, which will offer many new features, including a hierarchical storage engine (pureXML) that is optimized for truly native handling of XML data, not just shredding it or treating it as a BLOB/CLOB. DB2 9 will also offer a completely new mechanism for compressing data within each table that is arguably superior to Oracle's compression scheme, since patterns within a column can be compressed, as well as patterns of data that span multiple contiguous columns.

Another new interesting feature unique to DB2 9 is an autonomic performance tuning subsystem called self-tuning memory management, that can be enabled to constantly monitor important configuration settings and adjust them to maximize performance, even as the workload changes. This is a big help for DBAs who would tune for OLTP and get clobbered when the workload switched over to a series of batch jobs each night.

Answer 2

They both use SQL, but there are some differences between them.

DB2 is an IBM product and uses IBM SQL. Oracle uses PL SQL. Most of the differences are minor. The basics are the same...but they use a different delimiter, and there are differences in the sub commands and field definitions.

The one I recall off the top of my head is the way they both define DATE fields. Different word and slightly different definition, same with TIME fields

Answer 3

Oracle is basically a ANSI SQL DB.
DB2 grew from proprietary IBM Mainframe of orign.

Read some of the post here:
http://www.thescripts.com/forum/thread65864.html

Hope this helps.

Answer 4

use ful conversation
http://www.thescripts.com/forum/thread65864.html
comperasion
http://www.wiselimited.com/ORADB2.htm
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_db2.htm
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm

gud pdf:-
http://www.oracle.com/technology/deploy/availability/pdf/CWP_9IVSDB2_HA.PDF