IBM Support

Caching Custome tables

Technote (FAQ)


How to cache custome tables in Sterling Fullfillment suite?


Steps to make custom tables cacheable:
1) Identify the custom tables which can be grouped as configuration tables.
2) In file Extensions.xml, select those entities already identified from step 1) and add attributes Cacheable="true" EntityType="CONFIGURATION" for <Entity/> element. for example:
<Entity Cacheable="true" EntityType="CONFIGURATION" ApiNeeded="Y" AuditRequired="N" Description="" HasHistory="False" Prefix="WSI" TableName="WSM_TRANSIT_TIME" XMLName="TransitTime" >

Run dbverify.cmd tool to synchronized entity xml's and database. Run commands to re-build resources.jar and entities.jar
3) Navigate to file and add entries for tables already defined as "cacheable" using step 2) as
(a) yfs.yfs.dbcache.classes
eg: yfs.yfs.dbclassCache.WSM_TRANSIT_TIMEclass=com.yantra.shared.dbclasses.WSM_TRANSIT_TIMEDBCacheHome
(c) Enable caching for custom table
4) Re-start the server is necessary for changes to come into effect.

Steps to cross verify whether Cache is enabled or not:
Open up System Management Console to check if the above tables objects are under cached list of tables, as System management console --> Application Hosts --> Click on machine number --> Click on machine number under "Average Response Time for Application Servers in Group" --> under Cache info click on "Table level cache"

Document information

More support for: Sterling Selling and Fulfillment Suite
Data management - Data tracking

Software version: All

Operating system(s): Platform Independent

Software edition: All Editions

Reference #: 1599838

Modified date: 29 January 2015