-------------------------------------------------------------------------------- SPECjEnterprise(R)2018 Web Profile Result Copyright (C) 2009-2018 Standard Performance Evaluation Corporation -------------------------------------------------------------------------------- WebSphere Liberty Core 18.0.0.3 on Cisco C240 M5 and DB2 11.1 on Cisco C240 M5 -------------------------------------------------------------------------------- 26,671.77 SPECjEnterprise2018 WebjOPS -------------------------------------------------------------------------------- Submitter: IBM Corporation SPEC license # 11 Test date: Sep-2018 -------------------------------------------------------------------------------- SUT CONFIGURATION -------------------------------------------------------------------------------- Java EE Server Nodes: 1 DB Server Nodes: 1 Java EE Server CPUs: 48 cores, 2 chips DB Server CPUs: 48 cores, 2 chips Java EE Instances: 6 DB Instances: 1 Other SUT Components: DNS round robin load balancing was used and hosted on the DB SUT system Load balancing network connectivity was 1Gbps all other connections were 10Gbps -------------------------------------------------------------------------------- BENCHMARK SETTINGS -------------------------------------------------------------------------------- Injection Rate: 26,500 Ramp Up Time: 600 sec DB Load Injection Rate: 30,000 Steady State Time: 3,600 sec Ramp Down Time: 300 sec # of Insurance Agents: 28 Insurance Users (threads): 265,000 Total Concurrent Users (threads): 265,000 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Insurance Transactions Mix Count Tx. Mix Failure Count JSF-AcceptQuote 832,751 0.87% 0 JSF-AcceptQuote+WebSocket 207,409 0.22% 0 JSF-AddVehicle 1,052,963 1.10% 0 JSF-DeleteVehicle 417,181 0.43% 0 JSF-Login 3,758,303 3.91% 0 JSF-Logout 3,547,746 3.69% 0 JSF-Register 339,149 0.35% 0 JSF-RegisterInvalid 84,757 0.09% 0 JSF-Unregister 210,412 0.22% 0 JSF-UpdateUser 421,846 0.44% 0 JSF-ViewInsurance 404,676 0.42% 0 JSF-ViewQuote 1,052,984 1.10% 0 JSF-ViewUser 632,796 0.66% 0 JSF-ViewVehicle 1,444,849 1.50% 0 REST-AcceptQuote 4,713,212 4.91% 0 REST-AcceptQuote+WebSocket 1,178,003 1.23% 0 REST-AddVehicle 5,965,741 6.21% 0 REST-DeleteVehicle 2,357,695 2.46% 0 REST-Login 21,286,671 22.17% 0 REST-Logout 20,091,275 20.92% 0 REST-Register 1,925,442 2.01% 0 REST-RegisterInvalid 481,481 0.50% 0 REST-Unregister 1,195,633 1.25% 0 REST-UpdateUser 2,389,412 2.49% 0 REST-ViewInsurance 2,292,552 2.39% 0 REST-ViewQuote 5,966,000 6.21% 0 REST-ViewUser 3,583,902 3.73% 0 REST-ViewVehicle 8,183,521 8.52% 0 Total # transactions 96,018,362 Response Times Average Standard Deviation Maximum 90th% Reqd JSF-AcceptQuote 0.131 0.35 4.837 0.350 2.000 JSF-AcceptQuote+WebSocket 0.173 0.49 7.003 0.430 2.000 JSF-AddVehicle 0.139 0.34 4.819 0.330 2.000 JSF-DeleteVehicle 0.076 0.24 3.641 0.200 2.000 JSF-Login 0.122 0.43 6.360 0.300 2.000 JSF-Logout 0.032 0.12 2.383 0.080 2.000 JSF-Register 0.294 1.20 12.544 0.650 2.000 JSF-RegisterInvalid 0.360 1.48 15.128 0.780 2.000 JSF-Unregister 0.071 0.25 3.629 0.180 2.000 JSF-UpdateUser 0.136 0.47 5.764 0.330 2.000 JSF-ViewInsurance 0.068 0.24 3.658 0.170 2.000 JSF-ViewQuote 0.133 0.44 5.765 0.320 2.000 JSF-ViewUser 0.072 0.23 3.652 0.180 2.000 JSF-ViewVehicle 0.070 0.23 3.681 0.180 2.000 REST-AcceptQuote 0.138 0.50 14.220 0.330 2.000 REST-AcceptQuote+WebSocket 0.180 0.60 13.422 0.420 2.000 REST-AddVehicle 0.091 0.35 12.725 0.180 2.000 REST-DeleteVehicle 0.084 0.35 13.999 0.180 2.000 REST-Login 0.040 0.20 10.579 0.080 2.000 REST-Logout 0.000 0.00 0.092 0.010 2.000 REST-Register 0.042 0.20 9.876 0.090 2.000 REST-RegisterInvalid 0.144 0.70 14.072 0.280 2.000 REST-Unregister 0.047 0.20 9.667 0.100 2.000 REST-UpdateUser 0.080 0.35 14.452 0.170 2.000 REST-ViewInsurance 0.041 0.20 9.265 0.080 2.000 REST-ViewQuote 0.079 0.35 12.311 0.160 2.000 REST-ViewUser 0.042 0.20 8.438 0.090 2.000 REST-ViewVehicle 0.040 0.19 9.331 0.080 2.000 Reproducibility Run (SPECjEnterprise2018 WebjOPS) 26,675.86 -------------------------------------------------------------------------------- SOFTWARE PRODUCTS -------------------------------------------------------------------------------- WebSphere Liberty Core 18.0.0.3 Vendor: IBM Corporation Availability Date: Sep-2018 Date Passed CTS: Jun-2018 CTS Version: 8.0 OS Name: SUSE Linux Enterprise Server 12 SP3 -------------------------------------------------------------------------------- IBM SDK, Java Technology Edition, Version 8, Service Refresh 5, Fixpack 21 Vendor: IBM Corporation Availability Date: Sep-2018 OS Name: SUSE Linux Enterprise Server 12 SP3 -------------------------------------------------------------------------------- IBM DB2 Universal JDBC Drivers (4.24.92) Vendor: IBM Corporation Availability Date: Aug-2018 OS Name: SUSE Linux Enterprise Server 12 SP3 -------------------------------------------------------------------------------- DB2 11.1 Mod 3 Fix Pack 3 iFix002 Vendor: IBM Corporation Availability Date: Aug-2018 OS Name: SUSE Linux Enterprise Server 12 SP3 -------------------------------------------------------------------------------- SOFTWARE CONFIGURATIONS -------------------------------------------------------------------------------- Insurance Java EE Configuration Java EE Product: WebSphere Liberty Core 18.0.0.3 JVM Product: IBM SDK, Java Technology Edition, Version 8, Service Refresh 5, Fixpack 21 Database Driver Product:IBM DB2 Universal JDBC Drivers (4.24.92) Hardware: Java EE Web Profile Application Server HW # of Instances: 4 Interfaces: Web (JSF and REST) Interface for the Insurance service Notes / Tuning Information Java Version: Java(TM) SE Runtime Environment (build 8.0.5.21 - pxa6480sr5fp21-20180830_01(SR5 FP21)) JVM Parameters (refer to file insurance/jvm.options): -Xlp:objectheap:pagesize=2m -Xlp:codecache:pagesize=2m -Xlp:gcmetadata:pagesize=2m -Xms8g -Xmx8g -Dhttp.keepAlive=true -Dhttp.maxConnections=2000 -Xgcthreads18 -Xconcurrentlevel0 -Xaggressive -Xss128k -Xtrace:none -Xshareclasses:none -Dcom.ibm.websphere.ejbcontainer.poolSize=insurance#insurance.war#InsuranceAgentsService=H60,1000:insurance#insurance.war#PolicyVehicleService=H60,1000: insurance#insurance.war#PolicyHolderRegistration=H60,1000:insurance#insurance.war#PolicyHolderService=H60,1000 -Xdisableexplicitgc -Xmn6g -Xgc:tlhMaximumSize=524288,tlhIncrementSize=16384 -Dcom.ibm.crypto.plus.provider.DISABLEHMAC=true -XlockReservation Refer to file insurance/server.xml for all server configuration and resource configuration information The IBMJCEPlus crypto provider is enabled in the /jre/lib/security/java.security file (see config/jre/lib/security), adding it in as the number 1 in the security.provider list: security.provider.1=com.ibm.crypto.plus.provider.IBMJCEPlus -------------------------------------------------------------------------------- Insurance Provider Java EE Configuration Java EE Product: WebSphere Liberty Core 18.0.0.3 JVM Product: IBM SDK, Java Technology Edition, Version 8, Service Refresh 5, Fixpack 21 Database Driver Product:IBM DB2 Universal JDBC Drivers (4.24.92) Hardware: Java EE Web Profile Application Server HW # of Instances: 1 Interfaces: REST Interface for the Insurance provider service Notes / Tuning Information Java Version: Java(TM) SE Runtime Environment (build 8.0.5.21 - pxa6480sr5fp21-20180830_01(SR5 FP21)) JVM Parameters (refer to file insurance-provider/jvm.options): -Xlp:objectheap:pagesize=2m -Xlp:codecache:pagesize=2m -Xlp:gcmetadata:pagesize=2m -Xms2250m -Xmx2250m -Dhttp.keepAlive=true -Dhttp.maxConnections=2000 -Xgcthreads12 -Xaggressive -Xss128k -Xtrace:none -Xshareclasses:none -Dcom.ibm.websphere.ejbcontainer.poolSize=insurance-provider#insurance-provider.war#VehicleService=H60,1000: insurance-provider#insurance-provider.war#ActuarialService=H60,1000:insurance-provider#insurance-provider.war#AgentManager=H60,1000 -Xdisableexplicitgc -Xmn1365m -Xgc:tlhMaximumSize=524288,tlhIncrementSize=16384 -Dcom.ibm.crypto.plus.provider.DISABLEHMAC=true -XlockReservation Refer to file insurance-provider/server.xml for all server configuration and resource configuration information The IBMJCEPlus crypto provider is enabled in the /jre/lib/security/java.security file (see config/jre/lib/security), adding it in as the number 1 in the security.provider list: security.provider.1=com.ibm.crypto.plus.provider.IBMJCEPlus -------------------------------------------------------------------------------- Vehicle Java EE Configuration Java EE Product: WebSphere Liberty Core 18.0.0.3 JVM Product: IBM SDK, Java Technology Edition, Version 8, Service Refresh 5, Fixpack 21 Database Driver Product:IBM DB2 Universal JDBC Drivers (4.24.92) Hardware: Java EE Web Profile Application Server HW # of Instances: 1 Interfaces: REST Interface for the Vehicle service Notes / Tuning Information Java Version: Java(TM) SE Runtime Environment (build 8.0.5.21 - pxa6480sr5fp21-20180830_01(SR5 FP21)) JVM Parameters (refer to file vehicle/jvm.options): -Xlp:objectheap:pagesize=2m -Xlp:codecache:pagesize=2m -Xlp:gcmetadata:pagesize=2m -Xms2250m -Xmx2250m -Xgcthreads12 -Xaggressive -Xss128k -Xtrace:none -Xshareclasses:none -Dcom.ibm.websphere.ejbcontainer.poolSize=vehicle#vehicle.war#VehicleService=H60,1000 -Xdisableexplicitgc -Xmn1365m -Xgc:tlhMaximumSize=524288,tlhIncrementSize=16384 -Dcom.ibm.crypto.plus.provider.DISABLEHMAC=true -XlockReservation Refer to file vehicle/server.xml for all server configuration and resource configuration information The IBMJCEPlus crypto provider is enabled in the /jre/lib/security/java.security file (see config/jre/lib/security), adding it in as the number 1 in the security.provider list: security.provider.1=com.ibm.crypto.plus.provider.IBMJCEPlus -------------------------------------------------------------------------------- Database SW Configuration DB Product: DB2 11.1 Mod 3 Fix Pack 3 iFix002 Hardware: Database Server HW # of Instances: 1 Character Set: UTF16 Notes / Tuning Information DB2 Registry Variables: DB2_COLLECT_TS_REC_INFO=FALSE DB2_KEEPTABLELOCK=CONNECTION DB2FCMCOMM=TCPIP4 DB2COMM=TCPIP DB2TCP_CLIENT_CONTIMEOUT=0 DB2TCP_CLIENT_RCVTIMEOUT=0 DB2_USE_ALTERNATE_PAGE_CLEANING=ON DB2_MINIMIZE_LISTPREFETCH=YES DB2TCPCONNMGRS=8 DB2ENVLIST=LD_PRELOAD LD_LIBRARY_PATH DB2SOSNDBUF=131072 DB2SORCVBUF=131072 DB2AUTOSTART=NO Database Manager Configuration: DIAGLEVEL=3 DFT_MON_BUFPOOL=on DFT_MON_LOCK=off DFT_MON_SORT=off DFT_MON_STMT=off DFT_MON_TIMESTAMP=on DFT_MON_UOW=off DFT_MON_TABLE=off CPUSPEED=-1 MAX_COORDAGENTS=AUTOMATIC(10000) HEALTH_MON=off SHEAPTHRES=2000000 Database Configuration: LOGBUFSZ=4096 LOGSECOND=0 LOGPRIMARY=256 SOFTMAX=8080 CHNGPGS_THRESH=99 LOGFILSIZ=65535 AUTO_MAINT=off AUTO_RUNSTATS=off AUTO_TBL_MAINT=off SHEAPTHRES_SHR=183205 SORTHEAP=50000 NUM_IOCLEANERS=32 MAXAPPLS=6000 MAXLOCKS=100 LOCKLIST=200000 MINCOMMIT=1 MON_REQ_METRICS=base MON_ACT_METRICS=base MON_OBJ_METRICS=none AUTO_STMT_STATS=off Buffer Pool Size Configuration: IBMDEFAULTBP=12000000 Full details of the database configuration information are located in the schema directory of the FDA. -------------------------------------------------------------------------------- Driver Configuration JVM Product: IBM SDK, Java Technology Edition, Version 8, Service Refresh 5, Fixpack 21 Hardware: Load Driver HW # of Instances: 8 Notes / Tuning Information Java Version: Java(TM) SE Runtime Environment (build 8.0.5.21 - pxa6480sr5fp21-20180830_01(SR5 FP21)) JVM Parameters: -Xms4G -Xmx4G -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0 -Djava.net.preferIPv4Stack=true -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- Java EE Web Profile Application Server HW (SUT hardware) Hardware Vendor: Cisco Systems, Inc. Model Name: Cisco UCS C240 M5 Processor: Intel Xeon Platinum 8168 CPU (Intel Turbo Boost Technology up to 3.7 GHz) MHz: 2700 # of CPUs: 48 cores, 2 chips, 24 cores/chip (48 HW threads/chip) Memory (MB): 257387 L1 Cache: 32 KB I + 32 KB D on chip per core L2 Cache: 1024 KB I+D on chip per core Other Cache: 33792 KB I+D on chip per chip OS Vendor: SUSE OS Name: SUSE Linux Enterprise Server 12 SP3 Disks: 480 GB SSD Network Interface: 5x 10GBit and 2x 1GBit network ports Other Hardware: # of Systems: 1 H/W Available: Jul-2017 O/S Available: Sep-2017 Notes / Tuning Information /etc/sysctl.conf: fs.file-max = 1048576 fs.inotify.max_user_watches = 65536 kernel.sched_compat_yield = 1 kernel.sem = 250 32000 100 128 kernel.shmall = 4294967296 kernel.shmmax = 68719476736 net.core.netdev_max_backlog = 250000 net.core.optmem_max = 30000000 net.core.rmem_default = 30000000 net.core.rmem_max = 32554432 net.core.somaxconn = 32767 net.core.wmem_default = 30000000 net.core.wmem_max = 32554432 net.ipv4.conf.all.arp_announce = 2 net.ipv4.conf.all.arp_ignore = 1 net.ipv4.conf.all.promote_secondaries = 1 net.ipv4.conf.all.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 net.ipv4.conf.default.promote_secondaries = 1 net.ipv4.conf.default.rp_filter = 1 net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.ip_forward = 0 net.ipv4.ip_local_port_range = 1024 65000 net.ipv4.tcp_fin_timeout = 30 net.ipv4.tcp_keepalive_intvl = 15 net.ipv4.tcp_keepalive_probes = 5 net.ipv4.tcp_max_syn_backlog = 30000 net.ipv4.tcp_max_tw_buckets = 2000000 net.ipv4.tcp_mem = 30000000 30000000 30000000 net.ipv4.tcp_no_metrics_save = 1 net.ipv4.tcp_rmem = 20480 174760 32554432 net.ipv4.tcp_sack = 1 net.ipv4.tcp_timestamps = 1 net.ipv4.tcp_window_scaling = 1 net.ipv4.tcp_wmem = 20480 174760 32554432 vm.max_map_count = 262144 ulimit -n 1048576 -v unlimited -u 4134075 default_hugepagesz=2M hugepagesz=2M hugepages=25600 Network Tuning (see config/appserver/ethbalance.sh): set txqueuelen 60000 Stop irqbalance Network interrupts balanced via Intel set_irq_affinity.sh On each interface used for driver and database communication set: arp_ignore 1 arp_announce 2 rx-usecs 100 mtu 1500 Server instances were started using taskset, binding 3 instances per NUMA node (see config/appserver/startServersWeb4.sh). Yes: The test sponsor attests, as of date of publication, that CVE-2017-5754 (Meltdown) is mitigated in the system as tested and documented. Yes: The test sponsor attests, as of date of publication, that CVE-2017-5753 (Spectre variant 1) is mitigated in the system as tested and documented. Yes: The test sponsor attests, as of date of publication, that CVE-2017-5715 (Spectre variant 2) is mitigated in the system as tested and documented. -------------------------------------------------------------------------------- Database Server HW (SUT hardware) Hardware Vendor: Cisco Systems, Inc. Model Name: Cisco UCS C240 M5 Processor: Intel Xeon Platinum 8168 CPU (Intel Turbo Boost Technology up to 3.7 GHz) MHz: 2700 # of CPUs: 48 cores, 2 chips, 24 cores/chip (48 HW threads/chip) Memory (MB): 1031501 L1 Cache: 32 KB I + 32 KB D on chip per core L2 Cache: 1024 KB I+D on chip per core Other Cache: 33792 KB I+D on chip per chip OS Vendor: SUSE OS Name: SUSE Linux Enterprise Server 12 SP3 Disks: 2x 960 GB SSD Network Interface: 1x 10GBit and 2x 1GBit network ports Other Hardware: # of Systems: 1 H/W Available: Jul-2017 O/S Available: Sep-2017 Notes / Tuning Information /etc/sysctl.conf: net.ipv4.ip_forward = 0 net.ipv6.conf.all.forwarding = 0 net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.conf.all.rp_filter = 1 fs.inotify.max_user_watches = 65536 net.ipv4.conf.default.promote_secondaries = 1 net.ipv4.conf.all.promote_secondaries = 1 net.ipv4.conf.all.arp_filter = 1 kernel.sem = 250 256000 100 129280 fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 10737418240 net.core.netdev_max_backlog = 400000 net.core.optmem_max = 30000000 net.core.rmem_default = 30000000 net.core.rmem_max = 30000000 net.core.somaxconn = 40000 net.core.wmem_default = 30000000 net.core.wmem_max = 30000000 net.ipv4.ip_local_port_range = 1024 65535 net.ipv4.tcp_fin_timeout = 10 net.ipv4.tcp_max_syn_backlog = 30000 net.ipv4.tcp_max_tw_buckets = 2000000 net.ipv4.tcp_mem = 30000000 30000000 30000000 net.ipv4.tcp_rmem = 30000000 30000000 30000000 net.ipv4.tcp_timestamps = 0 net.ipv4.tcp_wmem = 30000000 30000000 30000000 vm.zone_reclaim_mode = 1 vm.swappiness = 5 ulimit -n 1048576 -v unlimited -u 4134075 transparent_hugepage=never Yes: The test sponsor attests, as of date of publication, that CVE-2017-5754 (Meltdown) is mitigated in the system as tested and documented. Yes: The test sponsor attests, as of date of publication, that CVE-2017-5753 (Spectre variant 1) is mitigated in the system as tested and documented. Yes: The test sponsor attests, as of date of publication, that CVE-2017-5715 (Spectre variant 2) is mitigated in the system as tested and documented. -------------------------------------------------------------------------------- Load Driver HW (non-SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM BladeCenter HS22 Processor: Intel Xeon CPU X5690 MHz: 3470 # of CPUs: 12 cores, 2 chips, 6 cores/chip (12 HW threads/chip) Memory (MB): 48208 L1 Cache: 32 KB I + 32 KB D on chip per core L2 Cache: 256 KB I+D on chip per core Other Cache: 12288 KB I+D on chip per chip OS Vendor: SUSE OS Name: SUSE Linux Enterprise Server 12 SP1 Disks: 41GB Network Interface: 1x 10 GBit and 1x 1GBit network ports Other Hardware: # of Systems: 8 H/W Available: Mar-2011 O/S Available: Dec-2015 Notes / Tuning Information /etc/sysctl.conf: net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.conf.all.rp_filter = 1 fs.inotify.max_user_watches = 65536 net.ipv4.conf.default.promote_secondaries = 1 net.ipv4.conf.all.promote_secondaries = 1 fs.file-max = 1048576 kernel.sem = 250 32000 100 128 kernel.shmall = 4294967296 kernel.shmmax = 68719476736 net.core.optmem_max = 30000000 net.core.rmem_default = 30000000 net.core.wmem_default = 30000000 net.ipv4.conf.all.arp_announce = 2 net.ipv4.conf.all.arp_ignore = 1 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 net.ipv4.ip_forward = 0 net.ipv4.ip_local_port_range = 1024 65000 net.ipv4.tcp_max_syn_backlog = 30000 net.ipv4.tcp_max_tw_buckets = 2000000 net.ipv4.tcp_mem = 30000000 30000000 30000000 vm.nr_hugepages = 8192 kernel.sched_compat_yield = 1 net.core.somaxconn = 32767 net.core.netdev_max_backlog = 250000 net.ipv4.tcp_fin_timeout = 30 net.ipv4.tcp_keepalive_intvl = 15 net.ipv4.tcp_keepalive_probes = 5 net.core.rmem_max = 32554432 net.core.wmem_max = 32554432 net.ipv4.tcp_rmem = 20480 174760 32554432 net.ipv4.tcp_wmem = 20480 174760 32554432 net.ipv4.tcp_window_scaling = 1 net.ipv4.tcp_timestamps = 1 net.ipv4.tcp_sack = 1 net.ipv4.tcp_no_metrics_save = 1 kernel.pid_max = 229376 ulimit -n 1048576 -v unlimited -u 4134075 -------------------------------------------------------------------------------- BENCHMARK MODIFICATIONS -------------------------------------------------------------------------------- Schema Modifications: SQL files to load the database are included in the FDA. -------------------------------------------------------------------------------- Load Program Modifications: No modifications to the load programs were made. BENCHMARK CONFIGURATION INFORMATION -------------------------------------------------------------------------------- Isolation Requirement Info: The READ_COMMITTED isolation level was used for all JPA entities. -------------------------------------------------------------------------------- Durability Requirement Info: To ensure database durability, the database and the database logs were each maintained on two mirrored internal 960 GB SSD drives configured in RAID 1. The RAID controller is configured with a write-through policy. -------------------------------------------------------------------------------- Storage Requirement Info: Over the course of a 75 minute run at an injection rate of 26500, the database storage increased by 5 GB Given a linear scale, a 24 hour run at the same injection rate would increase storage by 96 GB. The database was configured with two mirrored 960 GB drives for logs and storage. BILL OF MATERIALS -------------------------------------------------------------------------------- ----------------------------Application Server SUT---------------------------- Supplier Description Product # Qty -------- ------------------------------------------- ---------------- --- Cisco UCS C240 M5 8 SFF UCSC-C240-M5S 1 + 2 rear drives w/o CPU,mem,HD,PCIe,PS Cisco 32GB DDR4-2666-MHz RDIMM/PC4-21300/ UCS-MR-X32G2RS-H 8 dual rank/x4/1.2v Cisco Riser 1 incl 3 PCIe slots (x8, x16, x8); UCSC-PCI-1-C240M5 1 slot 3 req CPU2 Cisco Riser 2A incl 3 PCIe slots (x8, x16, x16) UCSC-PCI-2A-240M5 1 supports GPU Cisco Media Drive (DVD) for C240 M5 Servers UCSC-DVD-C240M5 1 (8 HDD version only) Cisco UCS 1050W AC Power Supply for Rack Server UCSC-PSU1-1050W 2 Cisco Power Cord Jumper, C13-C14 Connectors CAB-C13-C14-2M 2 Cisco Ball Bearing Rail Kit for C220 & C240 UCSC-RAILB-M4 1 M4 & M5 rack servers Cisco IMC SW (Recommended) latest release CIMC-LATEST 1 for C-Series Servers Cisco UCS C-Series M5 SFF drive blanking panel UCSC-BBLKD-S2 8 Cisco Cisco ONE Data Center Compute Opt Out Option C1UCS-OPT-OUT 1 Cisco 2.7 GHz 8168/205W 24C/33MB Cache/DDR4 2666MHz UCS-CPU-8168 2 Cisco Intel X710-DA2 dual-port 10G SFP+ NIC UCSC-PCIE-ID10GF 2 Cisco Intel X710 quad-port 10G SFP+ NIC UCSC-PCIE-IQ10GF 2 Cisco Heat sink for UCS C240 M5 rack servers UCSC-HS2-C240M5 2 CPUs above 150W... Cisco Super Cap cable for UCSC-RAID-M5 CBL-SC-MR12GM52 1 on C240 M5 Servers Cisco 12G Modular RAID controller with 2GB cache UCSC-RAID-M5 1 Cisco 480 GB 2.5 inch Enterprise Value 6G SATA SSD UCS-SD480G61X-EV 2 Cisco Super Cap for UCSC-RAID-M5, UCSC-MRAID1GB-KIT UCSC-SCAP-M5 1 Cisco 10GBASE-SR SFP Module SFP-10G-SR= 12 Cisco SUSE Linux Enterprise Server w/ 3yr support SLES-2S-HA-3 1 Cisco SNTC 24X7X4 UCS C240 M5 8 SFF CON-SNTP-CC240M5S 1 + 2 rear drives w/o CPU,mem,HD ------------------------------------DB SUT------------------------------------ Supplier Description Product # Qty -------- ------------------------------------------- ---------------- --- Cisco UCS C240 M5 8 SFF UCSC-C240-M5S 1 + 2 rear drives w/o CPU,mem,HD,PCIe,PS Cisco 2.7 GHz 8168/205W 24C/33MB Cache/DDR4 2666MHz UCS-CPU-8168 2 Cisco 64GB DDR4-2666-MHz LRDIMM/PC4-21300/ UCS-ML-X64G4RS-H 16 quad rank/x4/1.2v Cisco Riser 1 incl 3 PCIe slots (x8, x16, x8); UCSC-PCI-1-C240M5 1 slot 3 req CPU2 Cisco Riser 2A incl 3 PCIe slots (x8, x16, x16) UCSC-PCI-2A-240M5 1 supports GPU Cisco Intel X520 Dual Port 10Gb SFP+ Adapter N2XX-AIPCI01 2 Cisco UCS 1600W AC Power Supply for Rack Server UCSC-PSU1-1600W 2 Cisco Power Cord Jumper, C13-C14 Connectors CAB-C13-C14-2M 2 Cisco Ball Bearing Rail Kit for C220 & C240 UCSC-RAILB-M4 1 M4 & M5 rack servers Cisco IMC SW (Recommended) latest release CIMC-LATEST 1 for C-Series Servers Cisco Heat sink for UCS C240 M5 rack servers UCSC-HS2-C240M5 2 CPUs above 150W... Cisco UCS C-Series M5 SFF drive blanking panel UCSC-BBLKD-S2 8 Cisco Super Cap cable for UCSC-RAID-M5 CBL-SC-MR12GM52 1 on C240 M5 Servers Cisco Super Cap for UCSC-RAID-M5, UCSC-MRAID1GB-KIT UCSC-SCAP-M5 1 Cisco 12G Modular RAID controller with 2GB cache UCSC-RAID-M5 1 Cisco 960 GB 2.5 inch Enterprise Value 6G SATA SSD UCS-SD960GM1X-EV 2 Cisco Cisco ONE Data Center Compute Opt Out Option C1UCS-OPT-OUT 1 Cisco Media Drive (DVD) for C240 M5 Servers UCSC-DVD-C240M5 1 (8 HDD version only) Cisco 10GBASE-SR SFP Module SFP-10G-SR= 4 Cisco SUSE Linux Enterprise Server w/ 3yr support SLES-2S-HA-3 1 Cisco SNTC 24X7X4 UCS C240 M5 8 SFF CON-SNTP-CC240M5S 1 + 2 rear drives w/o CPU,mem,HD ... Software: IBM WebSphere Application Server Liberty Core D0ZDZLL 48** 18.0.0.3 Lic+SW Maint 12 Months IBM WebSphere Application Server Liberty Core E0HGKLL 96 18.0.0.3 SW Maint Rnwl 1 Anniv IBM DB2 Advanced Enterprise Server Edition D0GB4LL 48** 11.1.3.3 Lic+SW Maint 12 Months IBM DB2 Advanced Enterprise Server Edition E0AJ4LL 96 11.1.3.3 SW Maint Rnwl 1 Anniv * Note: IBM SDK product support is dictated by the principal program, in this case WebSphere Application Server Liberty Core. ** Note: Pricing is based on Processor Value Units (PVU). Each AppServer and Database core is 70 PVU. -------------------------------------------------------------------------------- OTHER BENCHMARK INFORMATION -------------------------------------------------------------------------------- DNS round robin load balancing was used and hosted on the database machine Load balancing network connectivity was 1Gbps all other connections were 10Gbps -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- The IBM DB2 Universal JDBC Drivers is a type 4 driver. DB2 uses "Soft" checkpoint to ensure that no updates remain unflushed for longer than the allowed time. When DB2 UDB Server changes a database table with an update, insert, or delete operation, the change is initially made in memory, not on disk. When there is not enough space in the memory buffer to read in or write additional data pages, DB2 UDB Server will make space by flushing some modified pages to disk. Modified pages are also written to disk as part of the "Soft" checkpoint to ensure that no updates remain unflushed for longer than the allowed time. Before a change is made to the database, it is first recorded in the transaction log. This ensures that the database can be recovered completely in the event of a failure. Using the transaction log, transactions that started but did not complete prior to a failure can be undone, and transactions recorded as complete in the transaction log but not yet written to disk can be redone. DB2 UDB uses a write-ahead-logging protocol to guarantee recovery. This protocol uses "Soft" checkpoint to write least-recently-used database pages to disk independent of transaction commit. However, enough log information to redo/undo the change to a database pages is committed to disk before the database page itself is written. This protocol therefore renders checkpoint unnecessary for DB2 UDB. For a more detailed description of the general principles of the write-ahead-logging protocol, see the IBM research paper, ARIES: A Transaction Recovery Method Supporting Fine Granularity Locking and Partial Rollbacks Using Write-Ahead Logging," by C. Mohan, Database Technology Institute, IBM Almaden Research Center. (http:// portal.acm.org/citation.cfm ?id=128770&coll=portal&dl=ACM&CFID=10343790&CFTOKEN=42047146) -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: IBM Corporation For other inquiries, please contact SPEC - Benchmark run on Wed Sep 12 22:22:54 CDT 2018 by SPECjEnterprise2018 Web Profile v1.0.0 - Result submitted on September 12, 2018 - Report generated by SPECjEnterprise2018 Web Profile Reporter v1.0 Copyright (C) 2009-2018 Standard Performance Evaluation Corporation