JR53622: Promotion Agenda Builder performance may not be optimal

APAR status

• Closed as program error.

Error description

• Promotion Agenda Builder performance may not be optimal due to a
  missing database index.
  
  The absence of the index may cause SQL being executed against
  the database to consume a longer time than it needs to.
  

Local fix

• Manually create the index definition described here:
  <http://www-01.ibm.com/support/knowledgecenter/SSZLC2_7.0.0/com.
  ibm.commerce.admin.doc/refs/rprpromoagendabuildconsiderations.ht
  m?lang=en>
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 who use the Promotion Agenda
  Builder.
  
  PROBLEM ABSTRACT:
  Promotion Agenda Builder performance may not be optimal
  
  BUSINESS IMPACT:
  Shoppers might see a slow-down when adding items to their cart
  or checking out depending on site traffic.
  
  RECOMMENDATION:
  

Problem conclusion

• Provided sample index creation DDL.  See documentation for
  location information for the sample.
  

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