Database Consistency Check work queue

Code

DBConsistencyCheck

Categories

Schedulable

Implementation

Work queue

Non-exclusive

Yes

Schedule

Not scheduled

Class

DBConsistencyCheckWorkQueue.java

The Database Consistency Check work queue runs consistency checks on the PolicyCenter database.

Using PolicyCenter to execute database consistency checks

You use the Server Tools Info Pages > Consistency Checks screen to launch the database checks from PolicyCenter manually. From this screen, you can set a number of check parameters, including the following:
  • The tables or table groups to check, or, all tables
  • The specific types of database checks to run, or, all database check types
  • The number of work queue workers to use in running the database checks

You can also view past history reports of database checks from the Consistency Checks screen, as long as the historical report still exists in the database.

Using system tools to run database consistency checks

To manually execute the DBConsistencyCheck work queue, use the following system_tools command, adding the optional information on which checks to run against which tables:
  • system_tools -user user -password password -checkdbconsistency ...

Scheduling the database consistency checks

In the base configuration, Guidewire does not provide a default entry for the DBConsistencyCheck work queue in file scheduler-config.xml. You must add your own entry for this work queue if you want to automatically execute the work queue on a regular schedule. For example, you can add something similar to the following entry to file scheduler-config.xml, adjusting the schedule to meet your business needs.
<!-- Run DBConsistencyCheck on the first Sunday of every 6th month at 4PM -->
< ProcessSchedule process="DBConsistencyCheck">
  <CronSchedule month="/6" hours="16" dayofmonth="?" dayofweek="1#1"/>
</ProcessSchedule>

See also