SPEC Seal of Reviewal SPECjEnterprise®2018 Web Profile Result
Copyright © 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
28,859.62 SPECjEnterprise2018 WebjOPS
Submitter:
IBM Corporation		 SPEC license # 11 Test date:
Sep-2018
Software Products
WebSphere Liberty Core 18.0.0.3
IBM SDK, Java Technology Edition, Version 8, Service Refresh 5, Fixpack 21
IBM DB2 Universal JDBC Drivers (4.24.92)
DB2 11.1 Mod 3 Fix Pack 3 iFix002 		Software Configurations
Insurance Java EE Configuration
Insurance Provider Java EE Configuration
Vehicle Java EE Configuration
Database SW Configuration
Driver Configuration 		Hardware Systems
Java EE Web Profile Application Server HW
Database Server HW
Load Driver HW

System Configuration Diagram

Benchmark
Modifications
Configuration
Bill of Materials
Other Info
General Notes
Full Disclosure Archive

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: 28,700   Ramp Up Time: 600 seconds
DB Load Injection Rate: 30,000   Steady State Time: 3,600 seconds
  Ramp Down Time: 300 seconds
# of Insurance Agents: 28  
InsuranceUsers (threads): 287,000  
Total Concurrent Users (threads): 287,000  

Detailed Results
Insurance Transactions Mix Count Tx. Mix Failure Count
JSF-AcceptQuote 901,412 0.87% 0
JSF-AcceptQuote+WebSocket 225,507 0.22% 0
JSF-AddVehicle 1,140,074 1.10% 0
JSF-DeleteVehicle 449,765 0.43% 0
JSF-Login 4,065,356 3.91% 0
JSF-Logout 3,838,797 3.69% 0
JSF-Register 367,132 0.35% 0
JSF-RegisterInvalid 92,032 0.09% 0
JSF-Unregister 226,708 0.22% 0
JSF-UpdateUser 455,927 0.44% 0
JSF-ViewInsurance 438,249 0.42% 0
JSF-ViewQuote 1,140,225 1.10% 0
JSF-ViewUser 683,557 0.66% 0
JSF-ViewVehicle 1,565,153 1.51% 0
REST-AcceptQuote 5,097,151 4.91% 0
REST-AcceptQuote+WebSocket 1,275,965 1.23% 0
REST-AddVehicle 6,453,827 6.21% 0
REST-DeleteVehicle 2,552,811 2.46% 0
REST-Login 23,032,792 22.17% 0
REST-Logout 21,741,841 20.93% 0
REST-Register 2,081,425 2.00% 0
REST-RegisterInvalid 519,803 0.50% 0
REST-Unregister 1,290,633 1.24% 0
REST-UpdateUser 2,583,218 2.49% 0
REST-ViewInsurance 2,485,955 2.39% 0
REST-ViewQuote 6,454,233 6.21% 0
REST-ViewUser 3,875,584 3.73% 0
REST-ViewVehicle 8,859,512 8.53% 0
Total # transactions 103,894,644    
Response Times Average Standard Deviation Maximum 90th% Reqd
JSF-AcceptQuote 0.222 0.64 4.892 0.310 2.000
JSF-AcceptQuote+WebSocket 0.333 0.92 6.040 0.480 2.000
JSF-AddVehicle 0.383 0.66 7.574 0.500 2.000
JSF-DeleteVehicle 0.139 0.45 3.824 0.190 2.000
JSF-Login 0.252 0.83 7.657 0.310 2.000
JSF-Logout 0.063 0.21 2.705 0.080 2.000
JSF-Register 0.654 2.40 14.168 0.740 2.000
JSF-RegisterInvalid 0.834 3.07 17.101 0.950 2.000
JSF-Unregister 0.132 0.46 3.822 0.170 2.000
JSF-UpdateUser 0.260 0.88 5.925 0.310 2.000
JSF-ViewInsurance 0.129 0.44 3.824 0.160 2.000
JSF-ViewQuote 0.264 0.83 5.919 0.320 2.000
JSF-ViewUser 0.134 0.43 3.810 0.170 2.000
JSF-ViewVehicle 0.133 0.42 3.857 0.170 2.000
REST-AcceptQuote 0.279 0.96 24.216 0.320 2.000
REST-AcceptQuote+WebSocket 0.390 1.17 20.538 0.480 2.000
REST-AddVehicle 0.195 0.66 19.036 0.210 2.000
REST-DeleteVehicle 0.173 0.65 17.163 0.180 2.000
REST-Login 0.084 0.36 15.481 0.090 2.000
REST-Logout 0.000 0.00 0.093 0.010 2.000
REST-Register 0.087 0.36 14.338 0.090 2.000
REST-RegisterInvalid 0.333 1.38 23.443 0.300 2.000
REST-Unregister 0.090 0.36 12.443 0.100 2.000
REST-UpdateUser 0.173 0.66 25.057 0.180 2.000
REST-ViewInsurance 0.085 0.35 14.896 0.090 2.000
REST-ViewQuote 0.180 0.65 17.940 0.200 2.000
REST-ViewUser 0.090 0.36 12.989 0.100 2.000
REST-ViewVehicle 0.084 0.35 15.449 0.090 2.000
Reproducibility Run (SPECjEnterprise2018 WebjOPS) 28,873.98

