-------------------------------------------------------------------------------- SPECjEnterprise(R)2010 Result Copyright (C) 2009-2015 Standard Performance Evaluation Corporation -------------------------------------------------------------------------------- WebSphere Application Server V8.5.5.4 on IBM System x3650 M5 and DB2 10.5 on IBM System x3850 X6 -------------------------------------------------------------------------------- 19,282.14 SPECjEnterprise2010 EjOPS -------------------------------------------------------------------------------- Submitter: IBM Corporation SPEC license # 11 Test date: Jan-2015 -------------------------------------------------------------------------------- SUT CONFIGURATION -------------------------------------------------------------------------------- JEE Server Nodes: 1 DB Server Nodes: 1 JEE Server CPUs: 28 cores, 2 chips DB Server CPUs: 60 cores, 4 chips JEE Instances: 4 DB Instances: 1 Other SUT Components: -------------------------------------------------------------------------------- BENCHMARK SETTINGS -------------------------------------------------------------------------------- Dealer Injection Rate: 12,095 Ramp Up Time: 1,200 sec DB Load Injection Rate: 12,095 Steady State Time: 3,600 sec # of Dealer Agents: 120,950 Ramp Down Time: 300 sec # of Mfg Agents: 36,285 -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Dealer Transaction Mix Count Tx. Mix Failure Count Purchase 10,923,709 24.99% 5 Manage 10,934,939 25.01% 3 Browse 21,858,367 50.00% 0 Total # Dealer Transactions43,717,015 Mfg. Transaction Mix Count Tx. Mix Failure Count CreateVehicleEJB 12,852,542 50.01% 1,034 CreateVehicleWS 12,846,136 49.99% 1,112 Total # Mfg. Transactions25,698,678 Response Times Average Standard Deviation Maximum 90th% Reqd Purchase 0.421 0.67 6.840 1.310 2.000 Manage 0.217 0.32 8.758 0.590 2.000 Browse 0.534 0.73 4.816 1.700 2.000 CreateVehicleEJB 0.055 0.08 2.530 0.100 5.000 CreateVehicleWS 0.159 0.25 6.935 0.250 5.000 Reproducibility Run (SPECjEnterprise2010 EjOPS) 19,307.31 -------------------------------------------------------------------------------- SOFTWARE PRODUCTS -------------------------------------------------------------------------------- WebSphere Application Server V8.5.5.4 Vendor: IBM Corporation Availability Date: Dec-2014 Date Passed CTS: May-2012 CTS Version: 6.0 EJB Protocol: RMI/IIOP OS Name: SUSE Linux Enterprise Server 11 SP3 -------------------------------------------------------------------------------- IBM SDK, Java Technology Edition, Version 7 Release 1, Service Refresh 2 Vendor: IBM Corporation Availability Date: Nov-2014 OS Name: SUSE Linux Enterprise Server 11 SP3 -------------------------------------------------------------------------------- IBM SDK, Java Technology Edition, Version 7 Release 1, Service Refresh 2 Vendor: IBM Corporation Availability Date: Nov-2014 OS Name: SUSE Linux Enterprise Server 11 SP3 -------------------------------------------------------------------------------- IBM DB2 Universal JDBC Drivers (4.19.26) Vendor: IBM Corporation Availability Date: Nov-2014 OS Name: SUSE Linux Enterprise Server 11 SP3 -------------------------------------------------------------------------------- DB2 10.5 FP5 Vendor: IBM Corporation Availability Date: Nov-2014 OS Name: SUSE Linux Enterprise Server 11 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.4 JVM Product: IBM SDK, Java Technology Edition, Version 7 Release 1, Service Refresh 2 JDBC Product: IBM DB2 Universal JDBC Drivers (4.19.26) 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 Java Version: IBM J9 VM (build 2.7, JRE 1.7.0 Linux amd64-64 Compressed References 20141114_222539 (JIT enabled, AOT enabled) JVM Parameters: -Xms3072m -Xmx3072m -Xmo1024m -Xaggressive -Xshareclasses:none -Xss128k -Xgcthreads14 -Xdisableexplicitgc -Xtrace:none -Xlp -Xcompressedrefs -Xconcurrentlevel0 Refer to files appservers/node.resources.xml, and appservers/server.xml for all server configuration and resource configuration information 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.4 JVM Product: IBM SDK, Java Technology Edition, Version 7 Release 1, Service Refresh 2 Hardware: Load Driver & Emulator HW # of Instances: 4 Notes / Tuning Information Java Version: IBM J9 VM (build 2.7, JRE 1.7.0 Linux x86-32 20141114_222539 (JIT enabled, AOT enabled) JVM Parameters: -Xms2048m -Xmx2048m -Xmo500m -Xmn1548m -Xss128k -Xnoloa -Xmo500m -Xgcthreads4 -Xdisableexplicitgc -Xtrace:none Refer to files emulator/server.xml for all server configuration and resource configuration information -------------------------------------------------------------------------------- Database Software Config DB Product: DB2 10.5 FP5 Hardware: Database Server HW # of Instances: 1 Character Set: UTF-8 Notes / Tuning Information DB2 Registry Variables: 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 DB2AUTOSTART=NO Database Manager Configuration: DIAGLEVEL = 3 DFT_MON_BUFPOOL = ON DFT_MON_LOCK = OFF DFT_MON_SORT = OFF DFT_MON_STMT = OFF DFT_MON_TABLE = OFF DFT_MON_TIMESTAMP = ON DFT_MON_UOW = OFF HEALTH_MON = OFF SHEAPTHRES = 2000000 MAX_COORDAGENTS = AUTOMATIC(3000) SPM_MAX_RESYNC = 20 Database Configuration: SELF_TUNING_MEM = OFF SHEAPTHRES_SHR = 183205 SORTHEAP = 50000 LOCKLIST = 200000 MAXLOCKS = 100 LOGBUFSZ = 4096 UTIL_HEAP_SZ = 5000 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 = 65535 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. Set LD_PRELOAD=/usr/lib64/rsocket/librspreload.so for db2start Prepend /usr/lib64/rsocket to LD_LIBRARY_PATH Full details of the database configuration information and ddl files are located in the schema directory of the FDA. -------------------------------------------------------------------------------- Driver Config JVM Product: IBM SDK, Java Technology Edition, Version 7 Release 1, Service Refresh 2 Hardware: Load Driver & Emulator HW # of Instances: 4 Notes / Tuning Information Java Version: IBM J9 VM (build 2.7, JRE 1.7.0 Linux x86-32 20141114_222539 (JIT enabled, AOT enabled) 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 -Dhttp.keepAliveCache.lifeTime=600000 -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- JEE AppServer HW (SUT hardware) Hardware Vendor: Lenovo Group Ltd. Model Name: IBM System x3650 M5 Processor: Intel Xeon processor E5-2697 v3 (Intel Turbo Boost Technology up to 3.6 GHz) MHz: 2600 # of CPUs: 28 cores, 2 chips, 14 cores/chip (56 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: 35 MB I+D on chip per chip OS Vendor: Micro Focus International plc OS Name: SUSE Linux Enterprise Server 11 SP3 Disks: 2x500GB 7.2K SATA Network Interface: 6x 10GBit and 1x 1GBit network ports Other Hardware: # of Systems: 1 H/W Available: Dec-2014 O/S Available: Jul-2013 Notes / Tuning Information BIOS Settings: Processors.CODPreference=Enable Processors.EarlySnoopPreference=Disable Power.PlatformControlledType=Maximum Performance /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 = 16777216 net.core.rmem_default = 16777216 net.core.rmem_max = 16777216 net.core.somaxconn = 40000 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_ecn = 0 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 = 40000 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_syncookies = 1 net.ipv4.tcp_timestamps = 0 net.ipv4.tcp_window_scaling = 1 net.ipv4.tcp_wmem = 4096 65536 16777216 ulimit -n 1048576 -c unlimited -v unlimited default_hugepagesz=1G hugepagesz=1G hugepages=128 echo NO_FAIR_SLEEPERS > /sys/kernel/debug/sched_features Network Tuning: set txqueuelen 60000 Stop irqbalance. Network interrupts bound to cores corresponding to the server instances. On each interface used for driver and emulator communication set: arp_ignore 1 arp_announce 2 rx-usecs 600 4 queues On the interfaces used for database communication set: arp_ignore 1 arp_announce 2 rx-usecs 64 adaptive-rx off rx-frames 128 tx-usecs 128 tx-frames 64 4 queues Server instances were started using taskset, binding 1 instance per NUMA node. -------------------------------------------------------------------------------- Database Server HW (SUT hardware) Hardware Vendor: Lenovo Group Ltd. Model Name: IBM System x3850 X6 Processor: Intel Xeon processor E7-4890 v2 (Intel Turbo Boost Technology up to 3.4 GHz) MHz: 2800 # of CPUs: 60 cores, 4 chips, 15 cores/chip (120 HW threads/chip) Memory (MB): 1048576 DIMM[0] Count: 64 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: 37.5 MB I+D on chip per chip OS Vendor: Micro Focus International plc OS Name: SUSE Linux Enterprise Server 11 SP3 Disks: 2x 128GB SSD, 2x 1.2TB SSD Network Interface: 4x 10GBit and 1x 1GBit network ports Other Hardware: # of Systems: 1 H/W Available: Mar-2014 O/S Available: Jul-2013 Notes / Tuning Information /etc/sysctl.conf: fs.aio-max-nr = 1048576 fs.file-max = 6815744 fs.inotify.max_user_watches = 65536 kernel.sem = 250 256000 100 129280 kernel.shmall = 10737418240 net.core.netdev_max_backlog = 400000 net.core.optmem_max = 30000000 net.core.rmem_default = 30000000 net.core.rmem_max = 30000000 net.core.somaxconn = 40000 net.core.wmem_default = 30000000 net.core.wmem_max = 30000000 net.ipv4.conf.all.promote_secondaries = 1 net.ipv4.conf.all.rp_filter = 1 net.ipv4.conf.default.promote_secondaries = 1 net.ipv4.icmp_echo_ignore_broadcasts = 1 net.ipv4.ip_local_port_range = 1024 65535 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_timestamps = 0 net.ipv4.tcp_wmem = 30000000 30000000 30000000 vm.zone_reclaim_mode = 1 /etc/rdma/rsocket/inline_default: 512 /etc/rdma/rsocket/mem_default: 4194304 /etc/rdma/rsocket/wmem_default: 4194304 /etc/rdma/rsocket/preload_config: db2sysc INET STREAM TCP ulimit -n 1048576 Network Tuning: Network interrupts bound to cores corresponding to the cards physical location. 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: Micro Focus International plc OS Name: SUSE Linux Enterprise Server 11 SP3 Disks: 2x 146GB 15K SAS Network Interface: 1x 10GBit and 1x 1GBit network ports Other Hardware: # of Systems: 9 H/W Available: Mar-2010 O/S Available: Jul-2013 Notes / Tuning Information /etc/sysctl.conf: fs.file-max = 1048576 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.default.accept_source_route = 0 net.ipv4.conf.default.rp_filter = 1 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_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 2 mirrored internal 1.2TB SSD drives configured in RAID 1. -------------------------------------------------------------------------------- Storage Requirement Info: Over the course of a 85 minute run at an injection rate of 12095, the database storage increased by 16.7 GB Given a linear scale, a 24 hour run at the same injection rate would increase storage by 282.9 GB. The database was configured with over 1058 GB of mirrored storage. BILL OF MATERIALS -------------------------------------------------------------------------------- Supplier Description Product # Qty -------- ------------------------------------------- ---------------- --- Application Server: Lenovo IBM System x3650 M5 5462AC1 1 Lenovo Intel Xeon Processor E5-2697 v3 14C - (2.60GHz 35MB L3 Cache 2133MHz 145W) ASDE 1 Lenovo Addl Intel Xeon Processor E5-2697 v3 14C - (2.60GHz 35MB L3 Cache 2133MHz 145W) ASDR 1 Lenovo 16GB TruDDR4 (2Rx4, 1.2V) PC4-179 CL15 - 2133MHz LP RDIMM A5B7 16 Lenovo x3650 M5 8x 2.5" HS HDD Assembly Kit (Single RAID) A5G6 1 Lenovo ServeRAID M5210 SAS/SATA Controller - for Lenovo System x A3YZ 1 Lenovo Lenovo 500GB 7.2K 6Gbps NL SATA 2.5" G3HS HDD A4TW 2 Lenovo System x3650 M5 PCIe Riser 1 - (2 x8 FH/FL + 1 x8 FH/HL Slots) A5FP 1 Lenovo System x3650 M5 PCIe Riser 2 - (2 x8 FH/FL + 1 x8 FH/HL Slots) A5R6 1 Lenovo IBM System x3650 M5 2.5" Base without Power Supply A5FD 1 Lenovo System x 900W High Efficiency Platinum - AC Power Supply A5EW 1 Lenovo Intel x520 Dual Port 10GbE SFP+ Adapter - for Lenovo System x A2EC 2 Lenovo Mellanox ConnectX-3 10 GbE Adapter - for Lenovo System x A3PM 4 Lenovo 10 GbE Fiber SFP+ Transceiver 0064 6 Lenovo 3 Year Onsite Repair 24x7 4 Hour Response 67568HG 1 Lenovo SUSE Linux Enterprise Server w/ 3yr support 5639S1X 1 ... Database Server: Lenovo IBM System x3850 X6 3837AC1 1 Lenovo X6 Compute Book Intel Xeon Processor E7-4890 v2 - 15C 2.8GHz 155W A4AU 1 Lenovo X6 Compute Book Intel Xeon Processor E7-4890 v2 - 15C 2.8GHz 155W A4BA 3 Lenovo 16GB (1x16GB, 2Rx4, 1.35V) PC3L-12800 CL11 ECC DDR3 - 1600MHz LP RDIMM A3QM 64 Lenovo ServeRAID M5210 SAS/SATA Controller - for Lenovo System x A3YZ 1 Lenovo 2U bracket for low profile-internal-storage adapter A4C1 1 Lenovo x3850 ex6 I/O Planar A4A0 1 Lenovo Mellanox ConnectX-3 10 GbE Adapter - for Lenovo System x A3PM 4 Lenovo 3U Bracket for Mellanox ConnectX-3 10 GbE Adapter A3WG 4 Lenovo IBM HDD Filler ASM GEN 3 Quad Filler A4EL 1 Lenovo Lightpath LCD Op Panel A4VH 1 Lenovo X6 Half-length I/O Book A4A2 1 Lenovo 1.8" SAS Storage Support 6138 1 Lenovo 1.8" SSD drive bay A4A7 1 Lenovo IBM 120GB SATA 1.8" MLC Enterprise Value SSD A56V 2 Lenovo IBM 1.2TB High IOPS MLC Mono Adapter A3DY 2 Lenovo x3850 X6 4U Chassis A4BL 1 Lenovo IBM 1400W HE Redundant Power Supply - for altitudes >555 meters A54D 2 Lenovo QLogic 10Gb SFP+ SR Optical Transceiver 0064 8 Lenovo X6 Storage Book A4A1 1 Lenovo Midplane for 4U Chassis A4A4 1 Lenovo Intel I350-T4 ML2 Quad Port GbE Adapter - for IBM System x A40R 1 Lenovo 3 Year Onsite Repair 24x7 4 Hour Response 67568BU 1 Lenovo SUSE Linux Enterprise Server w/ 3yr support 5639S1X 1 ... Software: IBM DB2 Enterprise Server Edition v10.5.0.5 - Lic+SW Maint 12 Months D55IULL 60* IBM DB2 Enterprise Server Edition v10.5.0.5 - SW Maint Rewl 1 Anniv E020CLL 120 IBM WebSphere Application Server V8.5.5.4 - Lic+SW Maint 12 Months D55W8LL 28* IBM WebSphere Application Server V8.5.5.4 - SW Maint Rewl 1 Anniv E025QLL 56 IBM IBM Optim Purequery Runtime for LUW 3.1.1 - Lic+SW Maint 12 Months D61YKLL 28* IBM IBM Optim Purequery Runtime for LUW 3.1.1 - SW Maint Rewl 1 Anniv E048YLL 56 ... * Note: Pricing is based on Processor Value Units (PVU). - Each AppServer core is 70 PVU. Each Database core is 100 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 Database connectivity utilizes Java Sockets over Remote Direct Memory Access -------------------------------------------------------------------------------- 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 Fri Jan 16 12:10:14 CST 2015 by SPECjEnterprise2010 v1.03 - Result submitted on null - Report generated by SPECjEnterprise2010 Reporter v1.00 Copyright (C) 2009-2015 Standard Performance Evaluation Corporation