JR49119: CMVC 233823 - Provide caching infrastructure to allow caching of STORETRANS queries.

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

• This iFix provides caching infrastructure to allow caching of
  STORETRANS queries.  It is a pre-requisite to iFix 3330, which
  uses the infrastructure to do the caching.
  

Local fix

Problem summary

•  USERS AFFECTED:
   WebSphere Commerce version 7 customers who need to install iFix
  3330.
  
   PROBLEM ABSTRACT:
   Provide caching infrastructure to allow caching of STORETRANS
  queries.
  
   BUSINESS IMPACT:
   This iFix enables iFix 3330 to improve performance by reducing
  the number of database queries to the STORETRANS table.
  
   RECOMMENDATION:
  

Problem conclusion

• This iFix provides code to allow caching of STORETRANS query
  results, and database triggers for cache invalidation.
  
   Additional database triggers for the STORETRANS table have been
  added to the following database scripts:
  
   schema/cloudscape/wcs.cacheivl.trigger.sql
   schema/db2/wcs.cacheivl.trigger.sql
   schema/oracle/wcs.cacheivl.trigger.sql
  
   Additional drop trigger instructions have been added to the
  following database scripts:
  
   schema/cloudscape/wcs.cacheivl.drop.trigger.sql
   schema/db2/wcs.cacheivl.drop.trigger.sql
   schema/oracle/wcs.cacheivl.drop.trigger.sql
  
   After installing this iFix, the additional triggers should be
  defined.  To do so, it is recommended to use the
  wcs.cacheivl.drop.trigger.sql database script to drop the
  existing triggers, and then to use the wcs.cacheivl.trigger.sql
  database script to (re-)define the database triggers, including
  the new STORETRANS triggers.
  
   Refer to the following WebSphere Commerce infocenter pages for
  more information:
   http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.c
  ommerce.admin.doc/tasks/tdcenabcdcinvalidtrigs.htm
   http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.c
  ommerce.admin.doc/tasks/tssprodadbtriggers.htm
   -------------------------------------------------------------
   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