SPEC Seal of Reviewal SPECjEnterprise®2010 Result
Copyright © 2009-2014 Standard Performance Evaluation Corporation
WebSphere Application Server V8.5.5.2 and DB2 10.5 on IBM Power S824
22,543.34 SPECjEnterprise2010 EjOPS
Submitter:
IBM Corporation
SPEC license # 11 Test date:
Mar-2014
Software Products
WebSphere Application Server V8.5.5.2
IBM J9 VM (build 2.7, JRE 1.7.1 IBM J9 AIX ppc-32)
IBM J9 VM (build 2.6, JRE 1.6.0 IBM J9 Linux x86-32)
IBM DB2 Universal JDBC Drivers (3.65.109)
DB2 10.5 FP3
IBM InfoSphere Optim pureQuery Runtime v3.1.1
Software Configurations
JEE Application Server
Emulator Software Config
Database Software Config
Driver 1 Config
Driver 2 Config
Hardware Systems
JEE AppServer HW
Database Server HW
Emulator HW
Master & Load Driver 1 HW
Load Driver 2 HW

System Configuration Diagram

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

SUT Configuration
JEE Server Nodes: 1   DB Server Nodes: 1
JEE Server CPUs: 24 cores, 4 chips   DB Server CPUs: 24 cores, 4 chips
JEE Instances: 24   DB Instances: 1
Other SUT Components:
   

Benchmark Settings
Dealer Injection Rate: 14,173   Ramp Up Time: 1,200 seconds
DB Load Injection Rate: 20,000   Steady State Time: 3,600 seconds
# of Dealer Agents: 141,730   Ramp Down Time: 300 seconds
# of Manufacturing Agents: 42,519  

Detailed Results
Dealer Transaction Mix Count Tx. Mix Failure Count
Purchase 12,841,039 25.00% 5
Manage 12,843,178 25.00% 6
Browse 25,682,141 50.00% 0
Total # Dealer Transactions 51,366,358
Manufacturing Transaction Mix Count Tx. Mix Failure Count
CreateVehicleEJB 14,898,307 50.01% 2,483
CreateVehicleWS 14,891,359 49.99% 9,269
Total # Manufacturing Transactions 29,789,666
Response Times Average Standard Deviation Maximum 90th% Reqd
Purchase 0.084 0.19 6.742 0.160 2.000
Manage 0.086 0.11 7.738 0.180 2.000
Browse 0.094 0.21 4.923 0.190 2.000
CreateVehicleEJB 0.217 0.59 36.539 0.425 5.000
CreateVehicleWS 0.234 0.91 40.209 0.250 5.000
Reproducibility Run (SPECjEnterprise2010 EjOPS) 22,554.87

WebSphere Application Server V8.5.5.2
Vendor: IBM Corporation Availability: Jul-2014
CTS Version: 6.0 Date Passed CTS: May-2012
OS Name: IBM AIX V7.1 TL3 SP3
EJB Protocol: RMI/IIOP

IBM J9 VM (build 2.7, JRE 1.7.1 IBM J9 AIX ppc-32)
Vendor: IBM Corporation Availability: Jul-2014
OS Name: IBM AIX V7.1 TL3 SP3

IBM J9 VM (build 2.6, JRE 1.6.0 IBM J9 Linux x86-32)
Vendor: IBM Corporation Availability: Jun-2011
OS Name: Novell SUSE Linux Enterprise Server 11 SP1

IBM DB2 Universal JDBC Drivers (3.65.109)
Vendor: IBM Corporation Availability: Feb-2014
OS Name: IBM AIX V7.1 TL3 SP3

DB2 10.5 FP3
Vendor: IBM Corporation Availability: Feb-2014
OS Name: IBM AIX V7.1 TL3 SP3

IBM InfoSphere Optim pureQuery Runtime v3.1.1
Vendor: IBM Availability: May-2012
Description: IBM InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows Version 3.1.1

