SAP HANA Installation and Configuration :: SAS® 9.4 In-Database Products: Administrator's Guide, Eighth Edition

SAP Hana Installation and Configuration Steps

To install and configure SAP HANA, follow these steps:

Review the permissions required for installation.

For more information, see SAP HANA Permissions.
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.
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.
If you are upgrading from a previous version, follow the instructions in Upgrading from a Previous Version before installing the in-database deployment package.
Install the SAS Embedded Process.

For more information, see Installing the In-Database Deployment Package for SAP HANA.
Install the SASLINK Application Function Library.

For more information, see Installing the SASLINK AFL Plugins on the Appliance (SPS11).
Import the SAS_EP Stored Procedure.

For more information, see Importing the SAS_EP Stored Procedure.
Review the requirement for Auxiliary Wrapper Procedures.

For more information, see Auxiliary Wrapper Procedures (SPS11).
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. Run the StartupSASEP.sh script.
  ./StartupSASEP.sh
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 from a Previous Version

To upgrade from a previous version, follow these steps.

Log on to the SAP HANA system as root.

You can use su or sudo to become the root authority.
Navigate to the directory that contains the UninstallSASEPFiles.sh script.
```
cd /EPInstallDir/SASEPHome/bin
```
Note: You can find the location of EPInstallDir by using the following command:
```
ls -l /usr/local/bin/tkhnmain
```
Run the UninstallSASEPFiles.sh file.
```
./UninstallSASEPFiles.sh
```
This script stops the SAS Embedded Process on the server.

For versions prior to the fourth maintenance release of SAS 9.4 (November 2016), the script deletes the /SAS/SASTKInDatabaseServerForSAPHANA directory and all its contents.

For versions starting with the fourth maintenance release of SAS 9.4 (November 2016), the script deletes the /SASEPHome/bin directory and all its contents.
Reinstall the SAS Embedded Process.

For more information, see Installing the In-Database Deployment Package for SAP HANA.

Installing the In-Database Deployment Package for SAP HANA

Unzipping the In-Database Deployment Package for SAP HANA

The in-database deployment package for SAP HANA is contained in a self-extracting archive file named sepcorehana-12.00000-1.sh. This file is contained in a ZIP file that is put in your SAS Software Depot directory.

To unzip the in-database deployment package for SAP HANA, follow these steps:

Create a new temporary directory on your client machine such as /sasep. The new directory is referred to as EPZipDir throughout this section.
Navigate to the YourSASDepot/standalone_installs directory. This directory was created when you created your SAS Software Depot.
Locate the en_sasexe.zip file. The en_sasexe.zip file is located in the YourSASDepot/standalone_installs/SAS_Core_Embedded_Process_Package_for_SAP_HANA/12_0/SAP_HANA_on_Linux_x64 directory.

The sepcorehana-12.00000-1.sh file is included in this ZIP file.
Copy the en_sasexe.zip file to your EPZipDir temporary directory on the client machine.
```
cp en_sasexe.zip /EPZipDir
```
Navigate to your EPZipDir temporary directory and unzip en_sasexe.zip.

After the file is unzipped, a sasexe directory is created in the same location as the en_sasexe.zip file. The sepcorehana-12.00000-1.sh is in the /EPZipDir/sasexe directory.

Installing the In-Database Deployment Package for SAP HANA

The in-database deployment package for SAP HANA is contained in a self-extracting archive file named sepcorehana-12.00000-1.sh.

To install the self-extracting archive file, follow these steps:

Create a directory on the SAP HANA appliance. This directory is referred to as EPInstallDir throughout this section.
Using a method of your choice, transfer the sepcorehana-12.00000-1.sh file to the EPInstallDir on the SAP HANA appliance.
This example uses secure copy, and EPInstallDir is the location where you want to install the SAS Embedded Process.
```
scp sepcorehana-12.00000-1.sh username@hana:/EPInstallDir
```
Note: The sepcorehana-12.00000-1.sh file and the EPInstallDir directory require Read and Execute permissions for the database administrator.
After the sepcorehana-12.00000-1.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
```
Navigate to the directory where the self-extracting archive file was downloaded in Step 1.
```
cd /EPInstallDir
```
Change permissions on the file to enable you to execute the script.
```
chmod 755 -r sepcorehana-12.00000-1.sh
```
Use the following command at the UNIX prompt to unpack the self-extracting archive file:
```
./sepcorehana-12.00000-1.sh
```
After the script runs, a SASEPHome directory is created where the EP files are installed. The contents of the /EPInstallDir/SASEPHome directory should look similar to this. Directories and files of interest are shaded.
```
/EPInstallDir/SASEPHome/bin
/EPInstallDir/SASEPHome/bin/InstallSASEPFiles.sh
/EPInstallDir/SASEPHome/bin/ShowSASEPStatus.sh
/EPInstallDir/SASEPHome/bin/ShutdownSASEP.sh
/EPInstallDir/SASEPHome/bin/StartupSASEP.sh
/EPInstallDir/SASEPHome/bin/UninstallSASEPFiles.sh
/EPInstallDir/SASEPHome/misc
/EPInstallDir/SASEPHome/misc/SAS_EP_sas.com.tgz
/EPInstallDir/SASEPHome/misc/sas_saslink_installer.tgz
/EPInstallDir/SASEPHome/sasexe
/EPInstallDir/SASEPHome/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.
Navigate to the directory where the SAS Embedded Process script files were installed.
```
cd /EPInstallDir/SASEPHome/bin
```
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 that are generated during the installation process. Specify -quiet to suppress messages.