Direct links to fixes
7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.2 Fix Pack
WebSphere Commerce Version 6.0.0.11 Fix Pack
WebSphere Commerce Version 7.0.0.4 Fix Pack
WebSphere Commerce Version 7.0.0.3 Fix Pack
WebSphere Commerce Version 7.0.0.5 Fix Pack
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack
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
This APAR now provides a means to turn off the associated functionality if desired. ------------------------------------------------------------- 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 ------------------------------------------------------------- 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
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