Problem Note 70734: Updates to sas_reindex_vac.sh for SAS® Viya® 3.5
 |  |  |  |  |
SAS Viya 3.5 provides a utility script to re-index and vacuum each table in the SAS® Infrastructure Data Server databases. It is recommended to run this script during maintenance cycles to prevent long locks on tables.
An issue was identified where certain locks on tables were not able to be bypassed, and the script would never finish.
Applying this hot fix can help prevent the script from hanging. In addition, the hot fix adds more options to the script to allow more detail for the database and tables to specifically target.
Usage
Note: Make sure that the TableName is enclosed within single quotation marks and then enclosed within double quotation marks. Multiple TableNames are comma separated.
Here are some examples:
Process a list of tables on a given database
./sas_reindex_vac.sh -s cpspostgres -d 'SharedServices' -l "'table_name1', 'table_name2'"
Process a list of tables on all accessible databases
./sas_reindex_vac.sh -s cpspostgres -l "'table_name1', 'table_name2'"
Process all the tables on a given database
./sas_reindex_vac.sh -s cpspostgres -d 'SharedServices'
Process all the tables on all accessible databases
./sas_reindex_vac.sh -s cpspostgres
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya 3.x | Linux for x64 | 3.5 | 3.5 | Viya 3.5 | Viya 3.5 |