Note: The update_index_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.
This script should only be used if Sybase compatibility mode is NOT enabled in your database. If Sybase compatibility mode IS enabled in your database, you should use the script update_stats instead.
If you are unsure whether Sybase compatibility mode is enabled or not, please raise a case with Capita Support. Alternatively, if you are comfortable with using isql, you can find out by starting an isql session and running the command sp_compatmode. This will return either Compatibility mode is enabled or Compatibility mode is not enabled.
An example crontab line for automating update_index_stats is shown below:
30 8 * * 0 /bin/su - talis -c "update_index_stats prod_talis
>/var/tmp/update_index_stats.log" 2>/var/tmp/update_index_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_index_stats prod_talis
Several tables may be specified as arguments to the script if required; as follows:
update_index_stats prod_talis <table1> <table2> <table>
For example:
update_index_stats prod_talis BORROWER
If also re-directing output to a log file you might type in:
update_index_stats prod_talis > /scratch/update_index_stats.report
Note:
This script is held in /usr/opt/blcmp/talis/bin .