Buildstats utility
The buildstats utility updates database statistics.
When you install the LikeMinds utilities, the installer sets buildstats to run once a day, at 3:30 a.m. This is because the best time to run buildstats is daily, at a time when the LikeMinds server receives relatively little use. The buildstats utility connects directly to the LikeMinds database and processes the transactional or ratings data that is constantly being written to the LikeMinds database. Because this utility does not consume many resources, it is typically installed on the same machine as the LikeMinds server. The buildstats utility performs a number of data analysis functions on the information in the LikeMinds database and persistently writes out the results into the LikeMinds schema. By default, buildstats analyzes both the ratings and the transactional data.
For transactional data, buildstats writes to these fields in Lps_User_Trx:
- value
- Data value associated with the transaction.
- adj_count
- Adjusted count of transactions. If a new activity is recorded in the transaction table, this value increases. It may diminish over time.
Configure when the buildstats utility runs
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.