SPECjEnterprise2010 Result: WebSphere Application Server V8.5.5.2 and DB2 10.5 on IBM Power S824

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

Benchmark run on Mon Mar 31 12:01:32 CDT 2014 by SPECjEnterprise2010 v1.03
Result submitted on null
Report generated by SPECjEnterprise2010 Reporter v1.00

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