JEE Application Server
JEE Product: WebSphere Application Server V8.5.5.2
JVM Product: IBM J9 VM (build 2.7, JRE 1.7.1 IBM J9 AIX ppc-32)
JDBC Product: IBM DB2 Universal JDBC Drivers (3.65.109)
Other Product: IBM InfoSphere Optim pureQuery Runtime v3.1.1
Hardware: JEE AppServer HW
# of Instances: 24
Interfaces:
Web Interface for the Order Domain
Web Services Interface for the Supplier Domain
EJB Interface for the Manufacturing Domain
Web Services Interface for the Manufacturing Domain
Notes / Tuning Information
JVM Parameters:
  -Xms2304m -Xmx2304m -Xmn1624m -Xnoloa -Xmn2048m
  -Xaggressive -Xshareclasses:none -Xss128k -Xnoloa -Xmn2048m
  -XtlhPrefetch -Xcodecache14m -Xnodfpbd -Xnocompactgc -Xnoclassgc -Xconcurrentlevel0
  -Xgcthreads7 -Xdisableexplicitgc -Xtrace:none -Xlp -Xmso128K -XXsetHWPrefetch:os-default

Refer to files appservers/node.resources.xml, and appservers/server.xml
for all server configuration and resource configuration information

WebSphere Application Server APAR Fixes PI14301
InfoSphere Optim pureQuery Runtime is used by WebSphere Applicatioin Server for efficient statement batching

Emulator Software Config
JEE Product: WebSphere Application Server V8.5.5.2
JVM Product: IBM J9 VM (build 2.7, JRE 1.7.1 IBM J9 AIX ppc-32)
Hardware: Emulator HW
# of Instances: 24
Notes / Tuning Information
JVM Parameters:
  -Xms2048m -Xmx2048m -Xss128k -Xgcpolicy:gencon -Xnoloa -Xmo500m -Xmn1548m -Xgcthreads4 -Xdisableexplicitgc
  -Djavax.xml.transform.TransformerFactory=org.apache.xalan.processor.TransformerFactoryImpl
  -Djavax.xml.parsers.SAXParserFactory=org.apache.xerces.jaxp.SAXParserFactoryImpl
  -Djavax.xml.parsers.DocumentBuilderFactory=org.apache.xerces.jaxp.DocumentBuilderFactoryImpl
  -Djava.net.preferIPv4Stack=true -Dsun.net.inetaddr.ttl=0 -Xtrace:none
  -Dcom.ibm.websphere.naming.hostname.normalizer=...none... -DdisableWSAddressCaching=true

Refer to files emulator/server.xml
for all server configuration and resource configuration information

Database Software Config
DB Product: DB2 10.5 FP3
Hardware: Database Server HW
# of Instances: 1
Character Set: UTF-8
Notes / Tuning Information
DB2 Registry Variables:
  DB2_RESOURCE_POLICY             = /home/db2inst1/scripts/loggerpri.cfg
  DB2_USE_ALTERNATE_PAGE_CLEANING = ON
  APM_THROTTLE                    = 32
  DB2_MINIMIZE_LISTPREFETCH       = YES
  DB2_KEEPTABLELOCK               = CONNECTION
  DB2_APM_PERFORMANCE             = ON
  DB2_COLLECT_TS_REC_INFO         = FALSE
  DB2COMM                         = TCPIP
  DB2AUTOSTART                    = NO

Database Manager Configuration:
  DIAGLEVEL = 1
  DFT_MON_BUFPOOL   = OFF
  DFT_MON_LOCK      = OFF
  DFT_MON_SORT      = OFF
  DFT_MON_STMT      = OFF
  DFT_MON_TABLE     = OFF
  DFT_MON_TIMESTAMP = OFF
  DFT_MON_UOW       = OFF
  HEALTH_MON        = OFF
  SHEAPTHRES        = 2000000
  MAX_COORDAGENTS   = AUTOMATIC(3000)
  SPM_MAX_RESYNC    = 20

Database Configuration:
  SELF_TUNING_MEM = ON
  SHEAPTHRES_SHR  = 183205
  SORTHEAP        = 50000
  LOCKLIST        = 200000
  MAXLOCKS        = 100
  LOGBUFSZ        = 4096
  UTIL_HEAP_SZ    = AUTOMATIC(223415)
  STMTHEAP        = AUTOMATIC(8192)
  APPLHEAPSZ      = AUTOMATIC(256)
  APPL_MEMORY     = AUTOMATIC(40000)
  STAT_HEAP_SZ    = AUTOMATIC(4384)
  DLCHKTIME       = 10000
  LOCKTIMEOUT     = -1
  CHNGPGS_THRESH  = 99
  NUM_IOCLEANERS  = 32
  LOGFILSIZ       = 512000
  LOGPRIMARY      = 256
  LOGSECOND       = 0
  SOFTMAX         = 8080
  LOGARCHMETH1    = OFF
  AUTO_MAINT      = OFF
  AUTO_TBL_MAINT  = OFF
  AUTO_RUNSTATS   = OFF
  AUTO_STMT_STATS = OFF
  MON_REQ_METRICS = NONE
  MON_ACT_METRICS = NONE
  MON_OBJ_METRICS = NONE
  MON_RTN_DATA    = NONE

Buffer Pool Configuration:
   Refer to file schema/bptune.sh for buffer pool tuning information.

Full details of the database configuration information and ddl files
are located in the schema directory of the FDA.

Driver 1 Config
JVM Product: IBM J9 VM (build 2.6, JRE 1.6.0 IBM J9 Linux x86-32)
Hardware: Master & Load Driver 1 HW
# of Instances: 6
Notes / Tuning Information
JVM Parameters:
  -Xms2048m -Xmx2048m -Xss128k -Xgcpolicy:gencon -Xnoloa -Xmo512m -Xmn1536m -Xtrace:none
  -Xaggressive -Djava.net.preferIPv4Stack=true -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0
  -Dcom.ibm.websphere.naming.jndicache.cacheobject=none -Dcom.ibm.websphere.naming.hostname.normalizer=...none...
  -DdisableWSAddressCaching=true -Dcom.ibm.CORBA.ConnectionMultiplicity=45
  -Dcom.ibm.CORBA.FragmentSize=0 -Dcom.ibm.CORBA.RequestTimeout=900

Driver 2 Config
JVM Product: IBM J9 VM (build 2.6, JRE 1.6.0 IBM J9 Linux x86-32)
Hardware: Load Driver 2 HW
# of Instances: 6
Notes / Tuning Information
JVM Parameters:
  -Xms2048m -Xmx2048m -Xss128k -Xgcpolicy:gencon -Xnoloa -Xmo512m -Xmn1536m -Xtrace:none
  -Xaggressive -Djava.net.preferIPv4Stack=true -Dsun.net.inetaddr.ttl=0 -Dnetworkaddress.cache.ttl=0
  -Dcom.ibm.websphere.naming.jndicache.cacheobject=none -Dcom.ibm.websphere.naming.hostname.normalizer=...none...
  -DdisableWSAddressCaching=true -Dcom.ibm.CORBA.ConnectionMultiplicity=45
  -Dcom.ibm.CORBA.FragmentSize=0 -Dcom.ibm.CORBA.RequestTimeout=900

JEE AppServer HW (SUT hardware)
Hardware Vendor: IBM Corporation OS Vendor: IBM
Model Name: IBM Power S824 OS Name: IBM AIX V7.1 TL3 SP3
Processor: POWER8 (Intelligent Energy Optimization enabled up to 3.92 GHz) Filesystem: AIX/JFS2
MHz: 3525 Disks: 2x300GB 15K SAS
# of CPUs: 24 cores, 4 chips, 6 cores/chip (8 HW threads/core) Network Interface: 6x 10GBit and 24x 1GBit network ports
Memory (MB): 524288 Other Hardware:
DIMM[0] Count: 16 DIMM[0] Size: 32768
L1 Cache: 32 KB I + 64 KB D on chip per core # of Systems: 1
L2 Cache: 512 KB I+D on chip per core H/W Available: Jun-2014
Other Cache: L3 Cache: 8 MB per core; L4 Cache: 16 MB per CDIMM OS Available: Jun-2014
Notes / Tuning Information
Tunings:
  ulimit -s unlimited; ulimit -d unlimited; ulimit -m unlimited; ulimit -f unlimited; ulimit -n unlimited
  export MEMORY_AFFINITY=MCM
  skeyctl -u 0
  skeyctl -k off
  schedo -o smt_snooze_delay=-1
  asoo -o aso_active=0
  dscrctl  -n -b -s 2
  ctctrl -P memtraceoff
  errctrl -P errcheckoff
  raso -r -o mtrc_enabled=0
  vmo -o lgpg_regions=10240 -o lgpg_size=16777216 -o v_pinshm=1
  no -ro netm_affinity=1
  smtctl -t 8 -w boot
  setsched -S fifo2 -P 60 -t <TID> on every java thread
  setsched -S fifo2 -P 60 -p <PID> on every java process

