About purging activity-related workflow data

Each time PolicyCenter creates an activity, it adds that activity to the following tables:

• pc_Workflow
• pc_WorkflowLog
• pc_WorkflowWorkItem

After a user completes the activity, PolicyCenter sets the workflow status to completed. PolicyCenter never uses the pc_Workflow, pc_WorkflowLog and pc_WorkflowWorkItem table entry for that activity again. These tables grow in size over time and can adversely affect performance and waste disk space. Excessive records in these tables also negatively impacts the performance of the database upgrade.

Guidewire recommends that you periodically purge workflows, workflow log entries, and workflow items for completed activities to improve database upgrade and operational performance and to recover disk space.

See also

• Purging workflow data
• Purging workflow log data
• Purging work item set data