JR39925: CMVC 211574 - CORRECT SLOW PERFORMANCE IN STAGING PROPAGATION.

7.0.0-WS-WCServer-FP009

APAR status

• Closed as new function.

Error description

• In a WebSphere Commerce Server (WCS) Authoring environment,
  publication of a workspace task group using "Quick Publish" to
  the WCS Production environment may experience longer than usual
  latency.
  
  Quick Publish has 2 associated database actions:
  1) Publish workspace data from the Authoring environment
  database to the Production environment database
  2) Perform "bookkeeping" on the Authoring environment database.
  
  It is the bookkeeping action that may take a significant amount
  of time to complete. Since the workspace data is published right
  away, the bookkeeping action attempts to mark as processed any
  records associated with the task in the STAGLOG table, so that
  the same changes are not propagated again during Staging
  Propagation with the StagingProp utility.
  
  Refer to the WCS Information Center for more information on
  Quick Publish, the STAGLOG table, Staging Propagation or the
  StagingProp utility.
  
  Two new configuration options are being provided to allow
  further tuning of this bookkeeping operation:
  1) lowerCaseStaglog="true"
     - The default for this option is "false"
     - This option may be set to "true" if there are no custom
  stageable tables in the schema, AND all UPDATE, DELETE and
  INSERT triggers on all custom stageable tables only insert
  lowercase values into the STGTABLE column of the STAGLOG table
  2) updateStaglogStmtNum="1"
     - The default for this option is "0"
     - This option may be set to "1" to direct the bookkeeping
  action to use a semantically equivalent UPDATE statement that
  may perform better than the default UPDATE statement to mark any
  necessary STAGLOG records as processed
  
     - 0 will use an EXISTS clause in the SQL when updating the
  STAGLOG table.
     - 1 will use an IN clause in the SQL when updating the
  STAGLOG table.
  
  These options can be added as attributes to the <wc:Publisher>
  sub-element of the <wc:QuickPublishConfiguration> element found
  in wc-resource-containers.xml file under the WebSphere AppServer
  directory.
  Example of file location:
  /opt/WebSphere/AppServer/profiles/demo/installedApps/WC_demo_cel
  l/WC_demo.ear/xml/content-management/wc-resource-containers.xml
  
  An example on how to edit these additional parameters:
  <wc:ContentManagement>
    ...
   <wc:QuickPublishConfiguration>
    <wc:Publisher [other-attributes] lowerCaseStaglog="true"
  updateStaglogStmtNum ="1" [other-attributes] />
   </wc:QuickPublishConfiguration>
   ...
  </wc:ContentManagement>
  

Local fix

Problem summary

• USERS AFFECTED:
  All WebSphere Commerce users on v7.0 making use of Quick Publish
  
  PROBLEM ABSTRACT:
  Provision of configuration parameters to reduce latency during
  publication of workspaces using the "Quick Publish" feature
  
  BUSINESS IMPACT:
  If you encounter this issue you may have trouble propagating
  data from your authoring environment into your production
  environment.
  
  RECOMMENDATION:
  

Problem conclusion

• We have provided the ability for our customers to take advantage
  of optimized SQL against the Staging tables.  In doing so the
  particular bookkeeping SQLs involved now have the option of
  using an IN clause instead of an EXISTS clause.
  Also improved is the performance time of the associated queries
  by allowing the removal of a 'lower' function against the DB.
  
  -------------------------------------------------------------
  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 DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP