JR48703: CMVC 232912 - This fix is to minimize the number of SQL queries executed by marketing activities

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• When loading e-Marketing Spots and activities into the marketing
  cache, and when activating activities, a large number of
  queries are done against the database. This can result in slow
  system performance.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 using Management Center
  Marketing
  
  PROBLEM ABSTRACT:
  Slow performance when loading e-Marketing Spots and activities
  into the marketing cache
  
  BUSINESS IMPACT:
  System performance can be affected when there are a large number
  of e-Marketing Spots or activities
  
  RECOMMENDATION:
  

Problem conclusion

• The marketing code was improved to reduce the number of database
   queries used when loading e-Marketing Spots and activities into
   the marketing cache.
  -------------------------------------------------------------
  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 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