SAP HANA Installation and Configuration

Installing and Configuring SAP HANA

To install and configure SAP HANA, follow these steps:
  1. Review the permissions required for installation.
    For more information, see SAP HANA Permissions.
  2. Review the number of semaphore arrays configured for the SAP HANA server.
    It is recommended that the SAP HANA server that runs the SAS Embedded Process be configured with a minimum of 1024 to 2048 semaphore arrays. For more information, see Semaphore Requirements When Using the SAS Embedded Process for SAP HANA.
  3. Enable the SAP HANA Script Server process as SYSTEM in the SAP HANA Studio.
    The SAP HANA script server process must be enabled to run in the HANA instance. The script server process can be started while the SAP HANA database is already running.
    To start the Script Server, follow these steps:
    1. Open the Configuration tab page in the SAP HANA Studio.
    2. Expand the daemon.ini configuration file.
    3. Expand the scriptserver section.
    4. Change the instances parameter from 0 to 1 at the system level.
      A value of 1 indicates you have enabled the server.
    Note: For more information, see SAP Note 1650957.
  4. If you are upgrading from or reinstalling a previous release, follow the instructions in Upgrading or Reinstalling a Previous Version before installing the in-database deployment package.
  5. Install the SAS Embedded Process.
  6. Import the SAS_EP Stored Procedure.
    For more information, see Importing the SAS_EP Stored Procedure.
  7. Verify that the Auxiliary Wrapper Generator and Eraser Procedures are installed in the SAP HANA catalog.
  8. Start the SAS Embedded Process.
    1. Log on to the SAP HANA server as the database administrator or change the user to the database administrator.
      You can use one of these commands.
      su - SIDadm
      ssh SIDadm@server-name
    2. Navigate to the directory that contains the StartupSASEP.sh script.
      cd /EPInstallDir/StartupSASEP.sh
    3. Run the StartupSASEP.sh script.
      ./StartupSASEP.sh
  9. If you plan to use SAS Model Manager with the SAS Scoring Accelerator for in-database scoring, perform the additional configuration tasks provided in Configuring SAS Model Manager.
Note: If you are installing the SAS High-Performance Analytics environment, you must perform additional steps after you install the SAS Embedded Process. For more information, see SAS High-Performance Analytics Infrastructure: Installation and Configuration Guide.

Upgrading or Reinstalling a Previous Version

To upgrade or reinstall a previous version, follow these steps.
  1. Log on to the SAP HANA system as root.
    You can use su or sudo to become the root authority.
  2. Run the UninstallSASEPFiles.sh file.
    ./UninstallSASEPFiles.sh
    The UninstallSASEPFiles.sh file is in the /EPInstallDir/ where you copied the tkindbsrv-9.43-n_lax.sh self-extracting archive file.
    This script stops the SAS Embedded Process on the server. The script deletes the /SAS/SASTKInDatabaseServerForSAPHANA directory and all its contents.
    Note: You can find the location of EPInstallDir by using the following command:
    ls -l /usr/local/bin/tkhnmain
  3. Reinstall the SAS Embedded Process.

Installing the In-Database Deployment Package for SAP HANA

The SAS Embedded Process is contained in a self-extracting archive file. The self-extracting archive file is located in the SAS-installation-directory/SASTKInDatabaseServer/9.4/SAPHANAonLinuxx64/ directory.
To install the self-extracting archive file, follow these steps:
  1. Using a method of your choice, transfer the tkindbsrv-9.43-n_lax.sh file to the target SAS Embedded Process directory on the SAP HANA appliance.
    n is a number that indicates the latest version of the file. If this is the initial installation, n has a value of 1. Each time you reinstall or upgrade, n is incremented by 1.
    This example uses secure copy, and /EPInstallDir/ is the location where you want to install the SAS Embedded Process.
    scp tkindbsrv-9.43-n_lax.sh username@hana: /EPInstallDir/
    Note: The EPInstallDir directory requires Read and Execute permissions for the database administrator.
  2. After the tkindbsrv-9.43-n_lax.sh has been transferred, log on to the SAP HANA server as the “owner” of the SAS Embedded Process installation directory.
    ssh sas-owner@server-name
  3. Navigate to the directory where the self-extracting archive file was downloaded in Step 1.
    cd /EPInstallDir
  4. Use the following command at the UNIX prompt to unpack the self-extracting archive file.
    ./tkindbsrv-9.43-n_lax.sh
    Note: If you receive a “permissions denied” message, check the permissions on the tkindbsrv-9.43-n_lax.sh file. This file must have Execute permissions to run.
    After the script runs and the files are unpacked, the content of the target directories should look similar to these. Directories and files of interest are shaded.
    /EPInstallDir/afl_wrapper_eraser.sql
    /EPInstallDir/afl_wrapper_generator.sql
    /EPInstallDir/InstallSASEPFiles.sh
    /EPInstallDir/manifest
    /EPInstallDir/mit_unzip.log
    /EPInstallDir/saslink.lst
    /EPInstallDir/saslink_area.pkg
    /EPInstallDir/SAS
    /EPInstallDir/SAS_EP_sas.com.tgz
    /EPInstallDir/sas_saslink_installer.tgz
    /EPInstallDir/ShowSASEPStatus.sh
    /EPInstallDir/ShutdownSASEP.sh
    /EPInstallDir/StartupSASEP.sh
    /EPInstallDir/UninstallSASEPFiles.sh
    /EPInstallDir/tkindbsrv-9.43-n_lax.sh
    Note that a SAS directory is created where the EP files are installed. The contents of the /EPInstallDir/SAS/ directories should look similar to these.
    /EPInstallDir/SAS/SASTKInDatabaseServerForSAPHANA/9.43/admin
    /EPInstallDir/SAS/SASTKInDatabaseServerForSAPHANA/9.43/bin
    /EPInstallDir/SAS/SASTKInDatabaseServerForSAPHANA/9.43/logs
    /EPInstallDir/SAS/SASTKInDatabaseServerForSAPHANA/9.43/sasexe
    /EPInstallDir/SAS/SASTKInDatabaseServerForSAPHANA/9.43/utilities
    The InstallSASEPFiles.sh file installs the SAS Embedded Process. The next step explains how to run this file.
    The UninstallSASEPFiles.sh file uninstalls the SAS Embedded Process. The ShowSASEPStatus.sh file shows the status of the SAS Embedded Process on each instance. The StartupSASEP.sh and ShutdownSASEP.sh files enable you to manually start and stop the SAS Embedded Process. For more information about running these two files, see Controlling the SAS Embedded Process.
  5. Use the following command at the UNIX prompt to install the SAS Embedded Process.
    ./InstallSASEPFiles.sh
    Note: To execute this script you need root authority. Either use the su command to become the root or use the sudo command to execute this script to install the SAS Embedded Process.
    Note: -verbose is on by default and enables you to see all messages generated during the installation process. Specify -quiet to suppress messages.