Use the -L and -D parameters in vwlog to purge event log records and tracker work items:
CAUTION
NOTE After you run a full backup of the Process Engine (PE) database and prune the event logs, all region backups prior to this are invalid; you can no longer use them. If you want the ability to recover a region, you must back up the region after purging data from the event log table.
The following parameters apply to the -L option:
Parameters -L option |
Use |
---|---|
-s, -S, -e, -E |
Use these parameters to specify an interval for removing the event log database records (the vwlog -L option). Use the -s or -S parameter to specify the start time for the interval. The -s parameter defines the start time as <Time>, and the -S parameter defines the start time as the current time - <Time> (in hours). Use the -e or -E parameter to specify the end time for the interval. The -e parameter defines the end time as <Time>, and the -E parameter defines the end time as the current time - <Time> (in hours). |
-r |
Use this parameter to specify the isolated region(s) to process. |
-b |
Use this parameter to specify a block size. The default block size is 100 records; if a block size of less than 3 records is specified, vwlog forces the block size to 3 records without returning a message. |
-P | Use this parameter to force deletion of log records that have not yet been sent to PA. By default, vwlog bypasses these records. If a PA server has not been configured, this parameter has no effect. |
-T |
Use the -T parameter to delete log records associated with completed workflows. Log records associated with workflows still in progress are not deleted. |
-i |
Use this parameter to ignore log records associated with completed workflows. You must use this option when you want to delete log records (the -L option) before you delete the associated tracker records using the -D parameter. |
-Y |
Use this parameter to specify the username and password in the format <username>+<password>. The user must belong to the Process Engine Administrator Group. |
-t | Use the -t <event-log-name> parameter to specific the event log to be processed. |
For example:
vwlog -r 7 -L -D -Y Administrator+password
removes all event log records in the default event log and tracker records from isolated region 7 of the database.