Troubleshooting: Settings for DynaCacheInvalidation URL
When executing the DynaCacheInvalidation task as a URL, the task settings should be tuned for your specific WebSphere Commerce environment.
Problem
In setting up the scheduled job for the DynaCacheInvalidation task, several items should be considered:- Determining the job number (SCSJOBNBR) for the DynaCacheInvalidation scheduled task.
- Setting an execute time for the DynaCacheInvalidation scheduled task.
- Ensuring the DynaCacheInvalidation task is run according to the schedule defined.
Solution
Review the following information for setting details:- Determining the job number (SCSJOBNBR) for the DynaCacheInvalidation
scheduled task.
- Check the SCHCONFIG table
using the following query:
If multiple results are returned, check theselect * from schconfig where sccpathinfo like 'Dyna%'
SCCQUERY
column for the lateststartTime
andstartTimeNanos
. Also check theSCCACTIVE
column (A for Active). TheSCHCONFIG.SCCJOBREFNUM
matches theSCHACTIVE.SCSJOBNBR
.
- Check the SCHCONFIG table
using the following query:
- Setting an execute time for the DynaCacheInvalidation scheduled
task.
- Only one update to SCHACTIVE table
is required. As an example, use the query:
This query causes the scheduled job (SCSJOBNBR) to run when the scheduler is activated. The activation of the scheduler is set in the instance_name.xml file.update schactive set scsprefstart=CURRENT_TIMESTAMP where scsjobnbr=18172
- Only one update to SCHACTIVE table
is required. As an example, use the query:
- Ensuring the DynaCacheInvalidation task is run according to the
schedule defined.
- After updating the
SCHACTIVE.SCSPREFSTART
the DynaCacheInvalidation task job runs as defined in the schedule. For example. if the schedule defines the job to run every 10 minutes, then using theCURRENT_TIMESTAMP
, sets the next scheduled job to be 10 minutes from the time it executed. Starting at 3:00 PM the job would run at 3:10 PM, 3:20 PM and continue every 10 minutes.Alternatively, if the current time is 3:00 PM, you can set the time for a past time (1:10 PM). This causes the job to execute immediately and updates the scheduled job to run at 10 minute intervals from the time it executed.
- If
SCHACTIVE.SCSPREFSTART
is updated while the job is running no problems are encountered. The scheduler only looks for jobs that are not running and attempts to execute the jobs if the time and status is correct.
- After updating the