IBM Support

JR47728: Slow performance of promotion code generation utility when running WCS with Oracle DB

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Slow performance of Commerce Management Center promotion code
    generation utility when running WebSphere Commerce with Oracle
    Database.
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce users on v7.0 who use the promotion code
    generation utility with Oracle DB
    
    PROBLEM ABSTRACT:
    Slow performance of promotion code generation utility when
    running WCS with Oracle DB
    
    BUSINESS IMPACT:
    WebSphere Commerce Management Center promotion code generation
    utility performance impacted
    
    RECOMMENDATION:
    

Problem conclusion

  • When generating an extremely large number of promotion codes,
    there is a higher probability that Commerce will attempt to
    insert duplicate codes into the database during the generation.
     This will cause the insertion operation to fail and Commerce
    must retrieve the existing codes from the database to remove
    duplicates from the batch.
    
    On Oracle doing this takes a long amount of time when the
    database contains millions of codes.  In order to reduce the
    amount of time this takes, an Oracle specific code path was
    added to use the new Error Log feature in Oracle.  This feature
    speeds up the part of the code that detects the duplicate
    existing codes as it no longer needs to get millions of codes,
    but rather only the duplicate codes in the current batch. Using
    the Error Log feature requires the addition of a new table,
    PX_CDPOOL_ERROR which stores only duplicate codes for the
    current batch.
    
    -------------------------------------------------------------
    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

    JR47728

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-10

  • Closed date

    2014-02-07

  • Last modified date

    2014-11-03

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 November 2014