-------------------------------------------------------------------------------- SPECjEnterprise(R)2010 Result Copyright (C) 2009-2013 Standard Performance Evaluation Corporation -------------------------------------------------------------------------------- WebSphere Application Server V8.5 and DB2 10.1 on IBM PowerLinux 7R2 -------------------------------------------------------------------------------- 12,062.46 SPECjEnterprise2010 EjOPS -------------------------------------------------------------------------------- Submitter: IBM Corporation SPEC license # 11 Test date: Feb-2013 -------------------------------------------------------------------------------- SUT CONFIGURATION -------------------------------------------------------------------------------- JEE Server Nodes: 1 DB Server Nodes: 1 JEE Server CPUs: 16 cores, 2 chips DB Server CPUs: 16 cores, 2 chips JEE Instances: 8 DB Instances: 1 Other SUT Components: -------------------------------------------------------------------------------- BENCHMARK SETTINGS -------------------------------------------------------------------------------- Dealer Injection Rate: 7,550 Ramp Up Time: 1,800 sec DB Load Injection Rate: 8,000 Steady State Time: 3,600 sec # of Dealer Agents: 75,500 Ramp Down Time: 300 sec # of Mfg Agents: 22,650 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Dealer Transaction Mix Count Tx. Mix Failure Count Purchase 6,835,180 25.00% 6 Manage 6,835,628 25.00% 2 Browse 13,671,615 50.00% 0 Total # Dealer Transactions27,342,423 Mfg. Transaction Mix Count Tx. Mix Failure Count CreateVehicleEJB 8,043,847 50.02% 828 CreateVehicleWS 8,038,588 49.98% 973 Total # Mfg. Transactions16,082,435 Response Times Average Standard Deviation Maximum 90th% Reqd Purchase 0.126 0.36 6.816 0.210 2.000 Manage 0.117 0.19 8.018 0.240 2.000 Browse 0.144 0.40 4.930 0.230 2.000 CreateVehicleEJB 0.039 0.03 1.078 0.075 5.000 CreateVehicleWS 0.045 0.03 7.847 0.075 5.000 Reproducibility Run (SPECjEnterprise2010 EjOPS) 12,065.53 -------------------------------------------------------------------------------- SOFTWARE PRODUCTS -------------------------------------------------------------------------------- WebSphere Application Server V8.5 Vendor: IBM Corporation Availability Date: Dec-2012 Date Passed CTS: May-2012 CTS Version: 6.0 EJB Protocol: RMI/IIOP OS Name: Red Hat Enterprise Linux Server release 6.4 -------------------------------------------------------------------------------- IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux ppc-32) Vendor: IBM Corporation Availability Date: Dec-2012 OS Name: Red Hat Enterprise Linux Server release 6.4 -------------------------------------------------------------------------------- IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux x86-64) Vendor: IBM Corporation Availability Date: Dec-2012 OS Name: Red Hat Enterprise Linux Server release 6.4 -------------------------------------------------------------------------------- IBM DB2 Universal JDBC Drivers (3.63.123) Vendor: IBM Corporation Availability Date: Apr-2012 OS Name: Red Hat Enterprise Linux Server release 6.4 -------------------------------------------------------------------------------- DB2 10.1 FP2 Vendor: IBM Corporation Availability Date: Dec-2012 OS Name: Red Hat Enterprise Linux Server release 6.4 -------------------------------------------------------------------------------- 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 JVM Product: IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux ppc-32) JDBC Product: IBM DB2 Universal JDBC Drivers (3.63.123) Other Product: IBM InfoSphere Optim pureQuery Runtime v3.1.1 Hardware: JEE AppServer HW # of Instances: 8 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 -Xmo680m -Xmn1624m -Xgcthreads8 -Xss128k -Xgcpolicy:gencon -Xshareclasses:none -Xaggressive -Xnoloa -Xtrace:none -Xlp -Xdisableexplicitgc -Dcom.ibm.CORBA.FragmentSize=10000 -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 -Dcom.ibm.websphere.jpa.entitymanager.poolcapacity=170 -DAIODisableTimeouts=true -Dclient.encoding.override=ISO-8859-1 -XtlhPrefetch -Xcodecache14m -Xnodfpbd -Xnocompactgc -Xnoclassgc Refer to files appservers/node.resources.xml, and appservers/server.xml for all server configuration and resource configuration information WebSphere Application Server APAR Fixes PM61650 PM61561 PM72010 PM71833 PM71704 InfoSphere Optim pureQuery Runtime is used by WebSphere Applicatioin Server for efficient statement batching with APAR iFix PM71704 -------------------------------------------------------------------------------- Emulator Software Config JEE Product: WebSphere Application Server V8.5 JVM Product: IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux x86-64) Hardware: Load Driver & Emulator HW # of Instances: 8 Notes / Tuning Information JVM Parameters: -Xms4096m -Xmx4096m -Xss256k -Xgcpolicy:gencon -Xnoloa -Xmo1024m -Xmn3072m -Xtrace:none -Xgcthreads8 -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 -Dcom.ibm.websphere.naming.hostname.normalizer=...none... Refer to files emulator/server.xml for all server configuration and resource configuration information -------------------------------------------------------------------------------- Database Software Config DB Product: DB2 10.1 FP2 Hardware: Database Server HW # of Instances: 1 Character Set: UTF-8 Notes / Tuning Information DB2_PMODEL_SETTINGS=MAX_BACKGROUND_SYSAPPS:500 DB2_LARGE_PAGE_MEM=DB DB2_USE_ALTERNATE_PAGE_CLEANING=ON DB2_MINIMIZE_LISTPREFETCH=YES DB2_KEEPTABLELOCK=CONNECTION DB2_APM_PERFORMANCE=ON DB2_COLLECT_TS_REC_INFO=FALSE DB2COMM=TCPIP SPM_MAX_RESYNC 40 DIAGLEVEL 3 DFT_MON_BUFPOOL on DFT_MON_LOCK on DFT_MON_SORT on DFT_MON_STMT off DFT_MON_TIMESTAMP on DFT_MON_UOW off DFT_MON_TABLE on MAX_COORDAGENTS 350 automatic CPUSPEED -1 HEALTH_MON off LOGFILSIZ 65535 SELF_TUNING_MEM off LOGBUFSZ 4096 LOGSECOND 0 LOGPRIMARY 256 SOFTMAX 8080 CHNGPGS_THRESH 99 NUM_IOCLEANERS 16 LOCKLIST 100000 MAXLOCKS 100 MINCOMMIT 1 MON_REQ_METRICS none MON_ACT_METRICS none MON_OBJ_METRICS none AUTO_STMT_STATS off AUTO_MAINT off AUTO_RUNSTATS off AUTO_TBL_MAINT off NEWLOGPATH /specjdb-log LOGARCHMETH1 off O_ORDERLINE pctfree 99 O_CUSTINVENTORY pctfree 99 O_ORDERS pctfree 99 O_ITEM volatile S_SUPPLIER volatile M_WORKORDER volatile O_ORDERLINE append on O_CUSTINVENTORY append on O_ORDERS append on S_PURCH_ORDER append on S_PURCH_ORDERLINE append on M_INVENTORY volatile IBMDEFAULTBP immediate size 10002432 SPEC_BP immediate size 4096 JMS_BP immediate size 2048 M_INV_BP immediate size 499712 M_PARTS_BP immediate size 122880 M_BOM_BP immediate size 61440 M_WO_BP immediate size 20480 M_WO2_BP immediate size 4096 M_OL_BP immediate size 4096 O_O_BP immediate size 143360 O_O2_BP immediate size 61440 O_OL_BP immediate size 102400 O_CI_BP immediate size 401408 O_C_BP immediate size 200704 O_ITEM_BP immediate size 4096 O_ITEM2_BP immediate size 4096 S_C_BP immediate size 200704 S_S_C_BP immediate size 401408 S_S_BP immediate size 4096 S_P_O_BP immediate size 4096 S_P_O2_BP immediate size 4096 S_P_OL_BP immediate size 4096 -------------------------------------------------------------------------------- Driver Config JVM Product: IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux x86-64) Hardware: Load Driver & Emulator HW # of Instances: 4 Notes / Tuning Information -Xms2048M -Xmx2048M -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=20 -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- JEE AppServer HW (SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM PowerLinux 7R2 Processor: POWER7+ (Intelligent Energy Optimization enabled up to 4.540 GHz) MHz: 4228 # of CPUs: 16 cores, 2 chips, 8 cores/chip (32 HW threads/chip) 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: Red Hat OS Name: Red Hat Enterprise Linux Server release 6.4 Disks: 2x600GB 10K SAS Network Interface: 4x 10GBit and 4x 1GBit network ports Other Hardware: # of Systems: 1 H/W Available: Feb-2013 O/S Available: Feb-2013 Notes / Tuning Information fs.file-max = 4878674 kernel.sem = 250 32000 100 128 kernel.shmall = 4294967296 kernel.shmmax = 68719476736 net.core.netdev_max_backlog = 400000 net.core.optmem_max = 30000000 net.core.rmem_default = 30000000 net.core.wmem_default = 30000000 net.core.rmem_max = 30000000 net.core.wmem_max = 30000000 net.core.somaxconn = 300000 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_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_wmem = 30000000 30000000 30000000 net.ipv4.tcp_timestamps = 0 net.ipv4.tcp_sack = 0 net.ipv4.neigh.default.gc_thresh1 = 4096 net.ipv4.neigh.default.gc_thresh2 = 8192 net.ipv4.neigh.default.gc_thresh3 = 8192 net.ipv4.neigh.default.base_reachable_time = 86400 net.ipv4.neigh.default.gc_stale_time = 86400 net.ipv4.neigh.eth0.base_reachable_time = 86400 net.ipv4.neigh.eth0.gc_stale_time = 86400 net.ipv4.neigh.eth1.base_reachable_time = 86400 net.ipv4.neigh.eth1.gc_stale_time = 86400 net.ipv4.neigh.eth2.base_reachable_time = 86400 net.ipv4.neigh.eth2.gc_stale_time = 86400 net.ipv4.neigh.eth3.base_reachable_time = 86400 net.ipv4.neigh.eth3.gc_stale_time = 86400 net.ipv6.conf.all.disable_ipv6 = 1 vm.nr_hugepages = 1664 ulimit -n 1048576 ulimit -u unlimited ulimit -s 524288 ppc64_cpu --dscr=1 Set the no preempt scheduler mount -t debugfs debugfs /sys/kernel/debug echo NO_WAKEUP_PREEMPT > /sys/kernel/debug/sched_features umount /sys/kernel/debug Network Tuning: Stop irqbalance. Network interrupts bound to cores corresponding to the server instances. Set interrupt coalescing for all interfaces ethtool -C eth rx-usecs 200 rx-frames 0 Server instances were started using taskset, binding 4 instances per chip. -------------------------------------------------------------------------------- Database Server HW (SUT hardware) Hardware Vendor: IBM Corporation Model Name: PowerLinux 7R2 Processor: POWER7+ (Intelligent Energy Optimization enabled up to 4.540 GHz) MHz: 4228 # of CPUs: 16 cores, 2 chips, 8 cores/chip (32 HW threads/chip) Memory (MB): 262144 DIMM[0] Count: 16 DIMM[0] Size: 16384 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: Red Hat OS Name: Red Hat Enterprise Linux Server release 6.4 Disks: 2x600GB 10K SAS Network Interface: 5x 1GBit network ports Other Hardware: IBM Storwize V7000 with 24x600GB 10K SAS # of Systems: 1 H/W Available: Feb-2013 O/S Available: Feb-2013 Notes / Tuning Information fs.file-max = 4878674 kernel.sem = 250 32000 100 128 kernel.shmall = 4294967296 kernel.shmmax = 68719476736 net.core.netdev_max_backlog = 400000 net.core.optmem_max = 30000000 net.core.rmem_default = 30000000 net.core.wmem_default = 30000000 net.core.rmem_max = 30000000 net.core.wmem_max = 30000000 net.core.somaxconn = 300000 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_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_wmem = 30000000 30000000 30000000 net.ipv4.tcp_timestamps = 0 net.ipv4.tcp_sack = 0 net.ipv4.neigh.default.gc_thresh1 = 4096 net.ipv4.neigh.default.gc_thresh2 = 8192 net.ipv4.neigh.default.gc_thresh3 = 8192 net.ipv4.neigh.default.base_reachable_time = 86400 net.ipv4.neigh.default.gc_stale_time = 86400 net.ipv4.neigh.eth0.base_reachable_time = 86400 net.ipv4.neigh.eth0.gc_stale_time = 86400 net.ipv4.neigh.eth1.base_reachable_time = 86400 net.ipv4.neigh.eth1.gc_stale_time = 86400 net.ipv4.neigh.eth2.base_reachable_time = 86400 net.ipv4.neigh.eth2.gc_stale_time = 86400 net.ipv4.neigh.eth3.base_reachable_time = 86400 net.ipv4.neigh.eth3.gc_stale_time = 86400 net.ipv6.conf.all.disable_ipv6 = 1 vm.nr_hugepages = 3584 ulimit -n 1048576 ulimit -u unlimited ulimit -s 524288 ppc64_cpu --dscr=1 Set the no preempt scheduler mount -t debugfs debugfs /sys/kernel/debug echo NO_WAKEUP_PREEMPT > /sys/kernel/debug/sched_features umount /sys/kernel/debug Network Tuning: Set interrupt coalescing for all interfaces ethtool -C eth rx-usecs 100 -------------------------------------------------------------------------------- Load Driver & Emulator HW (non-SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM Flex System x240 Processor: Xeon E5-2680 MHz: 2700 # of CPUs: 16 cores, 2 chips, 8 cores/chip Memory (MB): 65536 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: Red Hat OS Name: Red Hat Enterprise Linux Server release 6.4 Disks: 1x600GB 10K SAS Network Interface: 2x 10GBit network ports Other Hardware: # of Systems: 5 H/W Available: May-2012 O/S Available: Feb-2013 Notes / Tuning Information fs.file-max = 4878674 kernel.sem = 250 32000 100 128 kernel.shmall = 4294967296 kernel.shmmax = 68719476736 net.core.netdev_max_backlog = 400000 net.core.optmem_max = 30000000 net.core.rmem_default = 30000000 net.core.wmem_default = 30000000 net.core.rmem_max = 30000000 net.core.wmem_max = 30000000 net.core.somaxconn = 300000 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_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_wmem = 30000000 30000000 30000000 net.ipv4.tcp_timestamps = 0 net.ipv4.tcp_sack = 0 net.ipv4.conf.all.arp_announce = 2 net.ipv4.conf.all.arp_ignore = 1 net.ipv4.neigh.default.gc_thresh1 = 4096 net.ipv4.neigh.default.gc_thresh2 = 8192 net.ipv4.neigh.default.gc_thresh3 = 8192 net.ipv4.neigh.default.base_reachable_time = 86400 net.ipv4.neigh.default.gc_stale_time = 86400 net.ipv4.neigh.eth0.base_reachable_time = 86400 net.ipv4.neigh.eth0.gc_stale_time = 86400 net.ipv4.neigh.eth1.base_reachable_time = 86400 net.ipv4.neigh.eth1.gc_stale_time = 86400 net.ipv4.neigh.eth2.base_reachable_time = 86400 net.ipv4.neigh.eth2.gc_stale_time = 86400 net.ipv4.neigh.eth3.base_reachable_time = 86400 net.ipv4.neigh.eth3.gc_stale_time = 86400 net.ipv6.conf.all.disable_ipv6 = 1 ulimit -n 1048576 ulimit -u unlimited ulimit -s 524288 -------------------------------------------------------------------------------- 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, RAID10 was used for the database and database logs maintained on the external storage. A total of 4 x 600GB disks were used for the log. -------------------------------------------------------------------------------- Storage Requirement Info: Over the course of a 95 minute run at an injection rate of 7550, the database storage for database system increased by 10.25 GB. Given a linear scale, a 24 hour run at the same injection rate would increase storage for database system by 155.37 GB. One RAID10 disk array was used to create the filesystem space for the database. The array contained 20 x 600GB disks providing over 4 TB of storage. BILL OF MATERIALS -------------------------------------------------------------------------------- Supplier Description Product # Qty -------- ------------------------------------------- ---------------- --- IBM IBM PowerLinux 7R2 8246-L2D 1 IBM Linux Partition Specify 0266 1 IBM Primary OS - Linux 2147 1 IBM Software Preload Required 5000 1 IBM PCIe2 LP 4-Port 10GbE&1GbE SFP+ Copper&RJ45 5279 2 IBM System AC Power Supply, 1925 W 5532 2 IBM SATA Slimline DVD-RAM Drive 5762 1 IBM Power Cord 2.7M (9-foot), Drawer to IBM 6671 2 - PDU, 250V/10A IBM Linux Software Preinstall 8143 1 IBM New Red Hat License Core Counter 9442 16 IBM RHEL for POWER 5639-RHP 3 IBM Per Svr up to 2 Skts IPL w/max 1 LPARs 0385 3 - w/1yr STD Sub IBM 600GB 10K RPM SFF SAS Disk Drive - PowerLinux EL0P 2 IBM Memory Riser Card - PowerLinux (zero priced) EL0A 1 IBM Memory Riser Card - PowerLinux EL0K 3 IBM Storage Backplane -- 6 SFF Drives/SATA DVD/RAID EL0V 1 IBM 16GB (2x8GB) Memory DIMMs - PowerLinux EL2Q 8 IBM PowerLinux Base package -- 16-core 4.2 GHz ELBD 1 IBM 8-core 4.2 GHz POWER7+ Processor Module EPLK 2 IBM Processor Activation for #EPLK (Zero-priced) EPLN 16 IBM Warranty Service Upgrade 6942-25B 3 IBM WSU Same Day 24x7x4 Response 4524 3 ... IBM IBM PowerLinux 7R2 8246-L2D 1 IBM Linux Partition Specify 0266 1 IBM Primary OS - Linux 2147 1 IBM System Serial Port Converter Cable 3930 1 IBM Software Preload Required 5000 1 IBM PCIe LP 2-Port 1GbE TX Adapter 5281 3 IBM System AC Power Supply, 1925 W 5532 2 IBM SATA Slimline DVD-RAM Drive 5762 1 IBM Power Cord 2.7M (9-foot), Drawer to IBM 6671 2 - PDU, 250V/10A IBM Linux Software Preinstall 8143 1 IBM Language Group Specify - US English 9300 1 IBM New Red Hat License Core Counter 9442 16 IBM RHEL for POWER 5639-RHP 3 IBM Per Svr up to 2 Skts IPL w/max 1 LPARs 0385 3 - w/1yr STD Sub IBM 600GB 10K RPM SFF SAS Disk Drive - PowerLinux EL0P 2 IBM Memory Riser Card - PowerLinux 5265 3 IBM Storage Backplane -- 6 SFF Drives/SATA DVD/RAID EL0V 1 IBM 32GB (2x16GB) Memory DIMMs - PowerLinux EL2T 8 IBM PowerLinux Base package -- 16-core 4.2 GHz ELBD 1 IBM 8-core 4.2 GHz POWER7+ Processor Module EPLK 2 IBM Processor Activation for #EPL5 (Zero-priced) EPLN 16 IBM PCIe LP 4Gb 2-Port Fibre Channel Adapter EL09 1 IBM Warranty Service Upgrade 6942-25B 3 IBM WSU Same Day 24x7x4 Response 4524 3 ... IBM IBM Storwize V7000 Disk Control Enclosure 2076-124 1 IBM Storage Engine Preload 0010 1 IBM 600GB 6Gb SAS 10K 2.5-inch SFF HDD 3546 24 IBM 1 m Fiber Optic Cable LC-LC 5301 2 IBM Cache 8 GB 6008 2 IBM Power Cord - PDU connection 9730 1 IBM AC Power Supply 9801 2 IBM 3 Year Onsite Repair 24x7 4 Hour Response ... IBM DB2 Enterprise Server Edition 10.1 D55IULL 16* - Lic+SW Maint 12 Months IBM DB2 Enterprise Server Edition 10.1 E020CLL 32 - SW Maint Rewl 1 Anniv IBM WebSphere Application Server V8.5 D55W8LL 16* - Lic+SW Maint 12 Months IBM WebSphere Application Server V8.5 E025QLL 32 - SW Maint Rewl 1 Anniv IBM IBM Optim Purequery Runtime for LUW 3.1.1 D61YKLL 16* - Lic+SW Maint 12 Months IBM IBM Optim Purequery Runtime for LUW 3.1.1 E048YLL 32 - 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 All network connectivity to the database system was 1Gbps 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 Tue Feb 05 17:49:10 CST 2013 by SPECjEnterprise2010 v1.03 - Result submitted on null - Report generated by SPECjEnterprise2010 Reporter v1.00 Copyright (C) 2009-2013 Standard Performance Evaluation Corporation