SPECjEnterprise2010 Result: WebSphere Application Server V8.5 on IBM System x3650 M4 and DB2 10.1 on IBM System x3650 M4

SPECjEnterprise®2010 Result
Copyright © 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

Software Products
WebSphere Application Server V8.5
IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux x86-64)
IBM J9 VM (build 2.6, JRE 1.6.0 IBM J9 Linux x86-32)
IBM DB2 Universal JDBC Drivers (3.63.123)
DB2 10.1
IBM InfoSphere Optim pureQuery Runtime v3.1.1

Software Configurations
JEE Application Server
Emulator Software Config
Database Software Config
Driver Config

Hardware Systems
JEE AppServer HW
Database Server HW
Load Driver & Emulator HW

System Configuration Diagram

Benchmark
Modifications
Configuration
Bill of Materials
Other Info
General Notes
Full Disclosure Archive

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 seconds
DB Load Injection Rate:	7,000	Steady State Time:	3,600 seconds
# of Dealer Agents:	60,800	Ramp Down Time:	300 seconds
# of Manufacturing 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 Transactions	22,006,588

Manufacturing Transaction Mix	Count	Tx. Mix	Failure Count
CreateVehicleEJB	6,450,362	50.00%	756
CreateVehicleWS	6,450,196	50.00%	886
Total # Manufacturing Transactions	12,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

WebSphere Application Server V8.5

Vendor:	IBM Corporation	Availability:	Dec-2012
CTS Version:	6.0	Date Passed CTS:	May-2012
OS Name:	Novell SUSE Linux Enterprise Server 11 SP2
EJB Protocol:	RMI/IIOP

IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux x86-64)

Vendor:	IBM Corporation	Availability:	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:	Jun-2011
OS Name:	Novell SUSE Linux Enterprise Server 11 SP1

IBM DB2 Universal JDBC Drivers (3.63.123)

Vendor:	IBM Corporation	Availability:	Apr-2012
OS Name:	Novell SUSE Linux Enterprise Server 11 SP2

DB2 10.1

Vendor:	IBM Corporation	Availability:	Apr-2012
OS Name:	Novell SUSE Linux Enterprise Server 11 SP2

IBM InfoSphere Optim pureQuery Runtime v3.1.1

Vendor:	IBM	Availability:	May-2012
Description:	IBM InfoSphere Optim pureQuery Runtime for Linux, UNIX, and Windows Version 3.1.1

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

JEE AppServer HW (SUT hardware)

Hardware Vendor:	IBM Corporation	OS Vendor:	Novell
Model Name:	IBM System x3650 M4	OS Name:	Novell SUSE Linux Enterprise Server 11 SP2
Processor:	Intel Xeon processor E5-2690 (Intel Turbo Boost Technology up to 3.8 GHz)	Filesystem:	ext3
MHz:	2900	Disks:	2x146GB 15K SAS
# of CPUs:	16 cores, 2 chips, 8 cores/chip (16 HW threads/chip)	Network Interface:	6x 10GBit and 1x 1GBit network ports
Memory (MB):	131072	Other Hardware:
DIMM[0] Count:	16	DIMM[0] Size:	8192
L1 Cache:	32 KB I + 32 KB D on chip per core	# of Systems:	1
L2 Cache:	256 KB I+D on chip per core	H/W Available:	Mar-2012
Other Cache:	20 MB I+D on chip per chip	OS 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	OS Vendor:	Novell
Model Name:	IBM System x3650 M4	OS Name:	Novell SUSE Linux Enterprise Server 11 SP2
Processor:	Intel Xeon processor E5-2690 (Intel Turbo Boost Technology up to 3.8 GHz)	Filesystem:	ext3
MHz:	2900	Disks:	2x1TB 7.2K 6Gbps
# of CPUs:	16 cores, 2 chips, 8 cores/chip (16 HW threads/chip)	Network Interface:	2x 10GBit and 1x 1GBit network ports
Memory (MB):	131072	Other Hardware:	2x IBM 1.2TB High IOPS MLC Mono Adapter
DIMM[0] Count:	16	DIMM[0] Size:	8192
L1 Cache:	32 KB I + 32 KB D on chip per core	# of Systems:	1
L2 Cache:	256 KB I+D on chip per core	H/W Available:	Mar-2012
Other Cache:	20 MB I+D on chip per chip	OS 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	OS Vendor:	Novell
Model Name:	IBM BladeCenter HS22	OS Name:	Novell SUSE Linux Enterprise Server 11 SP1
Processor:	Xeon X5670	Filesystem:	ext3
MHz:	2933	Disks:	2 x 146GB 15K SAS
# of CPUs:	12 cores, 2 chips, 6 cores/chip	Network Interface:	1x 10GBit and 1x 1GBit network ports
Memory (MB):	49152	Other Hardware:
L1 Cache:	32KB(I)+32KB(D)	# of Systems:	5
L2 Cache:	256 I+D on chip per core	H/W Available:	Mar-2010
Other Cache:	12 MB I+D on chip per chip	OS 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 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.

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 webmaster@spec.org

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

First published at SPEC.org on 14-Nov-2012