IBM Support

Technote (FAQ)


Question

How to cache custome tables in Sterling Fullfillment suite?

Answer

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:
<DBSchema>
<Entities>
<Entity Cacheable="true" EntityType="CONFIGURATION" ApiNeeded="Y" AuditRequired="N" Description="" HasHistory="False" Prefix="WSI" TableName="WSM_TRANSIT_TIME" XMLName="TransitTime" >
</Entity>
</Entities>
</DBSchema>

Run dbverify.cmd tool to synchronized entity xml's and database. Run commands to re-build resources.jar and entities.jar
3) Navigate to customer_override.properties 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
(b) yfs.yfs.dbcache.com.yantra.yfs.dbclasses.tablename.DBCacheHome=limit.rows
eg: yfs.yfs.dbcache.com.yantra.yfs.dbclasses.YFS_CustomerDBCacheHome=limit.rows=225000,
(c) Enable caching for custom table
yfs.yfs.dbcache.com.yantra.yfs.dbclasses.YFS_CustomerDBCacheHome.enabled=true
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: 2015-01-29