Solution Performance

Discover the Benefits

  • Accelerates response time for analytics queries

  • Higher throughput to support more concurrent users

author-image

By

Running IBM DB2* on the 2nd Generation Intel® Xeon® Scalable processors powers the next generation of business innovation.

DB2* is IBM’s flagship database product which supports in-memory column store tables for analytics workloads. The proprietary IBM Big Data Insights Workload (BDInsights) is a multi-user data warehousing workload based on a retail environment. The workload as configured uses a 300GB scale factor and 12 concurrent users. It is compute-bound in the tested configuration.

Visit www.IBM.com ›

Performance Contributors

  • Greater number of cores/threads and improved memory bandwidth of Intel® Xeon® Scalable processors
  • Intel® Advanced Vector Extensions (Intel® AVX), available with Intel® Xeon® Scalable processors, also contributed to the performance gain of 65% compared to older generation processor (see chart).1 2 3

Value

Significantly higher throughput compared to older hardware – with the latest 2nd Gen Intel® Xeon® Platinum 8280 processor, IBM DB2 users can achieve analytics results more rapidly, while supporting more concurrent users.

The specified image does not include the correct rendition: intel.web.128.96

The specified image does not include the correct rendition: intel.web.128.96

Product and Performance Information

1

Testing conducted on IBM Db2* software comparing Intel® Xeon® Platinum 8280 processor to 2S Intel® Xeon® processor E5-2697 v2. Testing done by Intel February 2019. BASELINE: 2S Intel® Xeon® processor E5-2697 v2, 2.7GHz, 12 cores, turbo on, HT on, BIOS 02.06.0007, 192GB total memory, 12 slots / 16GB / 1600 MT/s / DDR3 DIMM, 1 x 400GB, Intel® SSD DC S3700, Red Hat Enterprise Linux* 7.5, kernel 3.10.0-862.el7.x86_64. NEW: 2S Intel® Xeon® Platinum 8280, 2.7GHz, 28 cores, turbo on, HT on, BIOS 0D010299, 192GB total memory, 12 slots / 16GB / 2666 MT/s / DDR4 LRDIMM, 1 x 375GB, Intel® Optane™ SSD DC P4800X, Red Hat Enterprise Linux* 7.5, kernel 3.10.0-862.el7.x86_64.

2

IBM Db2* v11.1.4.4. The IBM Big Data Insights Internal Heavy Multiuser Workload (BDInsights) is a multi-user data warehousing workload based on a retail environment. The workload is comprised with a mix of complex and intermediate queries. The scale factor for the workload is 300GB with 12 users. Testing by Intel completed on February 1, 2019. Security Mitigations for Variants 1, 2, and 3 in place.

BASELINE: 2S Intel® Xeon® processor E5-2697 v2, 2.7GHz, 12 cores, turbo on, HT on, BIOS 02.06.0007, 192GB total memory, 12 slots / 16GB / 1600 MT/s / DDR3 DIMM, 1 x 400GB, Intel® SSD DC S3700, Red Hat Enterprise Linux* 7.5, kernel 3.10.0-862.el7.x86_64.

NEW: 2S Intel® Xeon® Platinum 8280 processor, 2.7GHz, 28 cores, turbo on, HT on, BIOS 0D010299, 192GB total memory, 12 slots / 16GB / 2666 MT/s / DDR4 LRDIMM, 1 x 375GB, Intel® Optane™ SSD DC P4800X, Red Hat Enterprise Linux* 7.5, kernel 3.10.0-862.el7.x86_64.

3

Performance varies by use, configuration and other factors. Learn more at www.Intel.com/PerformanceIndex.