SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 46 / 271

• 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*.sas shows how to use a MIN and MAX variable list on an SPD Server table.
• paralleljoin*.sas shows 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.
40
Chapter 4 • SPD Server Windows Installation Guide