Note: The update_stats script ensures that the information contained in the statistics pages of the tables is kept up to date. This prevents long response times and consequent degradation of system performance. It is strongly recommended that the script is run through the cron on a weekly basis, with the output directed into a log file. It should take less than two hours to complete.
An example crontab line for automating update_stats is shown below:
30 8 * * 0 /bin/su - talis -c "update_stats prod_talis
>/var/tmp/update_stats.log" 2>/var/tmp/update_stats.err
Table names can be entered as arguments to the script if desired. If no table name is entered, statistics pages will be updated for all tables (including those which have not changed or which have been updated to only a minimum extent). This may be what is required; if so, table names need not be entered, and the command will be:
update_stats prod_talis
Several tables may be specified as arguments to the script if required; as follows:
update_stats prod_talis <table1> <table2> <table>
For example:
update_stats prod_talis BORROWER
If also re-directing output to a log file you might type in:
update_stats prod_talis > /scratch/update_stats.report
Note:
This script is held in /usr/opt/blcmp/talis/bin .