SPECjEnterprise®2010 Result Copyright © 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 |
|
Submitter: IBM Corporation |
SPEC license # 11 | Test date: Jan-2015 |
SUT Configuration | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||
|
Benchmark Settings | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Detailed Results | ||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
WebSphere Application Server V8.5.5.4 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
IBM SDK, Java Technology Edition, Version 7 Release 1, Service Refresh 2 | ||||||
---|---|---|---|---|---|---|
|
IBM SDK, Java Technology Edition, Version 7 Release 1, Service Refresh 2 | ||||||
---|---|---|---|---|---|---|
|
IBM DB2 Universal JDBC Drivers (4.19.26) | ||||||
---|---|---|---|---|---|---|
|
DB2 10.5 FP5 | ||||||
---|---|---|---|---|---|---|
|
IBM InfoSphere Optim pureQuery Runtime v3.1.1 | ||||||
---|---|---|---|---|---|---|
|
JEE Application Server | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||
|
Emulator Software Config | ||||||||
---|---|---|---|---|---|---|---|---|
|
||||||||
|
Database Software Config | ||||||||
---|---|---|---|---|---|---|---|---|
|
||||||||
|
Driver Config | ||||||
---|---|---|---|---|---|---|
|
||||||
|
JEE AppServer HW (SUT hardware) | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||
|
Database Server HW (SUT hardware) | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||||||
|
Load Driver & Emulator HW (non-SUT hardware) | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||||||||||||||||||
|
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 webmaster@spec.org
Copyright © 2009-2015 Standard Performance Evaluation Corporation
First published at SPEC.org on 18-Feb-2015