Network Tuning 1Gbe:
  rx_coalesce=64
  large_receive=yes
  rx_queues=2
  Network interrupts bound to a core corresponding to the server instance

Network Tuning 10Gbe (Product - 5287, 2x 10Gbe port PCI NW adapter):
  large_receive=yes
  rx_queues=5
  intr_rate=2500
  Network interrupts bound to cores corresponding to the server instances that share the interface
	
Network Tuning 10Gbe (Product - EN08, 2x 10Gbe 2x 1Gbe port PCI NW adapter):
  large_receive=yes
  queues_rx=5
  intr_time=400
  Network interrupts bound to cores corresponding to the server instances that share the interface

Server instances were started using execrset, binding 1 instances per core.
The "Dynamic Power Saver - Favor Performance" mode was enabled on "IBM Advanced System Management

Database Server HW (SUT hardware)
Hardware Vendor: IBM Corporation OS Vendor: IBM
Model Name: IBM Power S824 OS Name: IBM AIX V7.1 TL3 SP3
Processor: POWER8 (Intelligent Energy Optimization enabled up to 3.92 GHz) Filesystem: AIX/JFS2
MHz: 3525 Disks: 2x300GB 15K SAS, 16x387GB SFF-1 eMLC SSD
# of CPUs: 24 cores, 4 chips, 6 cores/chip (8 HW threads/core) Network Interface: 7x 10GBit network ports
Memory (MB): 1048576 Other Hardware:
DIMM[0] Count: 16 DIMM[0] Size: 65536
L1 Cache: 32 KB I + 64 KB D on chip per core # of Systems: 1
L2 Cache: 512 KB I+D on chip per core H/W Available: Jun-2014
Other Cache: L3 Cache: 8 MB per core; L4 Cache: 16 MB per CDIMM OS Available: Jun-2014
Notes / Tuning Information
Tunings:
  ulimit -s unlimited; ulimit -d unlimited; ulimit -m unlimited; ulimit -f unlimited; ulimit -n unlimited
  smtctl -t 8 -w boot

Network Tuning:
  intr_rate=3000
  rx_coalesce=64
  rx_queues=3
  tx_queues=5

The "Dynamic Power Saver - Favor Performance" mode was enabled on "IBM Advanced System Management

Emulator HW (non-SUT hardware)
Hardware Vendor: IBM Corporation OS Vendor: IBM Corporation
Model Name: IBM Power 730 Express OS Name: IBM AIX V6.1 TL7
Processor: POWER7+ Filesystem: AIX/JFS2
MHz: 4228 Disks: 1x146GB 15K RPM
# of CPUs: 16 cores, 2 chips, 8 cores/chip (4 HW threads/core) Network Interface: 2x 10GBit
Memory (MB): 131072 Other Hardware:
DIMM[0] Count: 16 DIMM[0] Size: 8192
L1 Cache: 32 KB I + 32 KB D on chip per core # of Systems: 1
L2 Cache: 256 KB I+D on chip per core H/W Available: Feb-2013
Other Cache: 10 MB I+D on chip per core OS Available: Nov-2011
Notes / Tuning Information
Tunings:
  ulimit -s unlimited; ulimit -d unlimited; ulimit -m unlimited; ulimit -f unlimited; ulimit -n unlimited


Network Tuning:
  intr_rate=2000
  rx_coalesce=64
  rx_queues=3
  tx_queues=5

Master & Load Driver 1 HW (non-SUT hardware)
Hardware Vendor: IBM Corporation OS Vendor: Novell
Model Name: IBM BladeCenter HS22 OS Name: Novell SUSE Linux Enterprise Server 11 SP1
Processor: Xeon X5690 Filesystem: ext3
MHz: 3470 Disks: 1x600GB 10K SAS
# of CPUs: 12 cores, 2 chips, 6 cores/chip Network Interface: 2x 10GBit network ports
Memory (MB): 98304 Other Hardware:
L1 Cache: 32KB(I)+32KB(D) # of Systems: 7
L2 Cache: 256 I+D on chip per core H/W Available: Apr-2011
Other Cache: 12 MB I+D on chip per chip OS Available: Jun-2010
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

