APAR status
Closed as program error.
Error description
After installing or enabling Feature Pack 1 for IBM WebSphere Commerce V7, performance may be affected when adding a public promotion code to an order. This is due to a new table, PX_CDUSAGE, is added in Feature Pack 1 which keeps track of the promotion codes used against orders. This table can grow very large and cause queries against it to take a long time.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce V7 users with Feature Pack 1 or Feature Pack 2 enabled. PROBLEM ABSTRACT: Improve WebSphere Commerce performance when querying the PX_CDUSAGE table for public promotion codes BUSINESS IMPACT: High if problem occurs. This issue may not occur for all customers unless PX_CDUSAGE is large. RECOMMENDATION:
Problem conclusion
The queries against this table in the database were improved to increase WebSphere Commerce performance. ------------------------------------------------------------- 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
JR39173
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
2011-03-18
Closed date
2011-05-02
Last modified date
2011-05-02
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:
02 May 2011