Purge data from the statistics table

Use the -X parameter in vwlog to remove statistics database records.

The following parameters apply to the -X option:

Parameter
-X
Use

-r

Use this parameter to specify the isolated regionss 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.

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

For example:

vwlog -r 7 -X -Y Administrator+password

removes all statistics records from isolated region 7 of the database.

You can combine the -X option with the -L and -D options. For example:

vwlog -r 7 -L -D -X

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