Deployed Components for In-Database Processing

Deployed Components for Aster nCluster

Components that are deployed to Aster nCluster for in-database processing are contained in a self-extracting TAR file (tkindbsrv-9.3-1_lax.sh). The TAR file is located in the SAS-install-directory/SASTKInDatabaseServer/9.3/AsternClusteronLinuxx64/ directory.
The SAS Embedded Process is the component that is deployed in Aster nCluster. The SAS Embedded Process contains run-time libraries, and other software that is installed on your Aster nCluster system. The SAS scoring files created in Aster nCluster accesses the routines within the run-time libraries.
In particular, the SAS System libraries and the SAS_SCORE() SQL/MR function are installed. The SAS Scoring Accelerator for Aster nCluster uses these libraries and SQL/MR function to run scoring models inside the database.
For more information about these components, see the installation and configuration instructions in the SAS In-Database Products: Administrator's Guide.

Deployed Components for DB2

Components that are deployed to DB2 for in-database processing are contained in a self-extracting TAR file (acceldb2fmt-2.1-1_*.sh). The TAR file is located in the SAS-install-directory/SASFormatsLibraryforDB2/2.1/DB2on<AIX | Linux64>/ directory.
The following components are deployed:
  • The SAS formats library. The library contains many formats that are available in Base SAS.
    After you install the SAS formats library, the SAS scoring model functions and the SAS_PUT() function created in DB2 can access the routines within its run-time library.
  • The binary files for the SAS_COMPILEUDF function.
    The%INDB2_PUBLISH_COMPILEUDF macro registers the SAS_COMPILEUDF function in the SASLIB schema of the DB2 database. The SAS_COMPILEUDF function compiles the scoring model source files in the DB2 database, links to the SAS formats library, and then copies the new object files to a specified location.
  • The binary files for the SAS_DELETEUDF function.
    The %INDB2_PUBLISH_DELETEUDF macro registers the SAS_DELETEUDF function in the SASLIB schema of the DB2 database. The SAS_DELETEUDF function removes existing object files.
For more information about these components, see the installation and configuration instructions in the SAS In-Database Products: Administrator's Guide.

Deployed Components for Greenplum

Components that are deployed to Greenplum for in-database processing are contained in a self-extracting TAR file (accelgplmfmt-2.1-1_lax.sh). The TAR file is located in the SAS-install-directory/SASFormatsLibraryforGreenplum/2.1/GreenplumonLinux64/ directory.
The following components are deployed:
  • The SAS formats library. The library contains many formats that are available in Base SAS.
    After you install the SAS formats library, the SAS scoring model functions created in Greenplum can access the routines within its run-time library.
  • The binary files for the SAS_COMPILEUDF function and other utility functions.
    The %INDGP_PUBLISH_COMPILEUDF macro registers the SAS_COMPILEUDF function and other utility functions in the database. The utility functions are called by the %INDGP_PUBLISH_MODEL scoring publishing macro.
For more information about these components, see the installation and configuration instructions in the SAS In-Database Products: Administrator's Guide.

Deployed Components for Netezza

Components that are deployed to Netezza for in-database processing are contained in a self-extracting TAR file (accelnetzfmt-2.1-1_lax.sh). The TAR file is located in the SAS-install-directory/SASFormatsLibraryforNetezza/2.1/Netezza32bitTwinFin/ directory.
The following components are deployed:
  • The SAS formats library. The library contains many formats that are available in Base SAS.
    The SAS formats library is published to the database as an object.
    After the %INDNZ_PUBLISH_JAZLIB macro publishes and registers the SAS formats library, the SAS scoring model functions and the SAS_PUT() function created in Netezza can access the routines within its run-time library.
  • The binary files for SAS_COMPILEUDF and other utility functions.
    The %INDNZ_PUBLISH_COMPILEUDFmacro creates the SAS_COMPILEUDF, SAS_DictionaryUDF, and SAS_HextToText functions that are needed to facilitate the publishing of the scoring models, the SAS_PUT() function, and user-defined formats.
The %INDNZ_PUBLISH_JAZLIB and %INDNZ_PUBLISH_COMPILEUDF macros are typically run by your system or database administrator.
For more information, see the SAS In-Database Products: Administrator's Guide.

Deployed Components for Teradata

Components that are deployed to Teradata for in-database processing are contained in an RPM file (accelterfmt-2.1-1.x86_64.rpm). The TAR file is located in the SAS-install-directory/SASFormatsLibraryforTeradata/2.1/TeradataonLinux/ directory.
The component that is deployed is the SAS formats library. The SAS formats library contains many of the formats that are available in Base SAS. After you install the SAS formats library, the SAS scoring model functions and the SAS_PUT() function created in Teradata can access the routines within its run-time library.
For more information about installing and configuring these components, see the SAS In-Database Products: Administrator's Guide.