High CPU usage when scheduled ExperimentCheckExpiry command runs

Technote (troubleshooting) Problem(Abstract) You notice high CPU usage and your server seems to be performing slow when the ExperimentCheckExpiry command runs. Also, your database contains a large number of experiments (for example: over 10,000). By default, the ExperimentCheckExpiry command is scheduled to run every five minutes to check whether experiments have expired or not. This toggles the status of experiments to active or inactive.

Cause

The ExperimentCheckExpiry run time is longer than the default value of 5 minutes. This can occur when a large number of experiments exist in the system.

Resolving the problem

Modify the time interval to a longer time (for example, 30 minutes). Otherwise, the system will always be busy processing the job. In order to change the time interval for the job, run the following SQL statement: update SCHCONFIG set SCCINTERVAL = 1800 where SCCPATHINFO = 'ExperimentCheckExpiry' See the Expirements considerations information center for more information on the setting.

Cross Reference information

Segment	Product	Component	Platform	Version	Edition
Commerce	WebSphere Commerce Business Edition	Performance	AIX, i5/OS, Linux, Solaris, Windows	5.6, 5.6.1, 5.6.1.1, 5.6.1.2, 5.6.1.3

   

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21221748