JR42158: CMVC 217638 - IMPROVE THE PERFORMANCE ISSUES RELATED WITH STAGINGPROP UTILITY.

WebSphere Commerce Version 7.0.0.7 Fix Pack

APAR status

• Closed as program error.

Error description

• This APAR provides a better-performing StagingProp utility that
  will reduce the number of database connections, execute better
  optimized SQL and provide faster consolidation of records in the
  STAGLOG table.  A new summary report is also added to indicate
  the number of records, by table, that were processed, with
  breakdowns by type of transaction (Insert/Update/Delete).  This
  new report will help the IT staff to better understand the
  impact of the business user traffic on the staging processes.
  

Local fix

Problem summary

• USERS AFFECTED:
  IT staff who run StagingProp to propagate data from staging
  database to production database who are either unable to
  complete the staging propagation within their maintenance window
  or perform adequate problem determination using just the
  StagingProp log information.
  
  
  PROBLEM ABSTRACT:
  StagingProp requires some additional performance enhancements
  and better error handling.
  
  
  BUSINESS IMPACT:
  Staging propagation (copying from the staging database to the
  production database) operates on the STAGLOG table, which tracks
  the Create/Update/Delete activity against the database tables.
  This operation consists of consolidation of records to reduce
  volume of activity, and the propagation of those changes.
  
  When there are a large number of changes being made, leading to
  a large number of records in the STAGLOG table, the StagingProp
  utility takes a long time to complete each of theses phases.
  
  
  RECOMMENDATION:
  

Problem conclusion

• This update is focused on 3 main areas within StagingProp.
  1. Performance improvement
      - Reduced number of database I/O operations by increasing
  the number of records fetched at a time
      - Added a database index on the STAGLOG table to improve
  fetch performance
  
  2. Better error toleration for consolidation with Action On
  Error support for operations on the same record:
      - Deletion followed by Update
      - Deletion followed by Deletion
      - Insertion followed by Insertion
      - Update followed by Insertion
  
  3. Provide support for cyclic reuse of unique keys by adding
  support through additional column UPDATABLE_UK_COL in tables
  STGSITETAB and STGMERTAB.
  
  
  4.  Additionally, to ease problem determination, distinct-value
  exit codes from invocation of the utility are being made
  available.
  
  These exit codes may be used to categorize severity of error(s)
  in question and to determine the phase of the utility at which
  error(s) were encountered.
  An exit code of 0 indicates a successful execution. An exit code
  other than 0 is an indication of an error encountered by the
  utility.  Refer to the log file generated by the utility for
  more diagnostic information if a non-zero exit code is issued by
  the utility.
  
  
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP