70734 - Updates to sas_reindex_vac.sh for SAS® Viya® 3.5

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

./sas_reindex_vac.sh -s [ServiceName|ClusterName] -d [DatabaseName] -l [TableNameList]

Options:

   s - ServiceName or ClusterName,  for example, 'postgres' or 'cpspostgres'

   d - DatabaseName, for example, 'SharedServices' or 'postgres' or 'TenantDbName'

   l - TableName List, for example, "'table_name1'" or "'table_name1', 'table_name2'" or "'table_name1', 'table_name2', 'table_name3'"

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 postgres -d 'SharedServices' -l "'table_name1', 'table_name2'"

 ./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 postgres -l "'table_name1', 'table_name2'"

./sas_reindex_vac.sh -s cpspostgres -l "'table_name1', 'table_name2'"

Process all the tables on a given database

./sas_reindex_vac.sh -s postgres -d 'SharedServices'

./sas_reindex_vac.sh -s cpspostgres -d 'SharedServices'

Process all the tables on all accessible databases

./sas_reindex_vac.sh -s postgres

./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

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Type:	Problem Note
Priority:	high

Date Modified:	2024-04-17 09:55:03
Date Created:	2024-03-29 11:39:44

Support

Problem Note 70734: Updates to sas_reindex_vac.sh for SAS® Viya® 3.5

Usage

Operating System and Release Information