How to Enable/Disable DB cache in Sterling Selling and Fulfillment

Technote (FAQ)


Question

How does one Enable/Disable database level cache in Sterling Selling and Fulfillment ?

Answer

There may be instances when the cache for a particular table fills up the memory and could even lead to OOM issues. In such cases, DB cache can be disabled as below, it can be re-enabled if required.

The process is as below:
1. Navigate to Installation Directory > Properties folder.
2. Open the customer_overrides.properties file, set dbclassCache.<table_name>.enabled=false or dbclassCache.<table_name>.enabled=true
E.g. dbclassCache.YPM_PRICELIST_LINE.enabled=false
3. Save changes.
4. Ensure that the -DVendorFile parameter in the Application Startup Script contains the complete path to Server.properties file and not the Relative path.
5. Restart application server.

OR

Using the System Management Console.
1. Click on the server
2. In 'Average Response Time for servers in Group' section select the activity
3. In the 'Application Server Details' section Cache Info sub-section, select
'Table Level Cache'
4. Disable the Cache for the required table.
5. Repeat this across the JVMs/Servers.

Note: On the point of disabling the cache on pricelist line table, please ensure that the cache across all JVMs and servers are consistent. i.e. they must all either enabled or disabled for a given table. Having them set inconsistently across JVMs could cause unexpected behavior.


Cross reference information
Segment Product Component Platform Version Edition
Commerce Sterling Selling and Fulfillment Suite Catalog and Offer Management All 9.2, 9.1, 9.0, 8.5, 8.0 All Editions

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Sterling Selling and Fulfillment Suite
Performance

Software version:

8.0, 8.5, 9.0, 9.1, 9.2

Operating system(s):

All

Reference #:

1608088

Modified date:

2012-10-21

Translate my page

Machine Translation

Content navigation