Purge data from the event logging table

Use the -L and -D parameters in vwlog to purge event log records and tracker work items:

CAUTION  

To purge events as part of the PA backup procedure

  1. Stop PE and PA.
  2. Back up the workflow and PA databases.
  3. When the workflow database backup is complete, restart PE. Do not restart PA.
  4. Purge events from the event log table.
  5. Start PA.

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.