Removing SAS Data Quality Accelerator from the Teradata Database

Before you can upgrade, re-install, or permanently remove SAS Data Quality Accelerator for Teradata or the SAS Embedded Process, you must remove any existing data quality stored procedures from the Teradata database. The stored procedures are removed from the Teradata database by using the dq_uninstall.sh script. For more information about this script, see Using the dq_uninstall.sh Script.

If you are upgrading from SAS Data Quality Accelerator 2.7 for Teradata, you will need to execute the following commands after running the dq_uninstall.sh script. The first command locates the SAS Data Quality Accelerator package sepdqacctera on the Teradata database server. Specify the output of the first command as the package-name in the second command.

psh "rpm –q –a" | grep sepdqacctera
psh "rpm -e package-name"

The psh command executes the commands in parallel on all Teradata database nodes.

It is not necessary to remove the QKB when upgrading or re-installing software. QKB deployment steps automatically overwrite an older version of the QKB when you install a new one. For information to replace the QKB, see Updating and Customizing a QKB and Obtaining a QKB.

When permanently removing SAS Data Quality Accelerator for Teradata from the Teradata database server, follow whatever procedure is appropriate at your site for removing the QKB. The Teradata administrator also needs to remove data quality authorizations from the Teradata database in accordance with site procedures.

The accelerator provides the dq_uninstall.sh shell script for removing the data quality stored procedures from the Teradata database. The dq_uninstall.sh script is located in the /opt/SAS/SASTKInDatabaseServerforTeradata/12.00000/install/pgm directory of the Teradata database server.

The dq_uninstall.sh script requires modification before it can be run. The Teradata administrator must edit the shell script to specify the site-specific Teradata server name and DBC user logon credentials for the DBC_PASS=, DBC_SRVR=, and DBC_USER= variables.

Here is the syntax for executing dq_uninstall.sh:

./dq_uninstall.sh <-l log-path>

Running dq_uninstall.sh disables the SAS Data Quality Accelerator for Teradata functionality and removes the data quality stored procedures from the database.