When you use simple statements like these to verify assignments, you ensure that you
have connectivity between the SAS client and the SPD Server host components.
Successfully performing the LIBNAME assignments means that the network
configuration is correct and that most of the SPD Server host configuration is correct.
You will need to fill in
serverNode
with the network node name where the Name Server
and Data Server processes reside. This assumes you left the 'tmp' LIBNAME definition
that was included in the sample
libnames.parm
file you received with your
distribution.
Watch the SAS log for error messages which indicate failure to properly locate one of
the required SPD Server components. The messages that you will most likely encounter
are included below.
ERROR: Module TEST not found in search paths. ERROR:
Error in the LIBNAME or FILENAME statement.
If you see this error, check the
-path
option is properly set to make sure you are
accessing the directory where you loaded the SAS System client-side components.
ERROR: unable to access message 608.108
If you see the following or similar errors regarding failures to access messages, check
the -sasmsg option to make sure the directory where you loaded the SAS System
message file for SPD Server components is properly set.
3. Once the SPD Server host LIBNAMES are assigned, you can further verify your
installation by running the sample SAS program,
InstallDir\samples
\verify.sas
. Submit the following SAS command to execute the test stream:
%include 'InstallDir\samples\verify.sas'\source2;
This SAS stream exercises many of the features of the SPD Server LIBNAME engine
and proxy to provide further confidence that the installation has been made correctly.
It performs a sequence of DATA and PROC steps against a generated data set and
performs self checking on the results expected from various DATA step queries of the
test data set. If any one of these queries fails to produce the expected result, the SAS
job is canceled. The job
verify.sas
assumes the SAS librefs TEST and TESTRL are
assigned from Step 2 above.
4. You should also verify that SQL Pass-Through services are working in SPD Server by
performing the following sequence of SAS commands:
%let spdshost=serverNode;
%let spdsport=port;
%include 'InstallDir\samples\verptsql.sas'\source2;
where
serverNode
and
port
are the same as in the previous LIBNAME assignment
step.
SPD Server Command Reference
SPD Server executable files support command line options that override default features,
or supply site-dependent configuration information for the program to use. The command
options for the following programs are explained below .
48
Chapter 4 • SPD Server Windows Installation Guide
Summary of Contents for Scalable Performance Data Server 4.5
Page 1: ...SAS Scalable Performance Data Server 4 5 Administrator s Guide...
Page 7: ...Part 1 Product Notes Chapter 1 SPD Server 4 5 Product Notes 3 1...
Page 8: ...2...
Page 12: ...6...
Page 63: ...Part 3 Migration Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility 59 57...
Page 64: ...58...
Page 70: ...64 Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility...
Page 72: ...66...
Page 76: ...70 Chapter 6 Using the SPD Server Name Server to Manage Resources...
Page 94: ...88 Chapter 7 Administering and Configuring SPD Server Using the SAS Management Console...
Page 98: ...92 Chapter 8 SPD Server SQL Query Rewrite Facility...
Page 116: ...110 Chapter 10 Configuring Disk Storage for SPD Server...
Page 128: ...122 Chapter 11 Setting Up SPD Server Parameter Files...
Page 154: ...148...
Page 198: ...192 Chapter 14 ACL Security Overview...
Page 212: ...206 Chapter 15 Managing SPD Server Passwords Users and Table ACLs...
Page 214: ...208...
Page 224: ...218 Chapter 16 SPD Server Operator Interface Procedure PROC SPDO...
Page 236: ...230 Chapter 18 SPD Server Table List Utility Spdsls...
Page 256: ...250 Chapter 19 SPD Server Backup and Restore Utilities...
Page 264: ...258 Chapter 20 SPD Server Directory Cleanup Utility...
Page 270: ......