This SAS KB article describes how to update the SAS Fraud Management database host name.
Complete the following steps to update the SAS Fraud Management database host name:
- Stop all SAS Fraud Management processes on the host where you want to make updates to the SAS® Fraud Management database host name.
- Take backups of the /<SASHome> and /<SASConfig> directories on the above SAS Fraud Management servers.
- Run the following command as the sas-install user to list all files with references to the older database host name.
find /<SASConfig>/Lev1/ -type f ! -name "*.log" ! -name "*.sas7bdat" ! -name "*.html" | xargs grep -li "<old database hostname>" | sort | uniq
Note: Replace the bolded sections of the command with the actual SAS configuration directory and the old database host name and IP address, respectively.
- The above command returns the absolute path of files. Open each file in the vi/vim editor (or any other editor of your choice), and replace the old database host name with the new one.
- Execute this task. (That is, search for files with the older database host name and replace them with the new database host name on every SAS Fraud Management host.)
- Ensure that all files are updated with the new database host name.
- Start up all SAS Fraud Management services on all hosts by following standard practices.
Best Practice Tip: Always validate connectivity to the new database host name before you start any file updates to avoid downtime.