In-Database Deployment Package for Aster nCluster

Prerequisites

SAS Foundation and the SAS/ACCESS Interface to Aster nCluster must be installed before you install and configure the in-database deployment package for Aster nCluster.

Overview of the In-Database Deployment Package for Aster nCluster

The information in this section describes how to load and configure the in-database deployment package for Aster nCluster.

The in-database deployment package for Aster nCluster enables you to use the scoring publishing macro (%INDAC_PUBLISH_MODEL) to create scoring files inside the database.

The in-database deployment package for Aster nCluster contains macros, run-time libraries, and other software that is installed on your Aster nCluster system.

Installing the In-Database Deployment Package Binary Files for Aster nCluster

The in-database deployment package binary files for Aster nCluster are contained in a self-extracting tar file named accelastrfmt.sh.

To install the in-database deployment package binary files for Aster nCluster, you need root privileges for the queen node. Once you are logged in to the queen node as root, you need to create a directory to put accelastrfmt.sh in, execute accelastrfmt.sh, then install the SAS_SCORE function.

Enter these commands to install the SAS System Libraries and the binary files:

Log in to the queen node.
```
ssh -l root name-or-ip-of-queen-node
```
Move to the parent of the partner directory.

The directories are different between the Gentoo and Unbuntu installations.
For Gentoo, use the following command:
```
cd /cluster/common/workerimage/home/beehive/
```
For Unbuntu, use the following command:
```
cd /home/beehive/
```
Create a partner directory if it does not already exist.
```
mkdir partner
```
Move to the partner directory.
```
cd partner
```
Use Secure File Transfer Protocol (SFTP) to transfer the self-extracting TAR file to the partner directory.
1. Using a method of your choice, start the SFTP client.
  
  Here is an example of starting SFTP from a command line.
  
  For Gentoo, you could use the following command.
  sftp root@name-or-ip-of-queen-node: /cluster/common/workerimage/ home/beehive/partner
  
  For Unbuntu, you could use the following command.
  sftp root@name-or-ip-of-queen-node:/home/beehive/partner
2. For both Gentoo and Unbuntu, enter this command from the SFTP prompt to transfer the TAR file.
  
  put accelastrfmt.sh
(Optional) If your SFTP client does not copy the executable attribute from the client machine to the server, change the execute permission on the TAR file.
```
chmod +x accelastrfmt.sh
```
Create a directory named SAS and unpack the TAR file into it.
```
./accelastrfmt.sh
```
Note: If a SAS directory already exists in the partner directory, you can use rm —rf SAS to remove it and any previous versions of the in-database deployment package for Aster nCluster.
Remove the TAR file from the partner directory.
```
rm accelastrfmt.sh
```
Change to the directory where SAS is installed.
```
cd SAS/SASAcceleratorForAster/9.2-3.1/sasexe
```
Enter the following commands to install the SAS_SCORE and other SQL/MR functions.
1. Start the ACT tool.
  /home/beehive/clients/act -U db_superuser -w db_superuser-password -d database-to-install-sas_score-into
2. (Optional) If this is not the first time you have installed the in-database deployment package for Aster nCluster, it is recommended that you remove the existing SQL/MR functions before installing the new ones.
  \remove sas_score.tk.so
3. Enter the following command to install the new SQL/MR functions.
  \install sas_score.tk.so
Exit the ACT tool.
```
\q
```

Aster nCluster Permissions

The person who installs the in-database deployment package binary files in Aster nCluster needs root privileges for the queen node. This permission is most likely, but not necessarily, needed by the Aster nCluster system administrator.

No permissions are needed by the person who runs the scoring publishing macros, because all functions and files are published to the PUBLIC schema.

Documentation for Publishing SAS Scoring Models in Aster nCluster

For information about how to publish SAS scoring models, see the SAS Scoring Accelerator for Aster nCluster User's Guide located at http://support.sas.com/documentation/onlinedoc/scoracclast/index.html