ulimit -n 1048576

Network Tuning:
  set txqueuelen 60000

Load Driver 2 HW (non-SUT hardware)
Hardware Vendor: IBM Corporation OS Vendor: Novell
Model Name: IBM BladeCenter HS23 OS Name: Novell SUSE Linux Enterprise Server 11 SP1
Processor: Xeon E5-2665 Filesystem: ext3
MHz: 2400 Disks: 1x600GB 10K SAS
# of CPUs: 16 cores, 2 chips, 8 cores/chip Network Interface: 2x 10GBit network ports
Memory (MB): 98304 Other Hardware:
L1 Cache: 32KB(I)+32KB(D) # of Systems: 6
L2 Cache: 256 I+D on chip per core H/W Available: May-2013
Other Cache: 20 MB I+D on chip per chip OS Available: Jun-2010
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

ulimit -n 1048576

Network Tuning:
  set txqueuelen 60000

Benchmark Modifications
Schema Modifications:
  Scripts to create the database are included in the FDA.
  All tables except the following are range partitioned: S_SUPPLIER, S_RUN_CONFIG, U_SEQUENCES, U_DATASEGMENT, U_LOADER, U_LOAD_MESSAGE, U_LOAD_SECTION
  New indexes are added to the following tables: M_INVENTORY, M_PARTS, S_SUPP_COMPONENT
Load Program Modifications:
  No modifications to the load programs were made.

Benchmark Configuration Information
Isolation Requirement Info:
  The benchmark meets the isolation level requirements by version column
    checking on entities against the database.
  The ItemEnt bean was cached for 20 minute intervals using
    the WebSphere JPA Object Cache mechanism.
Durability Requirement Info:
  To ensure database durability, the database and the database logs were each maintained on 8 mirrored internal 400GB SSD drives
Storage Requirement Info:
  Over the course of a 85 minute run at an injection rate of
     14173, the database storage for database system increased by 61 GB.
     Given a linear scale, a 24 hour run at the same
     injection rate would increase storage for database system by 1039 GB.
     The database was configured with 1400 GB of mirrored storage.

