dcsimg

A Comparison of Oracle 9i with DB2 v8.1

September 10, 2003

Introduction

Often people in newsgroups ask for a comparison of Oracle and DB2. In this article, I compare Oracle 9i Database with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialectsand products limits.

Platform comparison

Both Oracle 9i Database and DB2 Universal Database version 8.1 supportall known platforms, including Windows-based platforms, AIX-Based Systems,HP-UX systems, Linux Intel, Sun Solaris and so on.

Hardware requirements

To install Oracle 9i under the Windows-based platforms, you should havethe following hardware:

Hardware

Requirements

Processor

Pentium 166 MHz or higher

Memory

RAM: 128 MB (256 MB recommended)
Virtual Memory: Initial Size 200 MB, Maximum Size 400 MB

Hard disk space

140 MB on the System Drive
plus 4.5 GB for the Oracle Home Drive (FAT)
or 2.8 GB for the Oracle Home Drive (NTFS)

To install Oracle 9i Database under the UNIX Systems, such as AIX-BasedSystems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and SunSolaris, you should have the following hardware:

Hardware

Requirements

Memory

A minimum of 512 MB RAM

Swap Space

A minimum of 2 x RAM or 400 MB, whichever is greater

Hard disk space

4.5 GB

To install DB2 Universal Database v8.1 under the Windows-based platforms,you should have the following hardware:

Hardware

Requirements

Processor

Pentium or Pentium compatible CPU

Memory

RAM: 256 MB minimum,
additional memory may be required.

Hard disk space

Typical installation: 350 Mb minimum
Compact installation: 100 Mb minimum
Custom installation: 100 Mb minimum.

Additional disk space may be required
on FAT drives with large cluster size.

To install DB2 Universal Database v8.1 under the UNIX Systems, suchas AIX-based systems, HP-UX systems, Linux and Sun Solaris, you shouldhave the following hardware:

Hardware

Requirements

Processor

For AIX:
       IBM RISC/6000 or eServer pSeries.

For HP-UX:
       HP 9000 series 700 or 800 system.

For Linux:
       Intel 32-bit,
       Intel 64-bit,
       S/390 9672 generation or higher,
       Multiprise 3000,
       eServer z-Series.

For Solaris:
       Solaris UltraSPARC-based computer.

Memory

RAM: 256 MB minimum,
additional memory may be required.

Hard disk space

Typical installation: 450 to 550 Mb minimum
Compact installation: 350 to 400 Mb minimum
Custom installation: 350 to 700 Mb minimum.

Software requirements

Oracle 9i Database comes in three editions: Enterprise, Standard and Personaland requires the following software:

Platform

Operating System Version

Required Patches

Windows-based

Windows NT 4.0

Service Pack 5

Windows-based

Windows 2000

Service Pack 1

Windows-based

Windows XP

Not Necessary

AIX-Based

AIX 4.3.3

Maintenance Level 09 and IY24568,
IY25282, IY27614, IY30151

AIX-Based

AIX 5.1

AIX 5L release 5.1 ML01+ (IY22854),
IY26778, IY28766, IY28949, IY29965, IY30150

Compaq Tru64 UNIX

Tru64 5.1

5.1 patchkit 4

Compaq Tru64 UNIX

Tru64 5.1A

5.1A patchkit 1

HP-UX

HP-UX version 11.0 (64-bit)

Sept. 2001 Quality Pack, PHCO_23792,
PHCO_24148, PHKL_24268, PHKL_24729,
PHKL_ 25475, PHKL_25525, PHNE_24715,
PHSS_23670, PHSS_24301, PHSS_24303,
PHSS_24627, PHSS_22868

Linux

SuSE Linux Enterprise Server 7
(or SLES-7) with kernel 2.4.7,
and glibc 2.2.2

Not Necessary

Sun Solaris

Solaris 32-Bit 2.6 (5.6), 7 (5.7)
or 8 (5.8)

Not Necessary

Sun Solaris

Solaris 64-Bit 8 (5.8)

Update 5

DB2 Universal Database v8.1 comes in six editions:7 DB2 Enterprise Server Edition (ESE)7 DB2 Workgroup Server Edition (WSE)7 DB2 Workgroup Server Unlimited Edition (WSUE)7 DB2 Personal Edition (PE)7 DB2 Universal Developer's Edition (UDE)7 DB2 Personal Developer's Edition (PDE)and requires the following software:

Platform

Operating System Version

Required Patches

Windows-based

Windows NT 4.0

Service Pack 6a or higher

Windows-based

Windows 2000

Service Pack 2 is required for
Windows Terminal Server

Windows-based

Windows XP

Not Necessary

AIX-Based

AIX 4.3.3 (32-bit)

Maintenance Level 9 or later, and
APARs IY22308, Y32690, and IY33024

AIX-Based

AIX 5L (32-bit)

Maintenance Level 2 or later

AIX-Based

AIX 5.1.0 (32-bit)

Maintenance Level 2 or later, and
APARs IY31254, IY32217, IY32905,
IY33023, and IY29345

AIX-Based

AIX 5.1.0 (64-bit)

Maintenance Level 2 or later, and
APARs IY31254, IY32217, IY32905,
Y33023, and IY32466

HP-UX

HP-UX 11i

December 2001 GOLDBASE11i,
December 2001 GOLDAPPS11i bundles

Linux

For Intel 32-bit:

7 kernel level 2.4.9 or later

7 glibc 2.2.4 or later

7 RPM 3 or later

For Intel 64-bit and z-Series:

7 Red Hat Linux 7.2

7 SuSE Linux SLES-7

Not Necessary

Sun Solaris

Solaris 7 (32-bit)

patch 106327-10

Sun Solaris

Solaris 7 (64-bit)

patch 106300-11

Sun Solaris

Solaris 8 (32-bit)

patch 108434-03 and 108528-12

Sun Solaris

Solaris 8 (64-bit)

patch 108435-03 and 108528-12

Sun Solaris

Solaris 9

Not Necessary








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers