How to update the SAS® Fraud Management database host name


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:

  1. Stop all SAS Fraud Management processes on the host where you want to make updates to the SAS® Fraud Management database host name.
  2. Take backups of the /<SASHome> and /<SASConfig> directories on the above SAS Fraud Management servers.
  3. 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.


  4. 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.
  5. 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.)
  6. Ensure that all files are updated with the new database host name.
  7. 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.