Use the -C option in vwlog to coalesce the workflow roster and work queue statistics database tables. When you coalesce the database tables, vwlog divides the statistics records into equal groupings of records, or blocks. Each block is then distilled into a single record in the database. The last record is left in the database, as a reference point for future statistical data.
NOTE Statistics coalescing removes statistical data from the database, which affects the accuracy of sampling and event summation statistics. For more information, see About workflow statistics.
The following parameters apply to the -C option:
Parameter | Use |
---|---|
-s, -S, -e, -E |
Use these parameters to specify an interval for statistics database
coalescing: |
-r |
Use this parameter to specify the isolated region(s) to process. To specify more than one isolated region, separate the regions by commas. |
-v |
Use this parameter to specify verbose output to the stdout device. |
-b |
Use this parameter to specify a block size for statistics coalescing. The default block size is100 records; if a block size of less than 3 records is specified, vwlog will force the block size to 3 records without returning a message. |
-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. |
For example:
vwlog -r 7 -v -C -b 50 -Y Administrator+password
coalesces the workflow roster and work queue statistics tables from
isolated region 7, with a block size of 50 records. The vwlog utility
displays its activity to the stdout device (usually the screen).
The amount of reduction in database table size is dependent on the block size, as well as the number of classes in your isolated region. The maximum resulting size of the statistics database tables is m(n+1) records, where n is the number of blocks and m is the number of workflow rosters and work queues.