SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 21 / 271

• 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.
• 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.
Upgrading SPD Server 3.x to SPD Server 4.5
Overview of Upgrading from SPD Server 3.x to SPD Server 4.5
SPD Server 3. x tables are not compatible with SPD Server 4. x tables, including SPD Server
4.5. If you want to use your SPD Server 3. x tables with SPD Server 4.5, you must first
convert your SPD Server 3. x tables to SPD Server 4. x format. For more information about
converting SPD Server 3.x table for use with SPD Server 4.5, see “Introduction” on page
59 .
Overview of Upgrading from SPD Server 3.x to SPD Server 4.5
15