New DB2 TPC-C and TPC-D benchmark results

New DB2 TPC-C and TPC-D benchmark results

Post by Gene Kligerma » Thu, 18 Apr 1996 04:00:00

The following press release went out yesterday.

Transaction Processing and Complex Query Superiority Exhibited by DB2
Tuesday, April 16, 1996


Transaction Processing and Complex Query Superiority Exhibited by DB2

Four record-setting benchmarks -- all utilizing IBM's
award-winning DATABASE 2* (DB2*) -- were achieved in April 1996
by IBM following industry guidelines established by the
Transaction Processing Performance Council.  In a recent test,
DB2* attained industry's best-ever TPC-C price/performance
result.  DB2 also achieved best TPC-C performance and
price/performance results on a Sun platform, significantly
exceeding Oracle and Sybase numbers on similarly configured Sun

In addition, IBM published the industry's first TPC-D benchmark
result on the Windows NT** platform, as well as a TPC-D result on
DB2 Parallel Edition using 300GB of data -- the largest TPC-D
database tested by any vendor.


The first TPC-C benchmark, running DB2 on Sun's dual processor
Ultra Enterprise 2 server, established a new world record in
price/performance.  With a throughput of 3107.17 tpmC and
$140.52/tpmC, DB2 beat its competition in speed as well as

The second TPC-C benchmark was run on Sun's SPARCserver 2000E**
with six* 85 MHz SuperSPARC** CPUs.  DB2 database server
software, running on the Solaris** 2.5.1 symmetric
multiprocessing (SMP) operating system, delivered results of  
6444.63 transactions per minute (tpmC) at a price/performance of
$201 per tpmC.  When compared with published results of Oracle
7.3.2 and Sybase 11 on similarly configured Sun systems, DB2
performed 25.76 percent faster in throughput than Oracle and
41.81 percent faster than Sybase.  DB2 is also 38 percent better
in price/performance than Oracle and 49 percent less expensive
than Sybase.

The TPC-C benchmark simulates an order entry environment for a
warehouse operation.  The benchmark has gained industry
acceptance because it is considered to be similar to "real world"
processing.  By simulating the activities found in complex online
transaction processing (OLTP) application environments, the TPC-C
benchmark exercises a system's breadth of components associated
with such environments.


IBM is also the first to announce TPC-D benchmark results on
Windows NT.  This benchmark utilized an IBM PC Company 200 MHz
Pentium Pro uniprocessor system, IBM PC 360 S200 with DB2 for
Windows NT.  DB2 for NT delivered a power metric of 44.9

The second TPC-D benchmark, using 300GB of data and DB2 Parallel
Edition, was conducted on a 96-node RISC System/6000 Scalable
Power Parallel System 403.  DB2 PE delivered a power metric of

The TPC-D benchmark simulates a complex query application.  TPC-D
is a Decision Support benchmark containing a suite of
business-oriented queries and concurrent updates.  The queries
and the data populating the database have been chosen for their
broad industry-wide relevance.  This benchmark illustrates
Decision Support systems that examine large volumes of data,
execute queries with a high degree of complexity, and give
answers to critical business questions.                

For further information, contact Susan Scott-Ker at IBM media

Parna Sarkar at Brodeur & Partners (617-622-2833, Internet:

                             #  #  #

*    Indicates trademark or registered trademark of International
     Business Machines Corporation.

**   Indicates trademark or registered trademark of their
     respective holders.
Gene Kligerman
DB2 Development, IBM Software Solutions Toronto Lab