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/.

Note: InstallDir/ represents the root directory in which SPD Server is installed.

The bin/ subdirectory contains the following binary files:

ixutil

the data set index utility

psmgr

the password file utility

spdsaud

the audit logger

spdsbase

the LIBNAME proxy

spdsbkup

performs full or incremental table backups

spdsconv

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

spdseng

the SQL pass-through engine

spdslog

the message logger

spdsls

gives physical file listings for a LIBNAME domain

spdsnsrv

the SPD Server name server

spdsperf

the Performance server

Note: Currently, spdsperf is not available for Linux on X64.

spdsrstr

restores full or incremental table backups

spdsserv

the SPD Server host

spdssnet

the ODBC, JDBC, and htmSQL gateway

spqldrive

a stand-alone SQL pass-through driver

spdsclean

the SPD Server disk cleanup utility

dulibv3

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

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

spdsbased

the debug version of spdsbase

spdsengd

the debug version of spdseng

spdsiotest

the stand-alone SPD Server I/O scalability test

spdsnlslib

the national language support (NLS) library

spdsnlslibd

the debug version of spdsnlslib

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

spds.dll

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

spdslib

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:

aclcolrw.sas

shows how to use ACL row and column security features.

auditraw.sas

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

audit.sql.sas

used to read an SQL audit file.

doc_examples.sas

contains sample SAS code that is used in the SAS Scalable Performance Data (SPD) Server 4.53: User's Guide. This guide provides SPD Server LIBNAME and data set usage, and syntax options.

dynamic_cluster*.sas

shows how to use dynamic clusters with a MIN and MAX variable list.

fmtgrpby.sas

shows how to use formatted parallel GROUP BY statements in SQL pass through.

index_scan*.sas

shows how to use the SQL index scan performance enhancement.

killrc

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 that were 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 in the /samples directory.

killspds

a shell script that kills all processes that begin with the letters spds for a UNIX user. 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.

libnames.parm

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

libsamp.parm

a more advanced example of a LIBNAME configuration file.

materialize_view*.sas

shows how to use the SQL materialized view performance enhancement.

minmax*.sas

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

paralleljoin*.sas

shows how to use the SQL Parallel Join performance enhancement.

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.

passthru.sas

demonstrates the use of SQL pass through. This file gives examples of simple, single-level pass through, and secondary libref and connection scenarios.

PerfDataSample.sas

reads a processed Performance Server log into a SAS data set.

process_perf_log

a PERL script that processes a Performance server log and a server log into data that can be read into a SAS data set for post-performance analysis.

pwdb

a script that starts the Password Manager executable.

rc.perf

a Bourne shell script that starts a standard Performance Server.

rc.spds

a Bourne shell script to start a standard SPD Server environment.

scale.sas

can be used to benchmark the scalability of your SPD Server.

spdsinst.sas

demonstrates the simple use of WHERE clauses and WHERE planner output.

spdsserv.par

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.

starjoin*.sas

shows how to use the SQL Star Join performance enhancement.

symbsub.sas

shows how symbolic substitution in SQL pass-through statements can provide row-level security in tables.

tempwork.sas

demonstrates temporary LIBNAME domain support. Files that are created in a temporary LIBNAME domain are automatically deleted when the SAS session ends.

verify.sas

a SAS installation verification job. You should run this job after you install SPD Server

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. 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.