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.exe is the SPD Server Name Server.
  • spdsserv.exeis the SPD Server host.
  • spdsbase.exe is the LIBNAME proxy .
  • spdslog.exe is the message logger .
  • spdsaud.exe is the audit logger.
  • spdseng.dll is the SQL Pass-Through engine.
  • ixutil.exe is the data set index utility.
  • psmgr.exe is the password file utility.
  • spdssnet.exe is the ODBC, JDBC, and htmSQL gateway.
  • spdsls.exe gives physical file listings for a LIBNAME domain.
  • spdsbkup.exe performs full or incremental table backups.
  • spdsrstr.exe restores full or incremental table backups.
  • spqldrive.exe is a stand-alone SQL Pass-Through driver.
  • spdsconv.exe is the SPD Server 3.x to SPD Server 4.x table conversion utility.
  • spdsclean.exe is the SPD Server disk cleanup utility.
  • dulibv3.dll 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.exe is the debug version of spdsbase.
  • spdsengd.dll is the debug version of spdseng.
  • spdsnlslib.dll is the NLS library.
  • spdsnlslibd.dll is the debug version of spdsnlslib.
  • spdsiotest.exe is the stand-alone SPD Server I/O scalability test.
  • spdsbat.exe is an executable that is used to make SPD Server act as a service.
  • spdsmakesvc450.exe is an executable that is used to install SPD Server as a service.
The lib\ subdirectory contains the following SPD Server library files:
  • spdslib.dll 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 this file with the -LIBNAMEFILE option for the spdsserv command.
  • libsamp.parm is a more advanced example of a LIBNAME configuration file.
  • 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.
  • doc_examples.sas contains sample SAS code that is used in the SAS Scalable Performance (SPD) Data Server 4.5: User's Guide. 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.
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. For example:
  • spdsmakesvc.bat is the "make SPD Server a service" batch file.
  • spdsremovesvc.bat is the "remove SPD Server-service" batch file.
  • spdsstartsvc.bat is the "start SPD Server service" batch file.
  • spdsstopsvc.bat is the "stop SPD Server service" batch file.
  • spdsnsrv.bat is the SPD Server Name Server start-up batch file.
  • spdssnet.bat is the SPD Server SNET server start-up batch file.
  • spdsserv.bat is the SPD Server start-up batch file.
The spdssmc\ directory contains the SAS Management Console files that support SPD Server.
Copyright © SAS Institute Inc. All rights reserved.