SPEC Seal of Reviewal 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
19,282.14 SPECjEnterprise2010 EjOPS
Submitter:
IBM Corporation
SPEC license # 11 Test date:
Jan-2015
Software Products
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
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: 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 seconds
DB Load Injection Rate: 12,095   Steady State Time: 3,600 seconds
# of Dealer Agents: 120,950   Ramp Down Time: 300 seconds
# of Manufacturing 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 Transactions 43,717,015
Manufacturing Transaction Mix Count Tx. Mix Failure Count
CreateVehicleEJB 12,852,542 50.01% 1,034
CreateVehicleWS 12,846,136 49.99% 1,112
Total # Manufacturing Transactions 25,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

WebSphere Application Server V8.5.5.4
Vendor: IBM Corporation Availability: Dec-2014
CTS Version: 6.0 Date Passed CTS: May-2012
OS Name: SUSE Linux Enterprise Server 11 SP3
EJB Protocol: RMI/IIOP

IBM SDK, Java Technology Edition, Version 7 Release 1, Service Refresh 2
Vendor: IBM Corporation Availability: 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: Nov-2014
OS Name: SUSE Linux Enterprise Server 11 SP3

IBM DB2 Universal JDBC Drivers (4.19.26)
Vendor: IBM Corporation Availability: Nov-2014
OS Name: SUSE Linux Enterprise Server 11 SP3

DB2 10.5 FP5
Vendor: IBM Corporation Availability: Nov-2014
OS Name: SUSE Linux Enterprise Server 11 SP3

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.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

JEE AppServer HW (SUT hardware)
Hardware Vendor: Lenovo Group Ltd. OS Vendor: Micro Focus International plc
Model Name: IBM System x3650 M5 OS Name: SUSE Linux Enterprise Server 11 SP3
Processor: Intel Xeon processor E5-2697 v3 (Intel Turbo Boost Technology up to 3.6 GHz) Filesystem: ext3
MHz: 2600 Disks: 2x500GB 7.2K SATA
# of CPUs: 28 cores, 2 chips, 14 cores/chip (56 HW threads/chip) Network Interface: 6x 10GBit and 1x 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: Dec-2014
Other Cache: 35 MB I+D on chip per chip OS 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. OS Vendor: Micro Focus International plc
Model Name: IBM System x3850 X6 OS Name: SUSE Linux Enterprise Server 11 SP3
Processor: Intel Xeon processor E7-4890 v2 (Intel Turbo Boost Technology up to 3.4 GHz) Filesystem: ext3
MHz: 2800 Disks: 2x 128GB SSD, 2x 1.2TB SSD
# of CPUs: 60 cores, 4 chips, 15 cores/chip (120 HW threads/chip) Network Interface: 4x 10GBit and 1x 1GBit network ports
Memory (MB): 1048576 Other Hardware:
DIMM[0] Count: 64 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: Mar-2014
Other Cache: 37.5 MB I+D on chip per chip OS 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 OS Vendor: Micro Focus International plc
Model Name: IBM BladeCenter HS22 OS Name: SUSE Linux Enterprise Server 11 SP3
Processor: Xeon X5670 Filesystem: ext3
MHz: 2933 Disks: 2x 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: 9
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: 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 webmaster@spec.org

Copyright © 2009-2015 Standard Performance Evaluation Corporation

First published at SPEC.org on 18-Feb-2015