-------------------------------------------------------------------------------- SPECjEnterprise(R)2010 Result Copyright (C) 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 -------------------------------------------------------------------------------- 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 sec DB Load Injection Rate: 20,000 Steady State Time: 3,600 sec # of Dealer Agents: 141,730 Ramp Down Time: 300 sec # of Mfg 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 Transactions51,366,358 Mfg. Transaction Mix Count Tx. Mix Failure Count CreateVehicleEJB 14,898,307 50.01% 2,483 CreateVehicleWS 14,891,359 49.99% 9,269 Total # Mfg. Transactions29,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 -------------------------------------------------------------------------------- SOFTWARE PRODUCTS -------------------------------------------------------------------------------- WebSphere Application Server V8.5.5.2 Vendor: IBM Corporation Availability Date: Jul-2014 Date Passed CTS: May-2012 CTS Version: 6.0 EJB Protocol: RMI/IIOP OS Name: IBM AIX V7.1 TL3 SP3 -------------------------------------------------------------------------------- IBM J9 VM (build 2.7, JRE 1.7.1 IBM J9 AIX ppc-32) Vendor: IBM Corporation Availability Date: 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 Date: Jun-2011 OS Name: Novell SUSE Linux Enterprise Server 11 SP1 -------------------------------------------------------------------------------- IBM DB2 Universal JDBC Drivers (3.65.109) Vendor: IBM Corporation Availability Date: Feb-2014 OS Name: IBM AIX V7.1 TL3 SP3 -------------------------------------------------------------------------------- DB2 10.5 FP3 Vendor: IBM Corporation Availability Date: Feb-2014 OS Name: IBM AIX V7.1 TL3 SP3 -------------------------------------------------------------------------------- IBM InfoSphere Optim pureQuery Runtime v3.1.1 Vendor: IBM Availability Date: May-2012 Description: IBM InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows Version 3.1.1 -------------------------------------------------------------------------------- SOFTWARE CONFIGURATIONS -------------------------------------------------------------------------------- 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 -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- JEE AppServer HW (SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM Power S824 Processor: POWER8 (Intelligent Energy Optimization enabled up to 3.92 GHz) MHz: 3525 # of CPUs: 24 cores, 4 chips, 6 cores/chip (8 HW threads/core) Memory (MB): 524288 DIMM[0] Count: 16 DIMM[0] Size: 32768 L1 Cache: 32 KB I + 64 KB D on chip per core L2 Cache: 512 KB I+D on chip per core Other Cache: L3 Cache: 8 MB per core; L4 Cache: 16 MB per CDIMM OS Vendor: IBM OS Name: IBM AIX V7.1 TL3 SP3 Disks: 2x300GB 15K SAS Network Interface: 6x 10GBit and 24x 1GBit network ports Other Hardware: # of Systems: 1 H/W Available: Jun-2014 O/S 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 Model Name: IBM Power S824 Processor: POWER8 (Intelligent Energy Optimization enabled up to 3.92 GHz) MHz: 3525 # of CPUs: 24 cores, 4 chips, 6 cores/chip (8 HW threads/core) Memory (MB): 1048576 DIMM[0] Count: 16 DIMM[0] Size: 65536 L1 Cache: 32 KB I + 64 KB D on chip per core L2 Cache: 512 KB I+D on chip per core Other Cache: L3 Cache: 8 MB per core; L4 Cache: 16 MB per CDIMM OS Vendor: IBM OS Name: IBM AIX V7.1 TL3 SP3 Disks: 2x300GB 15K SAS, 16x387GB SFF-1 eMLC SSD Network Interface: 7x 10GBit network ports Other Hardware: # of Systems: 1 H/W Available: Jun-2014 O/S 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 Model Name: IBM Power 730 Express Processor: POWER7+ MHz: 4228 # of CPUs: 16 cores, 2 chips, 8 cores/chip (4 HW threads/core) Memory (MB): 131072 DIMM[0] Count: 16 DIMM[0] Size: 8192 L1 Cache: 32 KB I + 32 KB D on chip per core L2 Cache: 256 KB I+D on chip per core Other Cache: 10 MB I+D on chip per core OS Vendor: IBM Corporation OS Name: IBM AIX V6.1 TL7 Disks: 1x146GB 15K RPM Network Interface: 2x 10GBit Other Hardware: # of Systems: 1 H/W Available: Feb-2013 O/S 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 Model Name: IBM BladeCenter HS22 Processor: Xeon X5690 MHz: 3470 # of CPUs: 12 cores, 2 chips, 6 cores/chip Memory (MB): 98304 L1 Cache: 32KB(I)+32KB(D) L2 Cache: 256 I+D on chip per core Other Cache: 12 MB I+D on chip per chip OS Vendor: Novell OS Name: Novell SUSE Linux Enterprise Server 11 SP1 Disks: 1x600GB 10K SAS Network Interface: 2x 10GBit network ports Other Hardware: # of Systems: 7 H/W Available: Apr-2011 O/S 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 Model Name: IBM BladeCenter HS23 Processor: Xeon E5-2665 MHz: 2400 # of CPUs: 16 cores, 2 chips, 8 cores/chip Memory (MB): 98304 L1 Cache: 32KB(I)+32KB(D) L2 Cache: 256 I+D on chip per core Other Cache: 20 MB I+D on chip per chip OS Vendor: Novell OS Name: Novell SUSE Linux Enterprise Server 11 SP1 Disks: 1x600GB 10K SAS Network Interface: 2x 10GBit network ports Other Hardware: # of Systems: 6 H/W Available: May-2013 O/S 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 SPEC - 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 Copyright (C) 2009-2014 Standard Performance Evaluation Corporation