IBM Support

LI75719: CMVC 204963 - PROVIDE AN ON/OFF TOGGLE FOR LOCKITEMSPEC METHOD IN PREPAREORDERCMDIMPL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Problem Description
    For Oracle Users with ATP inventory, a fix was created and
    shipped with Fix Pack 8.
    
    The itemspec table is locked to prevent negative inventory from
    occurring if two simultaneous users purchase the last one
    remaining quantity of a product.  Due to the nature of this fix,
    the associated table is locked during the checkout flow.  When
    the site is under heavy load, lockwaits can manifest themselves
    as seen in the javacores.  If a customer has their own inventory
    management fix for the above original issue, it may be
    beneficial to 'turn off' the locking of the itemspec table for
    better performance.
    

Local fix

Problem summary

  • USERS AFFECTED:
    All WebSphere Commerce users on v6 and v7 who are using Oracle
    and ATP inventory.
    
    PROBLEM ABSTRACT:
    Provide an on and off toggle in IBM WebSphere Commerce for
    lockitemspec method in PrepareOrderCmdImpl
    
    BUSINESS IMPACT:
    Performance related when the server is under heavy load
    
    RECOMMENDATION:
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    LI75719

  • Reported component name

    WC BUS ED ILINU

  • Reported component ID

    5724I3804

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-09-30

  • Closed date

    2011-07-22

  • Last modified date

    2011-07-22

  • 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 ED ILINU

  • Fixed component ID

    5724I3804

Applicable component levels

  • R600 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":"6.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
22 July 2011