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 archive file (tkindbsrv-9.31-1_lax.sh). The archive file is located in the SAS-install-directory/SASTKInDatabaseServer/9.31/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, the SAS_SCORE() SQL/MR function, and the SAS_PUT( ) SQL/MR function are installed. The SAS Scoring Accelerator for Aster nCluster uses these libraries and the SAS_SCORE() SQL/MR function to run scoring models inside the database. The SAS_PUT( ) function executes the format files in Aster nCluster. The SAS_PUT( ) function is deployed and stored in the NC_INSTALLED_FILES table under either the PUBLIC schema (4.5) or the specified schema (4.6).
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 two self-extracting archive files (acceldb2fmt-2.1-1_*.sh and tkindbsrv-9.31-1_*.sh). The first self-extracting archive file is located in the SAS-install-directory/SASFormatsLibraryForDB2/2.1/DB2on<AIX | Linux64>/ directory. The second self-extracting archive file is located in the SAS-install-directory/SASTKInDatabaseServer/9.31/DB2on<AIX | Linuxx64>/ directory.
  • The following components are deployed in the acceldb2fmt-2.1-1_*.sh file:
    • 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.
  • The SAS Embedded Process is deployed in the tkindbsrv-9.31-1_*.sh file. The SAS Embedded Process contains run-time libraries and other software that is installed on your DB2 system. The SAS scoring files created in DB2 accesses the routines within the run-time libraries.
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 archive file (accelgplmfmt-2.2-1_lax.sh). The archive file is located in the SAS-install-directory/SASFormatsLibraryforGreenplum/2.2/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 and the SAS_PUT( ) function 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 archive file (accelnetzfmt-2.1-1_lax.sh). The archive 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 Oracle

Components that are deployed to Oracle for in-database processing are contained in a self-extracting archive file (tkindbsrv-9.31-1_lax.sh). The archive file is located in the SAS-install-directory/SASTKInDatabaseServer/9.31/OracleDatabaseonLinuxx64/ directory.
The SAS Embedded Process is the component that is deployed in Oracle. The SAS Embedded Process contains run-time libraries and other software that is installed on your Oracle system. The SAS scoring files created in Oracle accesses the routines within the run-time libraries.
For more information about these components, see the installation and configuration instructions in 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 two RPM files (accelterfmt-2.1-1.x86_64.rpm and tkindbsrv-9.31-1.x86_64.rpm). The first RPM file is located in the SAS-install-directory/SASFormatsLibraryforTeradata/2.1/TeradataonLinux/ directory. The second RPM file is located in the SAS-install-directory/SASTKInDatabaseServer/9.31/TeradataonLinux/ directory.
The components that are deployed are the SAS formats library and the SAS Embedded Process.
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 can access the routines within its run-time library.
The SAS Embedded Process contains run-time libraries, and other software that is installed on your Teradata system. The SAS scoring files created in Teradata accesses the routines within the run-time libraries.
For more information about installing and configuring these components, see the SAS In-Database Products: Administrator's Guide.