IBM Support

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

Direct link to fix

Subscribe

You can track all active APARs for this component.

 

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 number

    JR39925

  • Reported component name

    WC BUS DEV ED W

  • Reported component ID

    5724I3900

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2011-06-23

  • Closed date

    2011-08-31

  • Last modified date

    2011-08-31

  • 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

[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
07 December 2021