A Comparison of Oracle 9i with DB2 v8.1

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

Alexander Chigrik
Alexander Chigrik
I am the owner of MSSQLCity.Com - a site dedicated to providing useful information for IT professionals using Microsoft SQL Server. This site contains SQL Server Articles, FAQs, Scripts, Tips and Test Exams.

Latest Articles