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  

Take care when using the vwlog utility to purge an event log if multiple Process Analyzer servers are configured for the Process Engine. Each of the Process Analyzer's should have been started at least one time since the creation of the event log. Starting the Process Analyzer will cause it to register with the Process Engine for each of the event logs that exist. If this is not done then using vwlog to purge records from an event log may remove events that have not yet been processed by the Process Analyzer.

The following procedure should be performed before purging the event log.

  1. Start each of the Process Analyzer servers if they are stopped.
  2. Each Process Analyzer should display a "Synchronized event state with Process Engine" indicating that the Process Analyzer has registered with the Process Engine.
  3. The Process Analyzer servers may be stopped at this point if desired.

The same procedure applies when using the FileNet BPM CBE Adaptor for WebSphere Business Monitor and one or more Process Analyzer servers are also configured for the Process Engine. The CBE Adaptor should be started up before purgine the event log, if the event log was created since the CBE Adaptor was last started. Start the CBE Adaptor and let it run for several minutes. The CBE Adaptor will register with the Process Engine for each of the event logs and will write the following error to the log if there is a problem: "Unable to update PE database with CBE Adaptor event state." No message will be written on successful registration.

If only a single Process Analyzer is configured for the Process Engine (or FileNet BPM CBE Adaptor and no Process Analyzer), then the above steps are not necessary.

To purge events as part of the Process Analyzer backup procedure

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

NOTE After you run a full backup of the Process Engine 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 regions 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 Process Analyzer. By default, vwlog bypasses these records. If a Process Analyzer 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 user name and password in the format <user_name>+<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.