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:
      select * from schconfig where sccpathinfo like 'Dyna%' 
      If multiple results are returned, check the SCCQUERY column for the latest startTime and startTimeNanos. Also check the SCCACTIVE column (A for Active). The SCHCONFIG.SCCJOBREFNUM matches the SCHACTIVE.SCSJOBNBR.
  • Setting an execute time for the DynaCacheInvalidation scheduled task.
    • Only one update to SCHACTIVE table is required. As an example, use the query:
      update schactive set scsprefstart=CURRENT_TIMESTAMP where scsjobnbr=18172 
      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.
  • 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 the CURRENT_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.