Packing List for SPD Server Distribution

Directory Contents

Directory names in the packing list are subdirectories of your SPD Server host installation directory, whose path is represented by InstallDir/.
Note: InstallDir/ represents the root directory where SPD Server is installed.
The bin/ subdirectory contains the following binary files:
  • spdsnsrv is the SPD Server Name Server.
  • spdsservis the SPD Server host.
  • spdsbase is the LIBNAME proxy.
  • spdslog is the message logger.
  • spdsaud is the audit logger.
  • spdseng is the SQL Pass-Through engine.
  • ixutil is the data set index utility .
  • psmgr is the password file utility.
  • spdssnet is the ODBC, JDBC, and htmSQL gateway,
  • spdsperf is the Performance server.
    Note: spdsperf is not currently available for Linux on X64.
  • spdsls gives physical file listings for a LIBNAME domain.
  • spdsbkup performs full or incremental table backups.
  • spdsrstr restores full or incremental table backups
  • spqldrive is a stand-alone SQL Pass-Through driver.
  • spdsconv is the SPD Server 3.x to SPD Server 4.x table conversion utility.
  • spdsclean is the SPD Server disk cleanup utility.
  • dulibv3 is the SPD Server 3.x 64-bit version of the shared library used by spdsconv. The dulibv3 file is included only if your system previously supported SPD Server 3.x tables.
  • spdsbased is the debug version of spdsbase.
  • spdsengd is the debug version of spdseng.
  • spdsnlslib is the NLS library.
  • spdsnlslibd is the debug version of spdsnlslib.
  • spdsiotest is the stand alone SPD Server I/O scalability test.
The lib/ subdirectory contains the following SPD Server library files:
  • spdslib is the run-time library that performs SQL Pass-Through from C and C++ applications to SPD Server.
  • spds.dll is the application extension library that is accessed via the SAS ODBC Driver.
The samples/ directory contains the following files of interest:
  • auditraw.sasis used to read proxy audit files that do not include WHERE clause auditing.
  • auditwh.sasis used to read proxy audit files that include WHERE clause auditing.
  • audit.sql.sasis used to read an SQL audit file.
  • libnames.parm is a sample SPD Server host LIBNAME configuration file. Use with the -libnamefile option for the spdsserv command.
  • libsamp.parm is a more advanced example of a LIBNAME configuration file.
  • pwdb is a script to start the Password Manager executable.
  • spdsserv.parm is a sample SPD Server host parameter file. It sets the defaults for SPD Server options. Use this file with the -PARMFILE option for the spdsserv command.
  • rc.spds is a Bourne shell script to start a standard SPD Server environment.
  • rc.perf is a Bourne shell script to start a standard Performance Server.
  • killspds is a shell script that kills all processes for a UNIX user beginning with the letters spds. Do not use the killspds script if you have any processes running in UNIX that do not belong to SPD Server, but whose executable names begin with the letters spds.
  • killrc is a shell script that kills all processes related to a run of rc.spds. The killrc script is selective. It does not kill SPD Server processes that are not related to core processes started by rc.spds. Those core processes are initially started when rc.spds runs. The core processes are typically spdsnsrv, spdsserv, spdsbase, spdslog, and spdssnet, based on the rc.spds script the /samples directory.
  • doc_examples.sas contains sample SAS code that is used in the SAS Scalable Performance Data (SPD) Server 4.5: User's Guide documentation. This guide provides SPD Server LIBNAME and data set usage and syntax options.
  • verify.sas is a SAS installation verification job. You should run it after you install SPD Server.
  • spdsinst.sas demonstrates the simple use of WHERE clauses and WHERE planner output.
  • passthru.sas demonstrates SQL Pass-Through usage. It gives examples of simple, single-level Pass-Through and secondary libref and connection scenarios.
  • tempwork.sas demonstrates temporary LIBNAME domain support. Files created in a temporary LIBNAME domain are automatically deleted when the SAS session ends.
  • paraload.sas shows how to perform parallel loads from an existing table into an SPD Server table. This technique exploits a parallel load capability in the LIBNAME proxy.
  • aclcolrw.sas shows the use of ACL row and column security features.
  • symbsub.sas shows how symbolic substitution in SQL Pass-Through statements can provide row-level security in tables.
  • fmtgrpby.sas shows how to use formatted parallel GROUP BY statements in SQL Pass-Through.
  • scale.sas can be used to benchmark the scalability of your SPD Server.
  • dynamic_cluster*.sas shows how to use dynamic clusters with a MIN and MAX variable list.
  • minmax*.sasshows how to use a MIN and MAX variable list on an SPD Server table.
  • paralleljoin*.sasshows the use of the SQL Parallel Join performance enhancement.
  • starjoin*.sas shows the use of the SQL Star Join performance enhancement.
  • index_scan*.sas shows the use of the SQL index scan performance enhancement.
  • materialize_view*.sas shows the use of the SQL materialized view performance enhancement.
  • process_perf_log is a PERL script that processes a Performance Server log and server log into data that can be read into a SAS data set for post-performance analysis. The parameters are detailed in the script.
  • PerfDataSample.sas is used to read a processed Performance Server log into a SAS data set.
The doc/ directory contains information to locate the online SAS Scalable Performance Data (SPD) Server 4.5: Administrator's Guide and the SAS Scalable Performance Data (SPD) Server 4.5: User's Guide in PDF format.
The lic/ directory contains the SPD Server license file for your installation.
The spds.lic file is used by the SPD Server Name Server to validate SPD Server hosts for their target hardware configurations. Once you obtain a valid SPD Server SETINIT for a machine, you need to append it to this file.
The msg/ directory contains SPD Server message files. The collection of *.m files are used by various SPD Server components to generate message text.
The site/ directory is a storage directory for a user's site-specific customization of the sample SPD Server start-up and configuration files. No SPD Server files are delivered in this directory. It is for customer use only.
The spdssmc/ directory contains the SAS Management Console files that support SPD Server.
Copyright © SAS Institute Inc. All rights reserved.