-------------------------------------------------------------------------------- SPECjEnterprise(R)2010 Result Copyright (C) 2009-2012 Standard Performance Evaluation Corporation -------------------------------------------------------------------------------- WebSphere Application Server V8.5 on IBM System x3650 M4 and DB2 10.1 on IBM System x3650 M4 -------------------------------------------------------------------------------- 9,696.43 SPECjEnterprise2010 EjOPS -------------------------------------------------------------------------------- Submitter: IBM Corporation SPEC license # 11 Test date: Sep-2012 -------------------------------------------------------------------------------- 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: 4 DB Instances: 1 Other SUT Components: -------------------------------------------------------------------------------- BENCHMARK SETTINGS -------------------------------------------------------------------------------- Dealer Injection Rate: 6,080 Ramp Up Time: 2,100 sec DB Load Injection Rate: 7,000 Steady State Time: 3,600 sec # of Dealer Agents: 60,800 Ramp Down Time: 300 sec # of Mfg Agents: 18,240 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Dealer Transaction Mix Count Tx. Mix Failure Count Purchase 5,499,648 24.99% 2 Manage 5,503,819 25.01% 1 Browse 11,003,121 50.00% 0 Total # Dealer Transactions22,006,588 Mfg. Transaction Mix Count Tx. Mix Failure Count CreateVehicleEJB 6,450,362 50.00% 756 CreateVehicleWS 6,450,196 50.00% 886 Total # Mfg. Transactions12,900,558 Response Times Average Standard Deviation Maximum 90th% Reqd Purchase 0.158 0.45 8.473 0.250 2.000 Manage 0.127 0.23 10.787 0.260 2.000 Browse 0.188 0.51 5.842 0.290 2.000 CreateVehicleEJB 0.072 0.09 3.690 0.150 5.000 CreateVehicleWS 0.181 0.29 12.332 0.300 5.000 Reproducibility Run (SPECjEnterprise2010 EjOPS) 9,698.47 -------------------------------------------------------------------------------- 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: Novell SUSE Linux Enterprise Server 11 SP2 -------------------------------------------------------------------------------- IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux x86-64) Vendor: IBM Corporation Availability Date: Dec-2012 OS Name: Novell SUSE Linux Enterprise Server 11 SP2 -------------------------------------------------------------------------------- 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.63.123) Vendor: IBM Corporation Availability Date: Apr-2012 OS Name: Novell SUSE Linux Enterprise Server 11 SP2 -------------------------------------------------------------------------------- DB2 10.1 Vendor: IBM Corporation Availability Date: Apr-2012 OS Name: Novell SUSE Linux Enterprise Server 11 SP2 -------------------------------------------------------------------------------- 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 x86-64) 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: 4 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: -Xms3072m -Xmx3072m -Xmo1078m -Xnoloa -Xgcthreads4 -Xss128k -Xgcpolicy:gencon -Xdisableexplicitgc -Xshareclasses:none -Xaggressive -Xtrace:none -Xlp -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 -Dcom.ibm.websphere.webservices.http.connectionKeepAlive=true -Dcom.ibm.websphere.webservices.http.maxConnection=50 -Dcom.ibm.websphere.webservices.http.connectionIdleTimeout=600 -Dcom.ibm.websphere.webservices.http.connectionTimeout=0 -Xcompressedrefs -Xconcurrentlevel0 -DAIODisableTimeouts=true -DdisableWSAddressCaching=true -Dclient.encoding.override=ISO-8859-1 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 PM71704 PM71833 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.6.0 IBM J9 Linux x86-32) Hardware: Load Driver & Emulator HW # of Instances: 4 Notes / Tuning Information JVM Parameters: -Xms2048m -Xmx2048m -Xmo500m -Xmn1548m -Xgcpolicy:gencon -Xnoloa -Xgcthreads4 -Xdisableexplicitgc -Xss128k -Xtrace:none -Djava.net.preferIPv4Stack=true -Dsun.net.inetaddr.ttl=0 -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 -Dcom.ibm.websphere.naming.hostname.normalizer=...none... -DdisableWSAddressCaching=true -Dcom.ibm.websphere.webservices.http.connectionKeepAlive=true -Dcom.ibm.websphere.webservices.http.maxConnection=50 -Dcom.ibm.websphere.webservices.http.connectionIdleTimeout=600 -Dcom.ibm.websphere.webservices.http.connectionTimeout=0 Refer to files emulator/server.xml for all server configuration and resource configuration information -------------------------------------------------------------------------------- Database Software Config DB Product: DB2 10.1 Hardware: Database Server HW # of Instances: 1 Character Set: UTF-8 Notes / Tuning Information DB2_COLLECT_TS_REC_INFO=FALSE DB2_APM_PERFORMANCE=ON DB2_KEEPTABLELOCK=CONNECTION DB2_USE_ALTERNATE_PAGE_CLEANING=ON DB2_MINIMIZE_LISTPREFETCH=YES DB2_RESOURCE_POLICY=/home/db2inst3/scripts/ir6k/affinity.txt DIAGLEVEL 3 DFT_MON_BUFPOOL off DFT_MON_LOCK off DFT_MON_SORT off DFT_MON_STMT off DFT_MON_TIMESTAMP off DFT_MON_UOW off DFT_MON_TABLE off MAX_COORDAGENTS 350 automatic CPUSPEED -1 HEALTH_MON off SELF_TUNING_MEM off LOGBUFSZ 4096 LOGSECOND 0 LOGPRIMARY 256 SOFTMAX 8080 CHNGPGS_THRESH 99 LOGFILSIZ 65535 NUM_IOCLEANERS 16 AUTO_MAINT off AUTO_RUNSTATS off AUTO_TBL_MAINT off 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 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 DB2COMM=TCPIP IBMDEFAULTBP immediate size 12000000 SPEC_BP immediate size 2000 JMS_BP immediate size 4000 M_INV_BP immediate size 500000 M_PARTS_BP immediate size 120000 M_BOM_BP immediate size 60000 M_WO_BP immediate size 20000 M_WO2_BP immediate size 2000 M_OL_BP immediate size 2000 O_O_BP immediate size 140000 O_O2_BP immediate size 60000 O_OL_BP immediate size 100000 O_CI_BP immediate size 400000 O_C_BP immediate size 200000 O_ITEM_BP immediate size 2000 O_ITEM2_BP immediate size 2000 S_C_BP immediate size 200000 S_S_C_BP immediate size 400000 S_S_BP immediate size 2000 S_P_O_BP immediate size 2000 S_P_O2_BP immediate size 2000 S_P_OL_BP immediate size 3000 O_ORDERS_BP immediate size 60000 O_CUSTOMER_BP immediate size 90000 S_COMPONENT_BP immediate size 90000 INDEX_BP immediate size 200000 DATA_BP immediate size 140000 -------------------------------------------------------------------------------- Driver Config JVM Product: IBM J9 VM (build 2.6, JRE 1.6.0 IBM J9 Linux x86-32) Hardware: Load Driver & Emulator HW # of Instances: 4 Notes / Tuning Information JVM Parameters: -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 -Dcom.ibm.websphere.webservices.http.connectionKeepAlive=true -Dcom.ibm.websphere.webservices.http.maxConnection=810 -Dcom.ibm.websphere.webservices.http.connectionIdleTimeout=600 -Dcom.ibm.websphere.webservices.http.connectionTimeout=0 -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- JEE AppServer HW (SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM System x3650 M4 Processor: Intel Xeon processor E5-2690 (Intel Turbo Boost Technology up to 3.8 GHz) MHz: 2900 # of CPUs: 16 cores, 2 chips, 8 cores/chip (16 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: 20 MB I+D on chip per chip OS Vendor: Novell OS Name: Novell SUSE Linux Enterprise Server 11 SP2 Disks: 2x146GB 15K SAS Network Interface: 6x 10GBit and 1x 1GBit network ports Other Hardware: # of Systems: 1 H/W Available: Mar-2012 O/S Available: Feb-2012 Notes / Tuning Information 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 kernel.nmi_watchdog = 0 net.core.netdev_max_backlog = 250000 net.core.optmem_max = 16777216 net.core.rmem_default = 16777216 net.core.rmem_max = 16777216 net.core.somaxconn = 32767 net.core.wmem_default = 16777216 net.core.wmem_max = 16777216 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_low_latency = 1 net.ipv4.tcp_max_syn_backlog = 30000 net.ipv4.tcp_max_tw_buckets = 2000000 net.ipv4.tcp_mem = 16777216 16777216 16777216 net.ipv4.tcp_no_metrics_save = 1 net.ipv4.tcp_rmem = 4096 87380 16777216 net.ipv4.tcp_sack = 0 net.ipv4.tcp_timestamps = 0 net.ipv4.tcp_window_scaling = 1 net.ipv4.tcp_wmem = 4096 65536 16777216 default_hugepagesz=1G hugepagesz=1G hugepages=64 Network Tuning: set txqueuelen 60000 Stop irqbalance. Network interrupts bound to cores corresponding to the server instances. Set number of network queues to 4 for database ports and 2 for all other 10 Gigabit ports. On each interface used for driver and emulator communication set: arp_ignore 1 arp_announce 2 rx-usecs 1000 On the interfaces used for database communication set: arp_ignore 1 arp_announce 2 rx-usecs 500 Server instances were started using taskset, binding 2 instances per chip. -------------------------------------------------------------------------------- Database Server HW (SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM System x3650 M4 Processor: Intel Xeon processor E5-2690 (Intel Turbo Boost Technology up to 3.8 GHz) MHz: 2900 # of CPUs: 16 cores, 2 chips, 8 cores/chip (16 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: 20 MB I+D on chip per chip OS Vendor: Novell OS Name: Novell SUSE Linux Enterprise Server 11 SP2 Disks: 2x1TB 7.2K 6Gbps Network Interface: 2x 10GBit and 1x 1GBit network ports Other Hardware: 2x IBM 1.2TB High IOPS MLC Mono Adapter # of Systems: 1 H/W Available: Mar-2012 O/S Available: Jun-2010 Notes / Tuning Information fs.file-max = 6815744 kernel.sem = 250 32000 100 142 kernel.shmall = 10737418240 kernel.shmmax = 4398046511104 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 = 40000 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 ulimit -n 1048576 Network Tuning: set txqueuelen 60000 -------------------------------------------------------------------------------- Load Driver & Emulator HW (non-SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM BladeCenter HS22 Processor: Xeon X5670 MHz: 2933 # of CPUs: 12 cores, 2 chips, 6 cores/chip Memory (MB): 49152 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: 2 x 146GB 15K SAS Network Interface: 1x 10GBit and 1x 1GBit network ports Other Hardware: # of Systems: 5 H/W Available: Mar-2010 O/S Available: Jun-2010 Notes / Tuning Information fs.file-max = 1048576 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 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, RAID 1 was used on a pair of IBM 1.2TB High IOPS MLC Mono Adapters for the database data and logs. -------------------------------------------------------------------------------- Storage Requirement Info: Over the course of a 100 minute run at an injection rate of 6080, the database storage increased by 16.5 GB Given a linear scale, a 24 hour run at the same injection rate would increase storage by 241 GB. The database was configured with over 900 GB of mirrored storage. BILL OF MATERIALS -------------------------------------------------------------------------------- Supplier Description Product # Qty -------- ------------------------------------------- ---------------- --- IBM IBM System x3650 M4 7915AC1 1 IBM Intel Xeon Processor E5-2690 8C - (2.90GHz 20MB L3 Cache 1600MHz 135W) A2VN 1 IBM Addl Intel Xeon Processor E5-2690 8C 2.9GHz W/Fan A2QL 1 IBM 8GB PC3-12800 CL11 ECC DDR3 1600MHz LP RDIMM A292 16 IBM 146GB 15K 6Gbps SAS 2.5 A2XB 2 IBM PCIe Gen-III Riser Card 1 - (1 x8 FH/FL + 2 x8 FH/HL Slots) A1JT 1 IBM PCIe Gen-III Riser Card 2 - (1 x8 FH/FL + 2 x8 FH/HL Slots) A1JU 1 IBM IBM System x3650 M4 2.5 Base without Power Supply A1KF 1 IBM 900W High Efficiency Platinum AC Power Supply A2EB 1 IBM 10 GbE Adapter for IBM System x A2EC 4 IBM 10 GbE Fiber SFP+ Transceiver 0069 6 IBM 3 Year Onsite Repair 24x7 4 Hour Response 6756025 IBM SUSE Linux Enterprise Server w/ 3yr support 5639S1X 1 ... IBM IBM System x3650 M4 7915AC1 1 IBM Intel Xeon Processor E5-2690 8C - (2.90GHz 20MB L3 Cache 1600MHz 135W) A2VN 1 IBM Addl Intel Xeon Processor E5-2690 8C 2.9GHz W/Fan A2QL 1 IBM 8GB PC3-12800 CL11 ECC DDR3 1600MHz LP RDIMM A292 16 IBM IBM 1TB 7.2K 6Gbps NL SAS 2.5 SFF HS HDD A1P3 2 IBM PCIe Gen-III Riser Card 1 - (1 x8 FH/FL + 2 x8 FH/HL Slots) A1JT 1 IBM PCIe Gen-III Riser Card 2 - (1 x8 FH/FL + 2 x8 FH/HL Slots) A1JU 1 IBM IBM System x3650 M4 2.5 Base without Power Supply A1KF 1 IBM 900W High Efficiency Platinum AC Power Supply A2EB 1 IBM IBM 1.2TB High IOPS MLC Mono Adapter A3DY 2 IBM 10 GbE Adapter for IBM System x A1M4 1 IBM 10 GbE Fiber SFP+ Transceiver 0069 2 IBM 3 Year Onsite Repair 24x7 4 Hour Response 84Y2233 IBM SUSE Linux Enterprise Server w/ 3yr support 48153RU 1 ... 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 Intel core is 70 PVU. -------------------------------------------------------------------------------- OTHER BENCHMARK INFORMATION -------------------------------------------------------------------------------- DNS round robin load balancing was used and hosted on the database machine Load balancing network connectivity was 1Gbps all other connections were 10Gbps -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- 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 UDB Server changes a database table with an update, insert, or delete operation, the change is initially made in memory, not on disk. When there is not enough space in the memory buffer to read in or write additional data pages, DB2 UDB Server will make space by flushing some modified pages to disk. Modified pages are also written to disk as part of the "Soft" checkpoint to ensure that no updates remain unflushed for longer than the allowed time. Before a change is made to the database, it is first recorded in the transaction log. This ensures that the database can be recovered completely in the event of a failure. Using the transaction log, transactions that started but did not complete prior to a failure can be undone, and transactions recorded as complete in the transaction log but not yet written to disk can be redone. DB2 UDB uses a write-ahead-logging protocol to guarantee recovery. This protocol uses "Soft" checkpoint to write least-recently-used database pages to disk independent of transaction commit. However, enough log information to redo/undo the change to a database pages is committed to disk before the database page itself is written. This protocol therefore renders checkpoint unnecessary for DB2 UDB. For a more detailed description of the general principles of the write-ahead-logging protocol, see the IBM research paper, ARIES: A Transaction Recovery Method Supporting Fine Granularity Locking and Partial Rollbacks Using Write-Ahead Logging," by C. Mohan, Database Technology Institute, IBM Almaden Research Center. (http:// portal.acm.org/citation.cfm ?id=128770&coll=portal&dl=ACM&CFID=10343790&CFTOKEN=42047146) -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: IBM Corporation For other inquiries, please contact SPEC - Benchmark run on Wed Sep 26 15:58:44 CDT 2012 by SPECjEnterprise2010 v1.03 - Result submitted on null - Report generated by SPECjEnterprise2010 Reporter v1.00 Copyright (C) 2009-2012 Standard Performance Evaluation Corporation