WebSphere Liberty Core 18.0.0.3
Vendor: IBM Corporation Availability: Sep-2018
CTS Version: 8.0 Date Passed CTS: Jun-2018
OS Name: SUSE Linux Enterprise Server 12 SP3
Product Version: 18.0.0.3

IBM SDK, Java Technology Edition, Version 8, Service Refresh 5, Fixpack 21
Vendor: IBM Corporation Availability: Sep-2018
OS Name: SUSE Linux Enterprise Server 12 SP3
Bitness: x86_64
Product Version: 8.0.5.21

IBM DB2 Universal JDBC Drivers (4.24.92)
Vendor: IBM Corporation Availability: Aug-2018
OS Name: SUSE Linux Enterprise Server 12 SP3
Product Version: 4.24.92

DB2 11.1 Mod 3 Fix Pack 3 iFix002
Vendor: IBM Corporation Availability: Aug-2018
OS Name: SUSE Linux Enterprise Server 12 SP3
Product Version: 11.1.3.3

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 -Xgcthreads20 -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 -Xgcthreads8 -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
  -Xgcthreads8 -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

Java EE Web Profile Application Server HW (SUT hardware)
Hardware Vendor: Cisco Systems, Inc. OS Vendor: SUSE
Model Name: Cisco UCS C240 M5 OS Name: SUSE Linux Enterprise Server 12 SP3
Processor: Intel Xeon Platinum 8168 CPU (Intel Turbo Boost Technology up to 3.7 GHz) Filesystem: BTRFS
MHz: 2700 Disks: 480 GB SSD
# of CPUs: 48 cores, 2 chips, 24 cores/chip (48 HW threads/chip) Network Interface: 5x 10GBit and 2x 1GBit network ports
Memory (MB): 257387 Other Hardware:
L1 Cache: 32 KB I + 32 KB D on chip per core # of Systems: 1
L2 Cache: 1024 KB I+D on chip per core H/W Available: Jul-2017
Other Cache: 33792 KB I+D on chip per chip OS 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. OS Vendor: SUSE
Model Name: Cisco UCS C240 M5 OS Name: SUSE Linux Enterprise Server 12 SP3
Processor: Intel Xeon Platinum 8168 CPU (Intel Turbo Boost Technology up to 3.7 GHz) Filesystem: EXT4
MHz: 2700 Disks: 2x 960 GB SSD
# of CPUs: 48 cores, 2 chips, 24 cores/chip (48 HW threads/chip) Network Interface: 1x 10GBit and 2x 1GBit network ports
Memory (MB): 1031501 Other Hardware:
L1 Cache: 32 KB I + 32 KB D on chip per core # of Systems: 1
L2 Cache: 1024 KB I+D on chip per core H/W Available: Jul-2017
Other Cache: 33792 KB I+D on chip per chip OS 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 OS Vendor: SUSE
Model Name: IBM BladeCenter HS22 OS Name: SUSE Linux Enterprise Server 12 SP1
Processor: Intel Xeon CPU X5690 Filesystem: BTRFS
MHz: 3470 Disks: 41GB
# of CPUs: 12 cores, 2 chips, 6 cores/chip (12 HW threads/chip) Network Interface: 1x 10 GBit and 1x 1GBit network ports
Memory (MB): 48208 Other Hardware:
L1 Cache: 32 KB I + 32 KB D on chip per core # of Systems: 8
L2 Cache: 256 KB I+D on chip per core H/W Available: Mar-2011
Other Cache: 12288 KB I+D on chip per chip OS 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 28700, 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:  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 webmaster@spec.org

Copyright © 2009-2018 Standard Performance Evaluation Corporation