System Configuration Diagram

  No changes were made to the benchmark schema.

  No changes were made to the load program.

  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.

  To ensure database durability, RAID 1 (mirrored stripe)
  was used for the database logs maintained on the
  external storage.  The array contains four 36 GB drives
  for this purpose.

  Over the course of a 75 minute run at an injection rate of 209, the database
  storage for database system increased by 198 MB.
  Given a linear scale, a 24 hour run at the same injection rate would increase storage
  for database system by 3801.6 MB.  The disk array contains four 36 GB drives.
  The DS4700 controller utilized these drives as a RAID 1 array, yielding
  72 GB for available storage.

  WebSphere Application Server V6.1 uses pass-by-value semantics by default.

        IBM System p5 505 WebSphere 6.1 64-bt with DB2 v8.2 Database Server

Supplier        IBM System p5 505 WebSphere 6.1 64-bit Hardware (for one system)
     Product	Description	                                         Qty
    --------    ---------------------------------------------            ---
    9115-505	Server 1:9115 Model 505					   1
	1903	IDE Slimline DVD-ROM Drive				   1
	1932	4096MB (2x2048MB) DIMMs, 276-pin, 533 MHz DDR-2 SDRAM	   2
	1959	IBM 10/100/1000 Base-TX Ethernet Low Profile PCI-X Adapter 1
	1968	73.4 GB 10,000 RPM Ultra320 SCSI Disk Drive		   2
	7927	IBM Rack-mount Drawer Bezel and Hardware		   1
	8290	2-core 2.1 GHz POWER5+ Processor Card, 36MB L3 Cache	   1
		

Supplier        IBM System p5 505 Database Hardware (for one system)
     Product	Description	                                         Qty
    --------    ---------------------------------------------            ---
    9115-505	Server 1:9115 Model 505					  1
	1903	IDE Slimline DVD-ROM Drive				  1
	1932	4096MB (2x2048MB) DIMMs, 276-pin, 533 MHz DDR-2 SDRAM	  2
	1968	73.4 GB 10,000 RPM Ultra320 SCSI Disk Drive		  1
	1977	2 Gigabit Fibre Channel PCI-X Adapter			  1
	7652	2-way 1.65 GHz POWER5 Processor Card,36MB L3 Cache	  1
	7958	AC Power Supply, 600 W					  1
    1814-70A	DS4700 Express Model 70 (2 GB Cache)		  	  1
	5231	(40K6800) 2 Gbps FC, 36.4 GB/15K E-DDM			  8
   IBM QUOTE	3 year support, 24x7x4					  1


Supplier        Miscellaneous Hardware
     Product	Description	                                         Qty
    --------    ---------------------------------------------            ---
    7310-C03    HMC 1:7310-C03 Desktop Hardw.Mgmt.Console		  1
	8800	Quiet Touch Keyboard - USB, Business Black		  1
	8841	Mouse - Business Black with Keyboard Attachment Cable     1
	3631	IBM C117 17" CRT Monitor			  	  1
	0569	HMC Support, 3 year, 24x7x4				  1
      497268	Cisco 3750-24-TS					  1
      150984	Cisco Support 1 year, 24x7x4				  1

			
Supplier        Passport Advantage Software	
     Unit Qty   Description                                                                 Part Number 
IBM      2	DB2 UDB ENTERPRISE SERVER EDITION PROCESSOR LIC+SW MAINT 12 MO              D518GLL
IBM      2	DB2 UDB ENTERPRISE SERVER EDITION PROCESSOR SW MAINT RNWL 1 ANNIV           E00BILL
IBM      2      IBM WebSphere Application Server Processor License+SW Maintenance 12 Months D5CB9LL
IBM      2      IBM WebSphere Application Server SW Maintenance 12 Months                   IBM QUOTE
         		
         		
Supplier        Operating System Software	
     Unit Qty   Description                                                         Part Number
IBM      1      IBM AIX 5L V5.3                                                     IBM QUOTE

  The switch ports and all network adapters are 1Gb/sec.
  
  This submission used the xerces implementation (version - XML4J 4.3) provided
  with WebSphere Application Server V6.1 in the IBM 1.5.0 JDK.
  

The only errors in the driver log files were those that are normally generated by this 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)

1-phase transactions were used to coordinate the interaction between the database
server and JMS servers.