Solution Performance

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.

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

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 specific 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. For more information go to www.intel.com/benchmarks.