-------------------------------------------------------------------------------- SPECjAppServer(R)2004 Result Copyright (C) 2004 Standard Performance Evaluation Corporation -------------------------------------------------------------------------------- WebSphere 5.1 Application Server on eServer xSeries 335 Cluster -------------------------------------------------------------------------------- 900.32 SPECjAppServer2004 JOPS@Standard -------------------------------------------------------------------------------- Submitter: IBM Corporation SPEC license # 11 Test date: Jun-2004 -------------------------------------------------------------------------------- SUT CONFIGURATION -------------------------------------------------------------------------------- J2EE Server Nodes: 8 DB Server Nodes: 1 J2EE Server CPUs: 16 cores, 16 chips DB Server CPUs: 4 cores, 4 chips J2EE Instances: 8 DB Instances: 1 Other SUT Components: (1) IBM eServer xSeries 335 running IBM HTTP Server 2.0.47 and IBM Site Selector (1) IBM eServer xSeries 335 running IBM HTTP Server 2.0.47 (1) 3COM 4924 Switch -------------------------------------------------------------------------------- BENCHMARK SETTINGS -------------------------------------------------------------------------------- Dealer Injection Rate: 540 Ramp Up Time: 600 sec # of Dealer Agents: 8 Ramp Down Time: 300 sec # of Manufacturing Agents: 3 Steady State Time: 3,600 sec DB Load Injection Rate: 600 Trigger Time: 500 sec -------------------------------------------------------------------------------- Detailed Results -------------------------------------------------------------------------------- Dealer Transaction Mix Count Tx. Mix Purchase 487,828 25.04% Manage 487,864 25.05% Browse 972,150 49.91% Total # Dealer Transactions 1,947,842 Total # Manufacturing Transactions 1,293,318 Response Times Average Maximum 90th% Reqd Purchase 0.28 7.34 0.70 2.00 Manage 0.48 11.34 1.10 2.00 Browse 0.29 8.37 0.70 2.00 Manufacturing 1.95 8.03 3.75 5.00 Reproducibility Run (SPECjAppServer2004 JOPS) 900.95 -------------------------------------------------------------------------------- SOFTWARE PRODUCTS -------------------------------------------------------------------------------- WebSphere 5.1 Application Server FP 5.1.0.4, Network Deployment Vendor: IBM Corporation Availability Date: May-2004 Date Passed CTS: Dec-2003 CTS Version: 1.3 EJB Protocol: RMI/IIOP OS Name: Suse Linux Enterprise Server 8.0, Service Pack 3 -------------------------------------------------------------------------------- Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1) Vendor: IBM Corporation Availability Date: Dec-2003 OS Name: Suse Linux Enterprise Server 8.0, Service Pack 3 -------------------------------------------------------------------------------- IBM DB2 Universal JDBC Driver (XA) Vendor: IBM Corporation Availability Date: Jul-2004 OS Name: Suse Linux Enterprise Server 8.0, Service Pack 3 -------------------------------------------------------------------------------- IBM DB2 V8.1 FP6 Vendor: IBM Corporation Availability Date: Jul-2004 OS Name: Suse Linux Enterprise Server 8.0, Service Pack 3 -------------------------------------------------------------------------------- IBM HTTP Server V2.0.47 Vendor: IBM Corporation Availability Date: May-2003 Description: Web Server -------------------------------------------------------------------------------- WebSphere Plugin for IBM HTTP Server V2.0.47 Vendor: IBM Corporation Availability Date: May-2003 Description: Web Server module to forward requests to application server -------------------------------------------------------------------------------- IBM Site Selector, Edge Component of WebSphere V5.1 Vendor: IBM Corporation Availability Date: May-2003 Description: Load balancer via mapping DNS names to IP addresses -------------------------------------------------------------------------------- WebSphere V5.1 JMS Server Vendor: IBM Corporation Availability Date: May-2003 Description: Messaging Server -------------------------------------------------------------------------------- SOFTWARE CONFIGURATIONS -------------------------------------------------------------------------------- J2EE Application Servers J2EE Product: WebSphere 5.1 Application Server FP 5.1.0.4, Network Deployment JVM Product: Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1) JDBC Product: IBM DB2 Universal JDBC Driver (XA) Hardware: J2EE Application Server Hardware (7) # of Instances: 7 Interfaces: Web Interface for the Dealer Domain Web Interface for the Supplier Domain EJB Interface for the Dealer Domain EJB Interface for the Manufacturing Domain EJB Interface for the Supplier Domain Notes / Tuning Information Initial heap size = 1536 MB Maximum heap size = 1536 MB com.ibm.CORBA.FragmentSize=3000 Total Transaction Lifetime Timeout = 1000 ConnectionIOTimeout = 120 MaxConnectBacklog = 1024 MaxKeepAliveRequests = 10 Minimum Web Container threads = 50 Maximum Web Container threads = 50 EJB Cache Size = 30530 Minimum ORB threads = 15 Maximum ORB threads = 15 com.ibm.ws.pm.batch=true com.ibm.ws.pm.deferredcreate=true Monitoring Ping Interval = 600 Refer to files appservers/resources.xml, appservers/startup.txt, and appservers/server.xml in the archive file. They contain: datasource configuration, JVM command line parameters, and other J2EE configuration information -------------------------------------------------------------------------------- Emulator SW Config J2EE Product: WebSphere 5.1 Application Server FP 5.1.0.4, Network Deployment JVM Product: Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1) Hardware: Load Driver(Emulator) Hardware # of Instances: 1 Notes / Tuning Information Initial heap size = 1024 MB Maximum heap size = 1024 MB ConnectionIOTimeout = 120 MaxConnectBacklog = 1024 -------------------------------------------------------------------------------- Database SW Config DB Product: IBM DB2 V8.1 FP6 Hardware: Database Server Hardware # of Instances: 1 Notes / Tuning Information Tuning performed by db2tune8.sh script in the archive/Schema directory. -------------------------------------------------------------------------------- Driver SW Config Primary JVM Product: Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1) Hardware: Load Driver(Primary) Hardware # of Instances: 1 Notes / Tuning Information JVM_OPTIONS=-Xss128k -Xms1070m -Xmx1070m -Dcom.ibm.CORBA.FragmentSize=3000 -------------------------------------------------------------------------------- Driver SW Config Satellites #1, and #2 JVM Product: Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1) Hardware: Load Driver (2) # of Instances: 2 Notes / Tuning Information JVM_OPTIONS=-Xss128k -Xms1200m -Xmx1200m -Dcom.ibm.CORBA.FragmentSize=3000 -------------------------------------------------------------------------------- IBM HTTP Server 2.0.47 Other Product: IBM HTTP Server V2.0.47 Hardware: Web Server Hardware # of Instances: 2 Notes / Tuning Information In the file conf/httpd.conf KeepAliveTimeout 1000 MaxKeepAliveRequests 0 ServerLimit 18 StartServers 18 ThreadLimit 275 MaxClients 4950 MaxSpareThreads 3400 ThreadsPerChild 275 Comment out access.log -------------------------------------------------------------------------------- IBM HTTP Server 2.0.47 WebSphere Plugin Other Product: WebSphere Plugin for IBM HTTP Server V2.0.47 Hardware: Web Server Hardware # of Instances: 2 Notes / Tuning Information In the file .../config/cells/plugin-cfg.xml Changed "Round Robin" to "Random" for SPECJ04 Cluster -------------------------------------------------------------------------------- IBM Site Selector (one of the Edge Components for WebSphere Application Server, V5.1) Other Product: IBM Site Selector, Edge Component of WebSphere V5.1 Hardware: Web Server Hardware # of Instances: 1 Notes / Tuning Information Defaults used. -------------------------------------------------------------------------------- WebSphere JMS Server (Included in WebSphere Application Server V5.1) Other Product: WebSphere V5.1 JMS Server Hardware: JMS Server Hardware # of Instances: 1 Notes / Tuning Information Deleted the MQ manager and made these changes: In createmq.properties: LogFileSize = 16384 LogPrimaryFiles = 60 LogSecondaryFiles = 3 In mqs.ini (LogDefaults section) LogPrimaryFiles = 60 LogSecondaryFiles = 3 LogFilePages = 16384 LogBufferPages = 512 Recreated the MQ Manager and made these changes: In qm.ini (Channels section) MQIBindType=FASTPATH In qm.ini (TuningParameters section) DefaultQBufferSize=100000000 DefaultPQBufferSize=100000000 -------------------------------------------------------------------------------- HARDWARE SYSTEMS -------------------------------------------------------------------------------- J2EE Application Server Hardware (7) (SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM eServer xSeries 335 Processor: Intel Xeon DP MHz: 3200 # of CPUs: 2 cores, 2 chips, 1 core/chip (2 HW threads/chip) Memory (MB): 4096 L1 Cache: 12Kuops(I)+8KB(D) per chip L2 Cache: 512KB per chip Other Cache: 2MB L3 cache per chip OS Vendor: SuSE Inc. OS Name: SuSE Linux Enterprise Server 8 Service Pack 3 Disks: 2x36.4GB 15K RPM Ultra 320 SCSI (using x335 integrated mirroring) Network Interface: 1000BASE-TX Gigabit Integrated Ethernet Other Hardware: # of Systems: 7 H/W Available: May-2004 O/S Available: May-2004 Notes / Tuning Information These entries added to /etc/init.d/sysctl.conf net.core.netdev_max_backlog = 600 net.core.somaxconn = 1024 net.ipv4.tcp_synack_retries = 20 net.ipv4.tcp_fin_timeout = 30 fs.file-max=65535 kernel.shmmax=1073741824 net.ipv4.tcp_sack=0 net.ipv4.tcp_timestamps=0 vm.bdflush=100 1200 128 512 15 5000 100 0 0 kernel.sched_yield_scale=1 -------------------------------------------------------------------------------- Database Server Hardware (SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM eServer xSeries 365 Processor: Intel Xeon MHz: 3000 # of CPUs: 4 cores, 4 chips, 1 core/chip (2 HW threads/chip) Memory (MB): 8192 L1 Cache: 12Kuops(I)+8KB(D) per chip L2 Cache: 512KB per chip Other Cache: 4MB L3 cache per chip OS Vendor: SuSE Inc. OS Name: SuSE Linux Enterprise Server 8, Service Pack 3 Disks: 2x36.4GB 15K RPM SCSI Network Interface: 1000BASE-TX Other Hardware: Two ServeRAID 6M controllers each connected to separate EXP400 Storage Units each with 14x36.4GB 15K Ultra320 SCSI disks. See diagrams: db_tables.JPG and db_logs.JPG in the archive. # of Systems: 1 H/W Available: Apr-2004 O/S Available: Apr-2004 Notes / Tuning Information These entries were added to /etc/init.d/sysctl.conf net.core.netdev_max_backlog = 600 net.core.somaxconn = 1024 net.ipv4.tcp_synack_retries = 20 net.ipv4.tcp_fin_timeout = 30 fs.file-max=65535 kernel.shmmax=1073741824 net.ipv4.tcp_sack=0 net.ipv4.tcp_timestamps=0 vm.bdflush=100 1200 128 512 15 5000 100 0 0 kernel.sched_yield_scale=1 This change was made in .../java/jre/lib/security/java.security networkaddress.cache.ttl=1 This entry was added to /root/.profile ulimit -n 10000 -------------------------------------------------------------------------------- Web Server Hardware (SUT hardware) Hardware Vendor: IBM Model Name: IBM eServer xSeries 335 Processor: Intel Xeon DP MHz: 3200 # of CPUs: 2 cores, 2 chips, 1 core/chip (2 HW threads/chip) Memory (MB): 4096 L1 Cache: 12Kuops(I)+8KB(D) per chip L2 Cache: 512KB per chip Other Cache: 2MB L3 cache per chip OS Vendor: Red Hat, Inc. OS Name: Red Hat Enterprise Linux AS 3.0 SP1 Disks: 2x36.4GB 15K RPM Ultra 320 SCSI (using x335 integrated mirroring) Network Interface: (2)1000BASE-TX Gigabit Integrated Ethernet Other Hardware: # of Systems: 2 H/W Available: Apr-2004 O/S Available: Apr-2004 Notes / Tuning Information These entries were added to /etc/sysctl.conf net.core.netdev_max_backlog = 7000 net.ipv4.tcp_syn_retries = 20 net.ipv4.tcp_synack_retries = 20 net.ipv4.tcp_fin_timeout = 30 vm.max_map_count = 131072 This entry was added to /root/.bash_profile ulimit -n 8192 -------------------------------------------------------------------------------- Load Driver(Primary) Hardware (non-SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM eServer xSeries 365 Processor: Intel Xeon MHz: 3000 # of CPUs: 4 cores, 4 chips, 1 core/chip (2 HW threads/chip) Memory (MB): 8192 L1 Cache: 12Kuops(I)+8KB(D) per chip L2 Cache: 512KB per chip Other Cache: 4MB L3 cache per chip OS Vendor: SuSE Inc. OS Name: SuSE Linux Enterprise Server 8, Service Pack 3 Disks: 2x36.4GB 15K RPM SCSI Network Interface: (3)1000BASE-TX Other Hardware: # of Systems: 1 H/W Available: Apr-2004 O/S Available: Apr-2004 Notes / Tuning Information These entries were added to /etc/init.d/sysctl.conf net.core.netdev_max_backlog = 600 net.core.somaxconn = 1024 net.ipv4.tcp_synack_retries = 20 net.ipv4.tcp_fin_timeout = 30 fs.file-max=65535 kernel.shmmax=1073741824 net.ipv4.tcp_sack=0 net.ipv4.tcp_timestamps=0 vm.bdflush=100 1200 128 512 15 5000 100 0 0 kernel.sched_yield_scale=1 This change was made in .../java/jre/lib/security/java.security networkaddress.cache.ttl=1 This entry was added to /root/.profile ulimit -n 10000 -------------------------------------------------------------------------------- Load Driver (2) (SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM eServer xSeries 335 Processor: Intel Xeon DP MHz: 3200 # of CPUs: 2 cores, 2 chips, 1 core/chip (2 HW threads/chip) Memory (MB): 4096 L1 Cache: 12Kuops(I)+8KB(D) per chip L2 Cache: 512KB per chip Other Cache: 2MB L3 cache per chip OS Vendor: SuSE Inc. OS Name: SuSE Linux Enterprise Server 8 Service Pack 3 Disks: 2x36.4GB 15K RPM Ultra 320 SCSI (using x335 integrated mirroring) Network Interface: (3)1000BASE-TX Gigabit Other Hardware: # of Systems: 2 H/W Available: Apr-2004 O/S Available: Apr-2004 Notes / Tuning Information These entries added to /etc/init.d/sysctl.conf fs.file-max=65535 kernel.shmmax=1073741824 net.ipv4.tcp_sack=0 net.ipv4.tcp_timestamps=0 vm.bdflush=100 1200 128 512 15 5000 100 0 0 kernel.sched_yield_scale=1 This entry was added to /root/.profile ulimit -n 10000 -------------------------------------------------------------------------------- Load Driver(Emulator) Hardware (non-SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM eServer xSeries 440 Processor: Intel Xeon MHz: 2000 # of CPUs: 4 cores, 4 chips, 1 core/chip (2 HW threads/chip) Memory (MB): 4096 L1 Cache: 12Kuops(I)+8KB(D) per chip L2 Cache: 512KB per chip Other Cache: 2MB L3 cache per chip OS Vendor: SuSE Inc. OS Name: SuSE Linux Enterprise Server 8, Service Pack 3 Disks: 2x36.4GB 10K RPM SCSI Network Interface: (2)1000BASE-TX Other Hardware: # of Systems: 1 H/W Available: Apr-2004 O/S Available: Apr-2004 Notes / Tuning Information These entries were added to /etc/init.d/sysctl.conf net.core.netdev_max_backlog = 600 net.core.somaxconn = 1024 net.ipv4.tcp_synack_retries = 20 net.ipv4.tcp_fin_timeout = 30 fs.file-max=65535 kernel.shmmax=1073741824 net.ipv4.tcp_sack=0 net.ipv4.tcp_timestamps=0 vm.bdflush=100 1200 128 512 15 5000 100 0 0 kernel.sched_yield_scale=1 This entry was added to /root/.profile ulimit -n 8192 -------------------------------------------------------------------------------- JMS Server Hardware (SUT hardware) Hardware Vendor: IBM Corporation Model Name: IBM eServer xSeries 335 Processor: Intel Xeon DP MHz: 3200 # of CPUs: 2 cores, 2 chips, 1 core/chip (2 HW threads/chip) Memory (MB): 4096 L1 Cache: 12Kuops(I)+8KB(D) per chip L2 Cache: 512KB per chip Other Cache: 2MB L3 cache per chip OS Vendor: SuSE Inc. OS Name: SuSE Linux Enterprise Server 8 Service Pack 3 Disks: 2x36.4GB 15K RPM Ultra 320 SCSI (using x335 integrated mirroring) Network Interface: 1000BASE-TX Gigabit Integrated Ethernet Other Hardware: # of Systems: 1 H/W Available: Apr-2004 O/S Available: Apr-2004 Notes / Tuning Information These entries added to /etc/init.d/sysctl.conf fs.file-max=65535 kernel.shmmax=1073741824 net.ipv4.tcp_sack=0 net.ipv4.tcp_timestamps=0 vm.bdflush=100 1200 128 512 15 5000 100 0 0 kernel.sched_yield_scale=1 -------------------------------------------------------------------------------- BENCHMARK MODIFICATIONS -------------------------------------------------------------------------------- Schema Modifications: No changes were made to the benchmark schema. -------------------------------------------------------------------------------- Load Program Modifications: No changes were made to the load program. BENCHMARK CONFIGURATION INFORMATION -------------------------------------------------------------------------------- Isolation Requirement Info: The following beans: PartEnt, ComponentEnt, AssemblyEnt, BomEnt and LargeOrderEnt in the Manufacturing Domain, ItemEnt in the Orders Domain, and SupplierCompEnt and SupplierEnt in the Supplier Domain were accessed using READ_COMMITTED which is Cursor Stability (CS) for DB2. The remaining beans were accessed using REPEATABLE_READ which translates to DB2 isolation level of Read Stability (RS). The ItemEnt bean was cached for 20 minute intervals using the WebSphere Lifetime in Cache Mechanism. Only the data inside the bean was cached. -------------------------------------------------------------------------------- Durability Requirement Info: To ensure database durability, RAID 50 (composed of two RAID 5E arrays) was used for the database logs maintained on the EXP400 Storage Expansion Unit. Each application server and the JMS server has a pair of mirrored disks (using the x335 integrated mirroring). This provides durability for transaction logs, message queues, and message logs. -------------------------------------------------------------------------------- Storage Requirement Info: Over the course of a 75 minute run at an injection rate of 540, database storage increased 476 MB. Given a linear scale, a 24 hour run at the same injection rate would increase storage by 9139.20 MB. The EXP 400 Disk enclosure contained fourteen 36.4GB drives. The ServeRAID 6M adapter utilized these drives as a RAID 50 array consisting of two RAID 5E arrays of 7 drives each. This yielded a total disk storage of 419879 MB for the database. -------------------------------------------------------------------------------- Argument Passing Semantics: WebSphere Application Server V5.1 uses pass-by-value semantics by default BILL OF MATERIALS -------------------------------------------------------------------------------- IBM x335 WebSphere 5.1 Cluster with p650 DB2 v8.1 FP6 Database Server Supplier x335 WebSphere Application Server and IBM HTTP Server Hardware (for 10 systems) Unit Qty Description Part Number 2004 IBM 10 IBM xSeries 335 8676-J1X IBM 3200 MHZ 533 MHZ 2MB L3 CACHE INTEL XEON PROCESSOR includen in 8676-J1X IBM 2 X 512MB PC2100 DDR SDRAM (CHIPKILL);24X CD-ROM includen in 8676-J1X IBM 10 IBM XSERIES 335 - 3YR WARRANTY SERVICE UPGRADE (24X7X4) 21P2073 IBM 10 REMOVE STANDARD MEMORY 09N8043 IBM 10 xSERIES 3.2 GHz/533MHz-2MB L3 CACHE UPGRADE WITH XEON PROCESSOR 13N0662 IBM 40 IBM 1 GB PC2100 CL2.5 ECC DDR SDRAM DIMM 33L5039 IBM 10 INTEGRATED MIRRORING 01R1356 IBM 20 IBM 36.4 GB 15K RPM ULTRA320 SCSI HOT-SWAP HDD 32P0734 IBM x365 Database Hardware (for 1 system) Unit Qty Description Part Number 2004 IBM 1 IBM xSeries 365 8862-6RX IBM 2 3.0GHz 4MB L3 Intel Xeon Processor MP included in 8862-6RX IBM 4 X 512MB PC2100 DDR SDRAM;24X CD-ROM includen in 8862-6RX IBM 1 REMOVE STANDARD MEMORY 09N8043 IBM 1 Warranty service upgrade; 3 yr onsite repair 24x7x4 96P2253 IBM 2 3.0GHz 4MB L3 Cache Upgrade With Xeon Processor MP 13N0710 IBM 8 1GB PC2100 CL2.5 ECC DDR SDRAM RDIMM 73P2031 IBM 2 IBM 36.4 GB 15K RPM ULTRA320 SCSI HOT-SWAP HDD 32P0734 IBM 1 ServeRAID-6M Ultra320 SCSI Controller (256MB Cache) 02R0988 IBM 1 ServeRAID-6M Ultra320 SCSI Controller 32P0033 IBM 2 Intel PRO/1000 XT Server Adapter 31P9601 Storage Hardware (for x365) Unit Qty Description Part Number 2004 IBM 2 EXP400 External SCSI Storage Enclosure 17331RU IBM 2 VHDCI SCSI 2m cable - one cable included in 17331RU IBM 2 IBM EXP400 - 3yr Warranty Service Uprade (24x7x4) 41L2768 IBM 28 IBM 36.4 GB 15K RPM ULTRA320 SCSI HOT-SWAP HDD 32P0734 Miscellaneous Hardware Unit Qty Description Part Number 2004 IBM 1 NetBAY42 ER Enterprise Rack 930842S IBM 1 NetBay - 3yr Warranty Service Upgrade (24x7x4) 41L2762 3COM 1 3COM SUPERSTACK 3 SWITCH 4924 3C17701-US 3COM 3 3COM 1YR 24X7X4 EXPRESS SUPPORT - CAT10 3CS-EX74-10E IBM 1 E54 15 INCH BLACK CRT MONITOR (13.8INCH VIEWABLE) 633147N IBM 1 E54 - 3YR WARRANTY SERVICE UPGRADE (24X7X4) 30L9183 IBM 1 IBM PREFERRED PRO FULL-SIZE KBD - 104 KEYS - PS/2 31P7454 IBM 1 IBM SLEEK 2-BUTTON MOUSE - STEALTH BLACK (PS/2) 28L3673 Passport Advantage Software Unit Qty Description Part Number 2004 IBM 4 DB2 UDB WORKGROUP SERVER UNLIMITED EDITION PROCESSOR LIC+SW MAINT 12 MO D51NDLL IBM 8 DB2 UDB WORKGROUP SERVER UNLIMITED EDITION PROCESSOR SW MAINT RNWL 1 ANNIV E00IHLL IBM 16 WAS NETWORK DEPLOYMENT 5.1 MULTIPLT PROG PK 1 PROC NLV MEDIA PK NLV BA0BPML IBM 32 WEBSPHERE APPLICATION SRVR NETWORK DEPLOYMENT PROC ANNUAL SW MAINT RNWL E1ALVLL IBM 1 EDGE SERVER - LOAD BALANCING, CACHING,CENTRALIZED SECURITY included in BA0BPML IBM 1 EDGE SERVER - SUPPORT included in E1ALVLL IBM 2 IBM HTTP SERVER 2.0.47 included in BA0BPML IBM 2 IBM HTTP SERVER 2.0.47 SUPPORT included in E1ALVLL Operating System Software Unit Qty Description Part Number 2004 SuSE 1 SUSE LINUX ENTERPRISE SERVER 8 FOR X86 INSTALLATION KIT SUSE QUOTE SuSE 9 PREMIUM SUPPORT FOR SLES8 X86 FOR 3 YEARS SUSE QUOTE SuSE 9 MAINTENANCE PROGRAM FOR SLES8 X86 FOR 3 YEARS SUSE QUOTE Red Hat 1 REDHAT ENTERPRISE LINUX V.3.2.26 FOR X86 INSTALLATION KIT REDHAT QUOTE Red Hat 1 ENTERPRISE TECHNICAL ACCOUNT MANAGEMENT REDHAT QUOTE Red Hat 6 RHEL AS Premium (x86) Subscription (https://www.redhat.com/apps/commerce/rhel/as/) -------------------------------------------------------------------------------- OTHER BENCHMARK INFORMATION -------------------------------------------------------------------------------- The switch ports and all network adapters are 1Gb/sec. Three types of load balancing were utilized: WebSphere's workload management performed load balancing for RMI/IIOP requests. Site Selector balanced HTTP connections across the two IHS web servers. The IHS WebSphere plugin balanced load across the WebSphere nodes and also maintained session affinity to a particular node. This submission used the xerces implementation (version - XML4J 4.2.2) provided with WebSphere Application Server V5.1 in the IBM 1.4.1 JDK. -------------------------------------------------------------------------------- General Notes -------------------------------------------------------------------------------- The only errors in the driver log files were those that are normally generated by this benchmark. The IBM DB2 Universal JDBC Driver (XA) is a type 2 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) XA 2-phase transactions were used to coordinate the interaction between the database server and JMS server. -------------------------------------------------------------------------------- For questions about this result, please contact the submitter: IBM Corporation For other inquiries, please contact SPEC - Benchmark run on Sun Jun 06 18:01:31 EDT 2004 by SPECjAppServer2004 v1.02 - Result submitted on Wed Jun 23 03:03:00 EDT 2004 - Report generated by SPECjAppServer2004 Reporter v1.03 Copyright (C) 2004 Standard Performance Evaluation Corporation