Paper

DB2 and Intel Xeon:
Paired for Performance
For more than 15 years, IBM and Intel
have collaborated to optimize enterprise
solutions: complete, cost-effective,
performance-optimized stacks of IBM
Information Management software
running on servers powered by Intel Xeon
processors. By coupling the latest version
of IBM DB2 with BLU Acceleration with
servers running the latest Intel Xeon
processor E7 family, you can transform
data into useful business insights more
quickly and deliver all those insights
into context, all while lowering costs
and power consumption.
IBM DB2 with BLU Acceleration running
on the Intel Xeon processor E7 v2 family
represents far more than an incremental
increase to performance. Coupling IBM’s
advanced database software with next-
generation Intel processors is ideal for
many demanding workloads ranging from
heavy OLTP to quick in-memory analytics.
This opens the door to unlocking the
competitive advantage hidden in the data
that your organization creates and curates.
Consider taking advantage of breakthrough
technology in both your database and
your hardware to realize the tremendous
performance improvements provided by
IBM DB2 with BLU Acceleration coupled
with the Intel Xeon processor E7 v2 family.
For more information about the
Intel Xeon processor E7 v2 product
families and IBM DB2 with BLU
Acceleration, visit www.intel.com/
content/www/us/en/processors/
xeon/xeon-processor-e7-family.
html and www.ibm.com/db2/intel.
1
McAfee, Andrew and Brynjolfsson, Erik. Harvard Business Review. “Big Data: The Management Revolution.” October 2012. http://hbr.org/2012/10/big-data-the-management-revolution.
2
Hilbert, Martin and López, Priscila. International Journal of Communication. “How to Measure the World’s Technological Capacity to Communicate, Store, and Compute Information.” 2012. http://ijoc.org/index.php/ijoc/article/viewFile/1562/742.
3
 BasedoninternalIntelqueryworkloadusingtheSAPHANA*softwareapplication.‘PreviousGeneration’baselineconguration:4-SocketIntel®E7505Chipset-basedserverwithfourIntelXeonprocessorsE7-4870(30MCache,2.40GHz,10
Cores)using32x8GBDDR3-1066memory(256GB).Score:110,061queriesperhour.‘NewGeneration’newconguration:IntelC606JChipsetusingfourIntelXeonprocessorsE7-4890v2(37.5MCache,2.80GHz,15Cores)using64x8GB
DDR3-1066(running2:1VMSE)memory(512GB).Score:218,406queriesperhour.ResultshavebeenestimatedbasedoninternalIntelanalysisandareprovidedforinformationalpurposesonly.Anydifferenceinsystemhardwareorsoftware
designorcongurationmayaffectactualperformance.Source:Intelinternalmeasurements(TechnicalReport#1347)asofNovember2013.
4
 SoftwareandworkloadsusedinperformancetestsmayhavebeenoptimizedforperformanceonlyonIntelmicroprocessors.Performancetests,suchasSYSmarkandMobileMark,aremeasuredusingspeciccomputersystems,components,
software, operations and functions. Any change to any of those factors may cause the results to vary. You should consult other information and performance tests to assist you in fully evaluating your contemplated purchases, including the
performance of that product when combined with other products.
5
 8GT/sand128b/130bencodinginPCIe*3.0specicationenablesdoubletheinterconnectbandwidthoverthePCIe2.0specication.Source:http://www.pcisig.com/news_room/November_18_2010_Press_Release/.
6
 Nocomputersystemcanprovideabsolutereliability,availability,orserviceability.RequiresanIntel®RunSureTechnology-enabledsystem,includinganenabledIntel®processorandenabledtechnology(ies).Built-inreliabilityfeaturesavailable
onselectIntelprocessorsmayrequireadditionalsoftware,hardware,services,and/oranInternetconnection.Resultsmayvarydependinguponconguration.Consultyoursystemmanufacturerformoredetails.
7
http://www-01.ibm.com/software/data/db2/linux-unix-windows/db2-blu-acceleration/
8
 Testresultsbasedonaninternal10TBdatabaseProofofPerformanceandScalability(POPS)benchmarkwithIBM®DB2®10.1runningona4-socketIntel®Xeon®processorE7-4870with1,024GBofmemory,andDB210.5with
BLUAccelerationrunningona4-socketIntelXeonprocessorE7-4890with1,024GBofmemory.BothsystemswereconguredwithIBM®XIV®Gen3storageattachedwith8GbpsFibreChannel(FC)via8GBSANswitchwith111TBtotal
rawspace(2TBx12disks/pModulex11XIVmodules).Performanceimprovementguresarecumulativeofallqueriesintheworkload.Individualresultswillvarydependingonindividualworkloads,congurations,andconditions.
9
 Intel®VirtualizationTechnologyrequiresacomputersystemwithanenabledIntel®processor,BIOS,virtualmachinemonitor(VMM)and,forsomeuses,certainplatformsoftwareenabledforit.Functionality,performanceorotherbenets
willvarydependingonhardwareandsoftwarecongurationsandmayrequireaBIOSupdate.Softwareapplicationsmaynotbecompatiblewithalloperatingsystems.Pleasecheckwithyourapplicationvendor.
 INFORMATIONINTHISDOCUMENTISPROVIDEDINCONNECTIONWITHINTELPRODUCTS.NOLICENSE,EXPRESSORIMPLIED,BYESTOPPELOROTHERWISE,TOANYINTELLECTUALPROPERTYRIGHTSISGRANTEDBY
THISDOCUMENT.EXCEPTASPROVIDEDININTEL’STERMSANDCONDITIONSOFSALEFORSUCHPRODUCTS,INTELASSUMESNOLIABILITYWHATSOEVERANDINTELDISCLAIMSANYEXPRESSORIMPLIEDWARRANTY,
RELATING TO SALE AND/OR USE OF INTEL PRODUCTS INCLUDING LIABILITY OR WARRANTIES RELATING TO FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR INFRINGEMENT OF ANY PATENT, COPYRIGHT
OR OTHER INTELLECTUAL PROPERTY RIGHT.
A “Mission Critical Application” is any application in which failure of the Intel Product could result, directly or indirectly, in personal injury or death. SHOULD YOU PURCHASE OR USE INTEL’S PRODUCTS FOR ANY SUCH MISSION CRITICAL
APPLICATION, YOU SHALL INDEMNIFY AND HOLD INTEL AND ITS SUBSIDIARIES, SUBCONTRACTORS AND AFFILIATES, AND THE DIRECTORS, OFFICERS, AND EMPLOYEES OF EACH, HARMLESS AGAINST ALL CLAIMS
COSTS,DAMAGES,ANDEXPENSESANDREASONABLEATTORNEYS’FEESARISINGOUTOF,DIRECTLYORINDIRECTLY,ANYCLAIMOFPRODUCTLIABILITY,PERSONALINJURY,ORDEATHARISINGINANYWAYOUTOF
SUCH MISSION CRITICAL APPLICATION, WHETHER OR NOT INTEL OR ITS SUBCONTRACTOR WAS NEGLIGENT IN THE DESIGN, MANUFACTURE, OR WARNING OF THE INTEL PRODUCT OR ANY OF ITS PARTS.
 Intelmaymakechangestospecicationsandproductdescriptionsatanytime,withoutnotice.Designersmustnotrelyontheabsenceorcharacteristicsofanyfeaturesorinstructionsmarked“reserved”or“undened”.Intelreservesthesefor
futuredenitionandshallhavenoresponsibilitywhatsoeverforconictsorincompatibilitiesarisingfromfuturechangestothem.Theinformationhereissubjecttochangewithoutnotice.Donotnalizeadesignwiththisinformation.
 Theproductsdescribedinthisdocumentmaycontaindesigndefectsorerrorsknownaserratawhichmaycausetheproducttodeviatefrompublishedspecications.Currentcharacterizederrataareavailableonrequest.
 ContactyourlocalIntelsalesofceoryourdistributortoobtainthelatestspecicationsandbeforeplacingyourproductorder.
 Copiesofdocumentswhichhaveanordernumberandarereferencedinthisdocument,orotherIntelliterature,maybeobtainedbycalling1-800-548-4725,orgoto:http://www.intel.com/design/literature.htm
Intel’s compilers may or may not optimize to the same degree for non-Intel microprocessors for optimizations that are not unique to Intel microprocessors.
These optimizations include SSE2, SSE3, and SSE3 instruction sets and other optimizations. Intel does not guarantee the availability, functionality,
or effectiveness of any optimization on microprocessors not manufactured by Intel.
 Microprocessor-dependentoptimizationsinthisproductareintendedforusewithIntelmicroprocessors.Certainoptimizationsnotspecicto
Intel microarchitecture are reserved for Intel microprocessors. Please refer to the applicable product User and Reference Guides for more
informationregardingthespecicinstructionsetscoveredbythisnotice.
 Noticerevision#20110804
Relative performance is calculated by assigning a baseline value of 1.0 to one benchmark result, and then dividing the actual benchmark
resultforthebaselineplatformintoeachofthespecicbenchmarkresultsofeachoftheotherplatforms,andassigningthemarelative
performance number that correlates with the performance improvements reported.
Intel does not control or audit the design or implementation of third-party benchmarks or web sites referenced in this document. Intel encourages
allofitscustomerstovisitthereferencedwebsitesorotherswheresimilarperformancebenchmarksarereportedandconrmwhetherthe
referencedbenchmarksareaccurateandreectperformanceofsystemsavailableforpurchase.
 Copyright©2014IntelCorporation.Allrightsreserved.Intel,theIntellogo,andXeonaretrademarksofIntelCorporationintheU.S.andothercountries.
* Other names and brands may be claimed as the property of others. Printed in USA 0114/TA/PRW/PDF Please Recycle 330137-001US
Unlock the Value of Your Data with Intel and IBM Innovations