Fixes are available
APAR status
Closed as program error.
Error description
StoreDataBean.getSalesCatalogs method uses an access bean finder query that the data cache does not cache. This causes a SQL query to run thousands of times per hour.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce versions 6 and 7 customers who use the StoreDataBean.getSalesCatalogs method. PROBLEM ABSTRACT: A SQL query runs thousands of times resulting in high CPU usage BUSINESS IMPACT: SQL query causes unnecessary high CPU usage. RECOMMENDATION:
Problem conclusion
The StoreDataBean.getSalesCatalogs method is changed to cache the query in the object cache with JNDI name services/cache/WCSystemDistributedMapCache using the com.ibm.commerce.catalog.objsrc.CatalogCache logical data cache.
Temporary fix
Comments
APAR Information
APAR number
IV78215
Reported component name
WC BUS EDITION
Reported component ID
5724I3801
Reported release
600
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-10-21
Closed date
2015-11-11
Last modified date
2015-11-11
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
5724I3801
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:
11 November 2015