What is DB2 Answer to Oracle 10g

Srini S Rajan

What is DB2 Answer to Oracle 10g
few months back DB2 produced a top TPC bench mark on P-Series AIX 5L with
32 processors. But since then Oracle 10G on HP Itanium 64 processors
produced two > 1 Mil. bench marks, which sounds like Oracle 10g will have
superior performance than db2.

But reading in between, IBM uses only 32 processors so from a non-hardware
guy perspective,I feel IBM could easily produce a better result if they use
64 processors
at least from a performance angle if not from a cost angle, but I am not
finding any such TPC listings from IBM of late. Any one knows of plans
from
IBM about beating HP/Oracle Results.


I eagerly look forward to one. Also a top tpc benchmark from IBM on db2 on
linux.


Sundar Rajan

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Nelson

Re: What is DB2 Answer to Oracle 10g
(in response to Srini S Rajan)
This E-Mail is sent in confidence for the addressee only. Unauthorised
recipients must preserve this confidentiality and should notify the
sender immediately by telephone on 0131-655-6789 and must delete the
original E-Mail without taking a copy. If you are not the addressee you
must not copy, distribute, disclose or use any of the information in any way.

This E-Mail is not intended nor should it be taken to create any legal
relations, contractual or otherwise.

We have taken all reasonable precautions to ensure that no viruses are transmitted
from the Scottish Widows Group of companies to any third party.

Scottish Widows accepts no responsibility for any loss or damage resulting directly
or indirectly from the use of this E-Mail or the contents.
*****************************************************************************

There already is a top DB2 benchmark with DB2 on Linux.

TPC-H (100 gig and 300 gig) on 32-way AMD64 cluster running SuSE Linux
Enterprise Server 8.

http://www-306.ibm.com/software/data/db2/linux/amd.pdf

While TPC and other benchmarks may be interesting (and managers like to see
them) they bear little or no resemblance to the real world, so I'm not
really convinced of their value.

Phil

-----Original Message-----
From: Srini S Rajan [mailto:[login to unmask email]
Sent: 10 December 2003 11:37
To: [login to unmask email]
Subject: What is DB2 Answer to Oracle 10g


few months back DB2 produced a top TPC bench mark on P-Series AIX 5L with
32 processors. But since then Oracle 10G on HP Itanium 64 processors
produced two > 1 Mil. bench marks, which sounds like Oracle 10g will have
superior performance than db2.

But reading in between, IBM uses only 32 processors so from a non-hardware
guy perspective,I feel IBM could easily produce a better result if they use
64 processors
at least from a performance angle if not from a cost angle, but I am not
finding any such TPC listings from IBM of late. Any one knows of plans
from
IBM about beating HP/Oracle Results.


I eagerly look forward to one. Also a top tpc benchmark from IBM on db2 on
linux.


Sundar Rajan

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm


*****************************************************************************
Visit the Scottish Widows website at www.scottishwidows.co.uk

Scottish Widows Group includes the following companies:-

Scottish Widows plc, Company No. 199549.
Authorised & Regulated by the Financial Services Authority.
Scottish Widows Annuities Limited, Company No. 199550.
Authorised & Regulated by the Financial Services Authority.
Scottish Widows Services Limited, Company No. 189975.

The Registered Office of all of the above companies is in the United Kingdom at 69 Morrison Street, Edinburgh, EH3 8YF.
Telephone: 0131 655 6000

Scottish Widows Unit Trust Managers Limited, Company No. 1629925
Registered Office: is in the United Kingdom at Charlton Place, Andover, Hampshire SP10 1RE.
Telephone: 0845 300 2244
Authorised & Regulated by the Financial Service Authority.

Scottish Widows Investment Partnership Limited, Company No. 794936
Registered Office : is in the United Kingdom at 10 Fleet Place, London EC4M 7RH.
Telephone: 0131 655 8500
Authorised & Regulated by the Financial Services Authority.

Scottish Widows Fund Management Limited, Company No. 74517.
Authorised & Regulated by the Financial Services Authority.
Pensions Management (SWF) Limited, Company No. 45361.
Authorised & Regulated by the Financial Services Authority.

The Registered Office of the above two companies is in the United Kingdom
at 15 Dalkeith Road, Edinburgh, EH16 5BU. Tel 0131 655 6000

The companies listed above are members of the Scottish Widows and Lloyds TSB Marketing Group-

Scottish Widows Bank plc, Company No. 154554
Registered Office: is in the United Kingdom at 67 Morrison Street, Edinburgh, EH3 8YJ.
Telephone: 0845 845 0829
Authorised & Regulated by the Financial Services Authority

Hill Samuel Unit Trust Managers Limited, Company No 406604
Registered Office: is in the United Kingdom at 10 Fleet Place,
London, EC4M 7RH
Telephone: 0800 336600
Authorised & Regulated by the Financial Services Authority

Hill Samuel Asset Management International Limited, Company No 106723
Registered Office: is in the United Kingdom at 15 Dalkeith Road,
Edinburgh, EH16 5BU
Telephone: 0131 655 8500
Authorised & Regulated by the Financial Services Authority

All of the above companies are part of the Lloyds TSB Group.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Gunning

Re: What is DB2 Answer to Oracle 10g
(in response to Philip Nelson)
Srini, From the results at TPC.org it is clear IBM dominates the TPC-H
category on a habitual basis and was the top vendor in TPC-C 2x this year.
I can't speak for IBM but I would point this out to mgt. TPC benchmarks are
what they are, but you also need to look at the overall Database
capabilities, operating and support costs, skills available, etc when
making a database choice. I wouldn't doubt that will see new IBM TPC-C
results in the next 6 months or so. They are quite costly to setup and run
and maybe IBM puts this money into product development more than spending
it on tests that may not equate to real life environments. But it is nice
to see a top DB2 TPC-C benchmark now and then -- I agree mgt looks for them
and when you can't produce one...you have to go into defense mode...HTH
Phil

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm