Packing List for SPD Server Distribution

Directory names in the packing list are subdirectories of your SPD Server host installation directory, whose path is represented by InstallDir\.

The bin\ subdirectory contains the following binary files:

dulibv3.dll

the SPD Server 3.x 64-bit version of the shared library that is used by spdsconv

Note: The dulibv3 file is included only if your system previously supported SPD Server 3.x tables.

ixutil.exe

the data set index utility

psmgr.exe

the password file utility

spdsaud.exe

the audit logger

spdsbase.exe

the LIBNAME proxy

spdsbased.exe

the debug version of spdsbase

spdsbat.exe

an executable that makes SPD Server function as a service

spdsbkup.exe

performs full or incremental table backups

spdsclean.exe

the SPD Server disk cleanup utility

spdsconv.exe

the SPD Server 3.x to SPD Server 4.x table conversion utility

spdseng.dll

the SQL pass-phrough engine

spdsengd.dll

the debug version of spdseng

spdsiotest.exe

the standalone SPD Server I/O scalability test

spdslog.exe

the message logger

spdsls.exe

gives physical file listings for a LIBNAME domain

spdsmakesvc450.exe

an executable that installs SPD Server as a service

spdsnlslib.dll

the national language support (NLS) library

spdsnlslibd.dll

the debug version of spdsnlslib

spdsnsrv.exe

the SPD Server name server

spdsserv.exe

the SPD Server host

spdssnet.exe

the ODBC, JDBC, and htmSQL gateway

spdsrstr.exe

restores full or incremental table backups

spqldrive.exe

a standalone SQL pass-through driver

The lib\ subdirectory contains the following SPD Server library files:

spds.dll

the application extension library that is accessed with the SAS ODBC driver

spdslib.dll

the run-time library that performs SQL pass-through from C and C++ applications to SPD Server

The samples\ directory contains the following files of interest:

audit.sql.sas

used to read an SQL audit file.

auditraw.sas

used to read proxy audit files that do not include WHERE clause auditing.

auditwh.sas

used to read proxy audit files that include WHERE clause auditing.

libnames.parm

a sample SPD Server host LIBNAME configuration file. Use this file with the -LIBNAMEFILE option for the spdsserv command.

libsamp.parm

a more advanced example of a LIBNAME configuration file.

spdsserv.parm

a sample SPD Server host parameter file. This file sets the defaults for SPD Server options. Use this file with the -PARMFILE option for the spdsserv command.

rc.spds

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.53: User's Guide. This guide provides SPD Server LIBNAME and data set usage, and syntax options.

verify.sas

a SAS installation verification job. You should run this job 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. This file gives examples of simple, single-level pass-through and secondary libref, and connection scenarios.

tempwork.sas

demonstrates temporary LIBNAME domain support. Files that are 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. The LIBNAME proxy uses the same technology as the SQL LOAD TABLE statement.

aclcolrw.sa

shows how to use 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*.sas

shows how to use a MIN and MAX variable list on an SPD Server table.

paralleljoin*.sas

shows how to use the SQL Parallel Join performance enhancement.

starjoin*.sas

shows how to use the SQL Star Join performance enhancement.

index_scan*.sas

shows how to use the SQL index scan performance enhancement.

materialize_view*.sas

shows how to use the SQL materialized view performance enhancement.

The doc/ directory contains information about the location of the online PDF of the SAS Scalable Performance Data (SPD) Server 4.53: Administrator's Guide and the SAS Scalable Performance Data (SPD) Server 4.53: User's Guide.

The msg\ directory contains SPD Server message files. Some SPD Server components use the collection of *.m files 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. The files in this directory include:

spdsmakesvc.bat

batch file that makes SPD Server a service

spdsremovesvc.ba

batch file that removes the SPD Server service

spdsstartsvc.bat

batch file that starts the SPD Server service

spdsstopsvc.bat

batch file that stops the SPD Server service

spdsnsrv.bat

batch file that starts the SPD Server name server

spdssnet.bat

batch file that starts the SPD Sever SNET Server

spdsserv.bat

batch file that starts SPD Server

The spdssmc\ directory contains the SAS Management Console files that support SPD Server.