Installing the SAS Formats Library and the SAS Embedded Process :: SAS(R) 9.4 In-Database Products: Administrator's Guide, Seventh Edition

Moving the SAS Formats Library and the SAS Embedded Process Packages to the Server Machine

Locate the SAS Formats Library for Teradata deployment package file, accelterafmt-3.1-n.x86_64.rpm. n is a number that indicates the latest version of the file. If this is the initial installation, n has a value of 1.

The accelterafmt-3.1-n.x86_64.rpm file is located in the SAS-installation-directory/SASFormatsLibraryforTeradata/3.1/TeradataonLinux/ directory.

Note: The SAS formats library is not required by the SAS Data Quality Accelerator for Teradata.
Move the package file to your Teradata database server in a location where it is both Read and Write accessible. You need to move this package file to the server machine in accordance with procedures used at your site. Here is an example using secure copy.
```
scp accelterafmt-3.1-n.x86_64.rpm root@teramach1:/sasdir/18MAR15
```
This package file is readable by the Teradata Parallel Upgrade Tool.
Locate the SAS Embedded Process deployment package file, sepcoretera-9.43000-n.x86_64.rpm. n is a number that indicates the latest version of the file. Follow these steps :
1. Navigate to the YourSASDepot/standalone_installs directory. This directory was created when you created your SAS Software Depot.
2. Locate the en_sasexe.zip file. The en_sasexe.zip file is located in the YourSASDepot/ standalone_installs/SAS_Core_Embedded_Process_Package_for_Teradata/9_43/Teradata_on_Linux/ directory.
  
  The sepcoretera-9.43000-n.x86_64.rpm file is included in this ZIP file.
3. Copy the en_sasexe.zip file to a temporary directory on the server machine. You need to move this package file to the server machine in accordance with procedures used at your site. Here is an example using secure copy.
  scp en_sasexe.zip root@teramach1:/SomeTempDir
4. Log on to the cluster and navigate to the temporary directory in Step 3c.
5. 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 sepcoretera-9.43000-n.x86_64.rpm should be in the /SomeTempDir/sasexe directory.
Copy the sepcoretera-9.43000-n.x86_64.rpm file to the same location on the server as the accelterafmt-3.1-n.x86_64.rpm file in Step 2.
You need to move this package file to the server machine in accordance with procedures used at your site. Here is an example using secure copy.
```
scp sepcoretera-9.43000-n.x86_64.rpm root@teramach1:/sasdir/18MAR15
```
This package file is readable by the Teradata Parallel Upgrade Tool.

Installing the SAS Formats Library and the SAS Embedded Process with the Teradata Parallel Upgrade Tool

This installation should be performed by a Teradata systems administrator in collaboration with Teradata Customer Services. A Teradata Change Control is required when a package is added to the Teradata server. Teradata Customer Services has developed change control procedures for installing the SAS in-database deployment package.

The steps assume full knowledge of the Teradata Parallel Upgrade Tool and your environment. For more information about using the Teradata Parallel Upgrade Tool, see theParallel Upgrade Tool (PUT) Reference which is at the Teradata Online Publications site, located at http://www.info.teradata.com/GenSrch/eOnLine-Srch.cfm. On this page, search for “Parallel Upgrade Tool” and download the appropriate document for your system.

The following steps explain the basic steps to install the SAS formats library package by using the Teradata Parallel Upgrade Tool.

Note: The Teradata Parallel Upgrade Tool prompts are subject to change as Teradata enhances its software.

Locate the SAS Formats Library and the SAS Embedded Process packages on your server machine. They must be in a location where they can be accessed from at least one of the Teradata nodes. For more information, see Moving the SAS Formats Library and the SAS Embedded Process Packages to the Server Machine.
Start the Teradata Parallel Upgrade Tool.
Be sure to select all Teradata TPA nodes for installation, including Hot Stand-By nodes.
If Teradata Version Migration and Fallback (VM&F) is installed, you might be prompted whether to use VM&F or not. If you are prompted, choose Non-VM&F installation.
If the installation is successful, accelterfmt-3.1-n or sepcoretera-9.43000-n.x86_64 is displayed. n is a number that indicates the latest version of the file.
Alternatively, you can manually verify that the installation is successful by running these commands from the shell prompt.
```
psh "rpm -q -a" | grep accelterafmt
psh "rpm -q -a" | grep sepcoretera
```

Installing the SAS Embedded Process Support Functions

The SAS Embedded Process support function package (sasepfunc) includes stored procedures that generate SQL to interface with the SAS Embedded Process and functions that load the SAS program and other run-time control information into shared memory. The SAS Embedded Process support functions setup script creates the SAS_SYSFNLIB database and the SAS Embedded Process interface fast path functions in TD_SYSFNLIB.

The SAS Embedded Process support function package is available from the Teradata Software Server. For access to the package that includes the installation instructions, contact your local Teradata account representative or the Teradata consultant supporting your SAS and Teradata integration activities.

CAUTION:

If you are using Teradata 15, you must drop the SAS_SYSFNLIB.SASEP_VERSION function to disable the Teradata Table Operator (SASTblOp). Otherwise, your output can contain missing rows or incorrect results.

To drop the function, enter the following command: drop function SAS_SYSFNLIB.SASEP_VERSION. This issue is fixed in Teradata maintenance release 15.00.04.

Note: If you are using SAS Data Quality Accelerator v2.7, you must contact your Teradata representative to get access to version 15.00-8 or higher of the SAS Embedded Process support functions (sasepfunc-15.00-8).