Configuring the number of threads for statistics generation

Note: This topic is relevant only if using DBStats batch processing to manage the collection of database statistics.

PolicyCenter uses the work queue mechanism for statistics generation. You can therefore configure work queue and worker attributes for statistics generation in the work-queue.xml file. Access this file in Guidewire Studio at configuration > config > workqueue. Set parameters for the work queue with workQueueClass set to com.guidewire.pl.system.database.dbstatistics.DBStatisticsWorkItemWorkQueue. For example:

<work-queue
   workQueueClass="com.guidewire.pl.system.database.dbstatistics.DBStatisticsWorkItemWorkQueue" 
   progressinterval="86400000">
   <worker instances="5" batchsize="10"/>
</work-queue>

In this configuration, the statistics generation work queue uses five worker threads and each worker checks out ten work items at a time.

If you edit work-queue.xml, you must rebuild and redeploy PolicyCenter.