SPEC Seal of Reviewal SPECjEnterprise®2010 Result
Copyright © 2009-2013 Standard Performance Evaluation Corporation
WebSphere Application Server V8.5.5 and DB2 10.1 on IBM PowerLinux 7R2
13,161.07 SPECjEnterprise2010 EjOPS
Submitter:
IBM Corporation
SPEC license # 11 Test date:
Apr-2013
Software Products
WebSphere Application Server V8.5.5
WebSphere Application Server V8.5
IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux ppc-32)
IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux x86-64)
IBM DB2 Universal JDBC Drivers (3.63.123)
DB2 10.1 FP2
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: 8   DB Instances: 1
Other SUT Components:
   

Benchmark Settings
Dealer Injection Rate: 8,250   Ramp Up Time: 2,400 seconds
DB Load Injection Rate: 9,000   Steady State Time: 3,600 seconds
# of Dealer Agents: 82,500   Ramp Down Time: 300 seconds
# of Manufacturing Agents: 24,750  

Detailed Results
Dealer Transaction Mix Count Tx. Mix Failure Count
Purchase 7,457,464 25.00% 5
Manage 7,454,724 24.99% 7
Browse 14,918,556 50.01% 0
Total # Dealer Transactions 29,830,744
Manufacturing Transaction Mix Count Tx. Mix Failure Count
CreateVehicleEJB 8,776,797 50.01% 1,313
CreateVehicleWS 8,772,321 49.99% 2,938
Total # Manufacturing Transactions 17,549,118
Response Times Average Standard Deviation Maximum 90th% Reqd
Purchase 0.319 0.65 8.406 1.030 2.000
Manage 0.213 0.32 11.670 0.550 2.000
Browse 0.388 0.72 5.750 1.580 2.000
CreateVehicleEJB 0.068 0.05 2.799 0.150 5.000
CreateVehicleWS 0.090 0.06 8.850 0.175 5.000
Reproducibility Run (SPECjEnterprise2010 EjOPS) 13,168.82

WebSphere Application Server V8.5.5
Vendor: IBM Corporation Availability: Jul-2013
CTS Version: 6.0 Date Passed CTS: May-2012
OS Name: Red Hat Enterprise Linux Server release 6.4
EJB Protocol: RMI/IIOP

WebSphere Application Server V8.5
Vendor: IBM Corporation Availability: Dec-2012
CTS Version: 6.0 Date Passed CTS: May-2012
OS Name: Red Hat Enterprise Linux Server release 6.4
EJB Protocol: RMI/IIOP

IBM J9 VM (build 2.6, JRE 1.7.0 IBM J9 Linux ppc-32)
Vendor: IBM Corporation Availability: Jul-2013
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: Dec-2012
OS Name: Red Hat Enterprise Linux Server release 6.4

IBM DB2 Universal JDBC Drivers (3.63.123)
Vendor: IBM Corporation Availability: Apr-2012
OS Name: Red Hat Enterprise Linux Server release 6.4

DB2 10.1 FP2
Vendor: IBM Corporation Availability: Dec-2012
OS Name: Red Hat Enterprise Linux Server release 6.4

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.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 -Xmn1624m -Xgcthreads8 -Xss128k
-Xnoloa -Xdisableexplicitgc -Xshareclasses:none
-Xtrace:none -Xlp -Xaggressive -XtlhPrefetch -Xcodecache14m
-Xnodfpbd -Xnocompactgc -Xnoclassgc -Xconcurrentlevel0

Refer to files appservers/node.resources.xml, and appservers/server.xml
for all server configuration and resource configuration information

WebSphere Application Server APAR Fixes PM85812 PM86095
InfoSphere Optim pureQuery Runtime is used by WebSphere Applicatioin Server for efficient statement batching

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

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


JEE AppServer HW (SUT hardware)
Hardware Vendor: IBM Corporation OS Vendor: Red Hat
Model Name: IBM PowerLinux 7R2 OS Name: Red Hat Enterprise Linux Server release 6.4
Processor: POWER7+ (Intelligent Energy Optimization enabled up to 4.540 GHz) Filesystem: ext3
MHz: 4228 Disks: 2x600GB 10K SAS
# of CPUs: 16 cores, 2 chips, 8 cores/chip (32 HW threads/chip) Network Interface: 4x 10GBit and 4x 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: Feb-2013
Other Cache: 10 MB I+D on chip per core OS 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 wakeup preempt scheduler feature
  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 OS Vendor: Red Hat
Model Name: PowerLinux 7R2 OS Name: Red Hat Enterprise Linux Server release 6.4
Processor: POWER7+ (Intelligent Energy Optimization enabled up to 4.540 GHz) Filesystem: ext4
MHz: 4228 Disks: 1x600GB 10K SAS, 4x387GB SFF-1 eMLC SSD
# of CPUs: 16 cores, 2 chips, 8 cores/chip (32 HW threads/chip) Network Interface: 5x 1GBit network ports
Memory (MB): 262144 Other Hardware:
DIMM[0] Count: 16 DIMM[0] Size: 16384
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: Feb-2013
Other Cache: 10 MB I+D on chip per core OS 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

The iprconfig utility was used to disable the storage adapter cache.
Set the no wakeup preempt scheduler feature
  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 OS Vendor: Red Hat
Model Name: IBM Flex System x240 OS Name: Red Hat Enterprise Linux Server release 6.4
Processor: Xeon E5-2680 Filesystem: ext4
MHz: 2700 Disks: 1x600GB 10K SAS
# of CPUs: 16 cores, 2 chips, 8 cores/chip Network Interface: 2x 10GBit network ports
Memory (MB): 65536 Other Hardware:
L1 Cache: 32KB(I)+32KB(D) # of Systems: 5
L2 Cache: 256 I+D on chip per core H/W Available: May-2012
Other Cache: 20 MB I+D on chip per chip OS 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, the database and the database logs were each maintained on 2 mirrored internal 387GB SSD drives configured in RAID 1.
Storage Requirement Info:
  Over the course of a 105 minute run at an injection rate of
     8250, the database storage for database system increased by 12.56 GB.
     Given a linear scale, a 24 hour run at the same
     injection rate would increase storage for database system by 172.251 GB.
     The database was configured with 387 GB of mirrored 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               1
IBM           387GB SFF-1 SSD for AIX/Linux with eMLC             ES0A               4
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           Warranty Service Upgrade                            6942-25B           3
IBM           WSU Same Day 24x7x4 Response                        4524               3
...
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.5                     D55W8LL           16*
-           Lic+SW Maint 12 Months
IBM       WebSphere Application Server V8.5.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 webmaster@spec.org

Copyright © 2009-2013 Standard Performance Evaluation Corporation

First published at SPEC.org on 22-Apr-2013