Teradata Installation and Configuration

Teradata Installation and Configuration Steps

  1. If you are upgrading from or reinstalling a previous version, follow the instructions in Upgrading from or Reinstalling a Previous Version.
  2. Install the in-database deployment package.
  3. Install the SAS Embedded Process support functions.
  4. If you plan to use SAS Model Manager with the SAS Scoring Accelerator for in-database scoring, perform the additional configuration tasks provided in Configurations for SAS Model Manager.
Note: If you are installing the SAS High-Performance Analytics environment, there are additional steps to be performed after you install the SAS Embedded Process. For more information, see SAS High-Performance Analytics Infrastructure: Installation and Configuration Guide.

Upgrading from or Reinstalling a Previous Version

To upgrade from or reinstall a previous version of the SAS Formats Library, the SAS Embedded Process, or both, follow these steps.
  1. Check the current installed version of the SAS formats library.
    How you do this depends on the version of the SAS formats library.
    • If a SAS 9.2 version of the formats library is currently installed, run this command:
      psh "rpm -q -a" | grep jazxfbrs
      If a previous version is installed, a result similar to this is displayed. The version number might be different.
      jazxfbrs-9.2-1.9
    • If a SAS 9.3 version of the formats library is currently installed, run this command:
      psh "rpm -q -a" | grep acc
      If a previous version is installed, a result similar to this is displayed. The version number might be different.
      accelterafmt-2.1-1
    If the library is not installed on the Teradata nodes, no output is displayed. You can continue with the installation steps in Installing the SAS Formats Library and the SAS Embedded Process.
  2. Run this command to check the current installed version of the SAS Embedded Process.
    psh "rpm -qa | grep tkindbsrv"
    If a previous version is installed, a result similar to this is displayed. The version number might be different.
    tkindbsrv-9.42_M1-2
    If the SAS Embedded Process is not installed on the Teradata nodes, no output is displayed. You can continue with the installation steps in Installing the SAS Formats Library and the SAS Embedded Process.
  3. If a version of the SAS formats library, the SAS Embedded Process, or both is being installed that has a name that is different from the library that was previously installed, then follow these steps. An example would be accelterafmt-3.1-1 replacing jazxfbrs-9.2-1.6 or tkindbsrv-9.42_M1-2 replacing tkindbsrv-9.35-1.
    1. If you are upgrading from or reinstalling the SAS Formats Library, shut down the Teradata database.
      tpareset -y -x shutdown_comment
      This step is required because an older version of the SAS formats library might be loaded in a currently running SAS query.
      Note: If you are upgrading or reinstalling only the SAS Embedded Process (tkindbsrv.rpm file), you do not need to shut down the database. You do need to shut down the SAS Embedded Process. For more information, see Controlling the SAS Embedded Process.
    2. Confirm that the database is shut down.
      pdestate -a
      DOWN/HARDSTOP is displayed if the database is shut down.
    3. Remove the old version before you install the updated version of the in-database deployment package.
      • To remove the package from all nodes concurrently, run this command:
        psh "rpm -e package-name"
        package-name is either jazxfbrs.9.version, accelterafmt-2.version, or tkindbsrv-9.35-version.
        For example, to remove jazxfbrs, run the command psh "rpm -e jazxfbrs-9.2–1.6".
      • To remove the package from each node, run this command on each node:
        rpm -e package-name
        package-name is either jazxfbrs.9.version, accelterafmt-2.version, or tkindbsrv-9.35-version.
  4. (Optional) To confirm removal of the package before installing the new package, run this command:
    psh "rpm -q package-name"
    package-name is either jazxfbrs.9.version, accelterafmt-2.version, or tkindbsrv-9.35-version.
    The SAS Formats Library or the SAS Embedded Process should not appear on any node.

Installing the SAS Formats Library and the SAS Embedded Process

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

  1. Locate the in-database deployment package files, accelterafmt-3.1-n.x86_64.rpm and tkindbsrv-9.42_M1-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. Each time you reinstall or upgrade, n is incremented by 1.
    The accelterafmt-3.1-n.x86_64.rpm file is located in the SAS-installation-directory/SASFormatsLibraryforTeradata/3.1/TeradataonLinux/ directory. The tkindbsrv-9.42_M1-n.x86_64.rpm file is located in the SAS-installation-directory/SASTKInDatabaseServer/9.4/TeradataonLinux/ directory.
  2. Put the package files on your Teradata database server in a location where it is both read and write accessible.
    The package files must be readable by the Teradata Parallel Upgrade Tool. You need to move this package file to the server machine in accordance with procedures used at your site.
Note: The SAS Embedded Process might require a later release of Teradata than function-based scoring. Please refer to the system requirements documentation.

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.
  1. Move the SAS Formats Library and the SAS Embedded Process packages to your server machine 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.
  2. Start the Teradata Parallel Upgrade Tool.
  3. Be sure to select all Teradata TPA nodes for installation, including Hot Stand-By nodes.
  4. 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.
  5. If the installation is successful, accelterfmt-3.1-n or tkindbsrv-9.42_M1-n is displayed. 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.
    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 tkindbsrv
  6. (Optional) Start the server so that all database processes can load the new version of the library and the SAS Embedded Process.
    /etc/init.d/tpa start
    Note: If you are upgrading from or reinstalling a previous version of the SAS Formats Library for Teradata, the database was shut down in preparation for this procedure, and no other database maintenance needs to be performed at this time, you should start the database.

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, contact your local Teradata account representative or the Teradata consultant supporting your SAS and Teradata integration activities.