Skip navigation FileNet logo
Glossary  |  Help Directory  
  Help for vwlog
  Search
Process Reference  
vwlog
Coalescing the Statistics Database tables
Displaying event logging records on the screen
Copying event logging records to a file
Purging data from the event logging table
Purging data from the Statistics table

 

   

Purging data from the event logging table

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

  • The -L parameter purges the event log records.
  • The -D parameter purges tracker work items associated with completed workflows. You can use the -D option by itself or with the -L option.

CAUTION Removing work items via the -D parameter requires the existence of the associated event log termination record. The vwlog utility cannot delete the tracker work items if you have previously purged all event log records, including the termination records, via the -L parameter. To delete event log records while leaving the termination information, use the -L -i parameters together.

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 the Process Analyzer. By default, vwlog bypasses these records. If a Process Analyzer has not been configured, this parameter has no effect.

-T

Use this 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.

For example:

vwlog -r 7 -L -D

removes all event log records and tracker records from isolated region 7 of the database.