Full Disclosure Archive

  To support the Injection rate, tablespace sizes were increased.
  To redirect standard output and standard error to file,
  the following statement was added to top part of all file in Schema/sql.
  spool [file name]
  And the following statement was added to bottom part of the same files.
      spool off
  
  To get transaction entry area with schema definition,
  the following strings was added to all file in Schema/sql.
  initran 10
  
  To use Oracle as database, init_templ.ora file was used.
  The followings are stuffs on that file.
  db_name=ecperf (DB name)
  control_files=D:\oracle\ora92\dbs\cntrlecperf.dbf (Full path to control file)
  cursor_space_for_time=TRUE
  db_block_size=2048
  db_block_buffers=786432
  db_file_multiblock_read_count=128
  db_files=256
  dml_locks=2500
  session_cached_cursors=100
  enqueue_resources=1235
  log_buffer=2097152
  log_checkpoint_interval=2147483647
  processes=1000
  open_cursors=1000
  max_rollback_segments=100
  rollback_segments=(t0,t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,
  t20,t21,t22,t23,t24,t25,t26,t27,t28,t29,t30,t31,t32,t33,t34,t35,t36,t37,t38,t39)
  shared_pool_size=30000000
  sessions=1024
  transactions=1024
  transactions_per_rollback_segment=8
  parallel_max_servers=100
  sort_area_size=8388608
  timed_statistics=true
  compatible=9.2.0 (For Oracle9.2.0)
  undo_management=AUTO
  undo_retention=5
  undo_suppress_errors=TRUE
  undo_tablespace= roll_space
  
  To use Oracle as database, p_build_templ.ora file was used.
  The followings are stuffs on that file.
  db_name=ecperf (DB name)
  control_files=D:\oracle\ora92\dbs\cntrlecperf.dbf (Full path to cntrol file)
  db_files=256
  db_file_multiblock_read_count=256
  db_block_buffers=80000
  db_block_size=2048
  dml_locks=2500
  log_checkpoint_interval=999999999
  log_buffer=1048576
  max_rollback_segments=1000
  open_cursors=512
  processes=100
  sessions=200
  transactions=200
  transactions_per_rollback_segment=1
  rollback_segments=(r01,r02,r03,r04,r05,r06,r07,r08,r09)
  shared_pool_size=10000000
  sort_area_size=8388698
  parallel_max_servers=100
  compatible=9.2.0 (For Oracle9.2.0)
  
  To use Oracle as database, p_create_templ.ora file was used.
  The followings are stuffs on that file.
  db_name=ecperf (DB name)
  control_files=D:\oracle\ora92\dbs\cntrlecperf.dbf (Full path to control files)
  db_files=256
  db_block_buffers=16000
  db_block_size=2048
  dml_locks=500
  log_checkpoint_interval=999999999
  log_buffer=32768
  sessions=70
  processes=50
  transactions=50
  compatible=9.2.0 (For Oracle9.2.0)

  The followings were added to bin/driver.bat.
  set JAVA_HOME=D:\APW\jbk4\jdk
  set JAS_HOME=D:\SPEC
  set CONFIG_DIR=%JAS_HOME%\config
  set APPSSERVER=INTERSTAGE
  set ENVFILE=%APPSSERVER%.env

  In our case, name of deployment descriptor file is FJDeploymentDescriptor.xml (Not ejb-jar.xml.)
  For each bean, there is deployment descriptor file "FJDeploymentDescriptor.xml".
  

  CMP was used for all beans.
  
  
  
  
  
  

  READ_COMMITTED was used for the following beans.
  RuleEnt
  CustomerEnt
  LargeOrderEnt
  SupplierEnt
  DiscountEnt
  ItemEnt
  ComponentEnt
  AssemblyEnt
  BomEnt
  PartEnt
  SupplierCompEnt
  OrderCustomerEnt
  
  Beans that has "pessimistic" value for concurrency-mode tag
  in their Interstage expanded definition file obtain a lock
  on the entity in the database for SELECT FOR UPDATE sql statement
  at the begining of the transaction.
  The following beans were deployed with the above condition
  to use REPEATABLE_READ.
  (The followings are written as beans:Interstage expanded definition file.)
  SequenceEnt:FJCMP_SequenceCmpEJB.xml
  OrderLineEnt:FJCMP_OrderLineCmpEJB.xml
  POEnt:FJCMP_POCmpEJB.xml
  OrderEnt:FJCMP_OrderCmpEJB.xml
  WorkOrderEnt:FJCMP_WorkOrderCmpEJB.xml
  InventoryEnt:FJCMP_InventoryCmpEJB.xml
  SComponentEnt:FJCMP_SComponentCmpEJB.xml
  POLineEnt:FJCMP_POLineCmpEJB.xml

  RAID1 disk mirroring was used to ensure durability of the disk used for database logs.
  
  

  A 45 minute run at an injection rate of 125 increased storage use by
  0.1 GB. Given linear scaling, eight hours of run time would at that
  rate require 1.1 GB. The system was configured with 108GB of disk
  storage which is sufficient for the 8 hour run.

  Interstage Application Server uses pass-by-value semantics
  by specifying -DFJPassByValue=yes as JVM command line for
  EJB container.

  xerces.jar file included in the SPECjAppServer2001 kit was used.

No errors were reported during the final or reproducability run.