Bill of Materials
Supplier  Description                                             Product #          Qty
--------  -------------------------------------------             ----------------   ---
Application Server:
IBM       IBM Power S824 Model 42A                                  8286-42A           1
IBM             AC POWER SUPPLY, 100-127V/200-240V, 900 WATT        EB2L               4
IBM             LANGUAGE SPECIFY ENGLISH                            9300               1
IBM             PRIMARY OPERATING SYSTEM INDICATOR - AIX            2146               1
IBM             AIX PARTITION SPECIFY (ONE PER PARTITION)            265               1
IBM             IBM BEZEL + MISC HDWR & LOW FUNCTION BP FILLER,
-                           42A RACK-MOUNT DRAWER                   EJTC               1
IBM             PWR CBL, DRWR TO IBM PDU, MFG SEL LENGTH,
-                           200-240V/10A, IEC320/C13, IEC320/C14    6577               4
IBM             8GB DDR3 1600Mhz MEMORY ACTIVATION                  EMA5              64
IBM             4U SAS RAID 0,10 PKG + CNTRLR CD +
-                  2X MINI SAS HD CBL + BP(12X SFF + SAS SLIM DVD)
-                    (SOLSTICE 4U, MIAOKOU)                         EJ0N               1
IBM             300GB 15K RPM SAS HDD, SFF IN GEN3 CARRIER          ESDB               2
IBM             SATA DVDRAM WITH WRITE CACHE, SLIM-LINE             5771               1
IBM             DUAL PORT E`NET (2X SFP+(SR) 10Gb), PCIE2-8X/LPC    5287               2
IBM             PCIe2 4-port(10Gb FCoE & 1GbE) SR&RJ45              EN08               1
IBM             1Gb E`NET(UTP) 4-PORT ADPTR, PCIE-x4/SHORT,
-                            LOW-PROFILE CAPABLE                    5899               6
IBM             INDICATOR FOR RACK #01                              4651               1
IBM             0/12W 3.591GHz P8 DCM 220W + 4U HEAT SINK + TIM PAD EPXH               2
IBM             ($0 #EPYH) 1W PROC ENTITLEMENT FOR #EPXH            EPZH              12
IBM             32GB CDIMM (1.35V), 1600MHZ, 4GBIT DDR3 DRAM (2RX8),
-                            SHORT W/EXTENDER                       EM8C              16
IBM             1W PROC ENTITLEMENT FOR #EPXH                       EPYH              12
...
Database Server:
IBM       IBM Power S824  Model 42A                                 8286-42A           1
IBM             AC POWER SUPPLY, 100-127V/200-240V, 900 WATT        EB2L               2
IBM             LANGUAGE SPECIFY ENGLISH                            9300               1
IBM             PRIMARY OPERATING SYSTEM INDICATOR - AIX            2146               1
IBM             AIX PARTITION SPECIFY (ONE PER PARTITION)            265               1
IBM             IBM BEZEL + MISC HDWR & LOW FUNCTION BP FILLER,
-                                42A RACK-MOUNT DRAWER              EJTC               1
IBM             PWR CBL, DRWR TO IBM PDU, MFG SEL LENGTH,
-                           200-240V/10A, IEC320/C13, IEC320/C14    6577               4
IBM             64GB CDIMM (1.35V), 1600MHZ, 4GBIT DDR3 DRAM (2RX4),
-                           DDP SHORT W/EXTENDER                    EM8D              16
IBM             8GB DDR3 1600Mhz MEMORY ACTIVATION                  EMA5             128
IBM             4U SAS RAID 0,5,6,10 + 2X CNTR +2X MINI SAS CBL
-                     + BP(18X SFF + 8X SSD + SAS SLIM DVD +2X EXT PT)
-                                (4U GX ...                         EJ0P               1
IBM             300GB 15K RPM SAS HDD, SFF IN GEN3 CARRIER          ESDB               2
IBM             SATA DVDRAM WITH WRITE CACHE, SLIM-LINE             5771               1
IBM             DUAL PORT E`NET (2X SFP+(SR) 10Gb), PCIE2-8X/LPC    5287               3
IBM             1Gb E`NET(UTP) 4-PORT ADPTR, PCIE-x4                5899               1
IBM             INDICATOR, FC 5887/EL1S FULL DRAWER, MODE 1,
-                   ONE CUBIC-J (ESA1/ESA2/EL2K), ONE 6G YO CABLES  EJP1               1
IBM             INDICATOR FOR RACK #01                              4651               1
IBM             0/12W 3.591GHz P8 DCM 220W + 4U HEAT SINK + TIM PAD EPXH               2
IBM             ($0 #EPYH) 1W PROC ENTITLEMENT FOR #EPXH            EPZH              12
IBM             1W PROC ENTITLEMENT FOR #EPXH                       EPYH              12
IBM             387GB SAS SFF SSD S/S DRIVE IN GEN 3 CARRIER        ES0L              16
...
Software:
IBM       DB2 Enterprise Server Edition v10.5.0.3                 D55IULL             24*
-           Lic+SW Maint 12 Months
IBM       DB2 Enterprise Server Edition v10.5.0.3                 E020CLL             48
-           SW Maint Rewl 1 Anniv
IBM       WebSphere Application Server V8.5.5.2                   D55W8LL             24*
-           Lic+SW Maint 12 Months
IBM       WebSphere Application Server V8.5.5.2                   E025QLL             48
-           SW Maint Rewl 1 Anniv
IBM       IBM Optim Purequery Runtime for LUW 3.1.1               D61YKLL             24*
-           Lic+SW Maint 12 Months
IBM       IBM Optim Purequery Runtime for LUW 3.1.1               E048YLL             48
-           SW Maint Rewl 1 Anniv
...
* Note:  Pricing is based on Processor Value Units (PVU).  Each core is 70 PVU.


Other Benchmark Information
  DNS round robin load balancing was used and hosted on the database machine.
  Network connectivity between the application server system and the switch outside of the SUT was 1Gps. All other connections were 10Gps.

General Notes
All exceptions in driver logs are from Optimistic Concurrency Checking.
These exceptions are expected in the benchmark.

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 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 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 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. 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-2014 Standard Performance Evaluation Corporation

First published at SPEC.org on 22-Apr-2014