Testing your SPD Server
installation is simple. To verify your installation, you make two
SAS LIBNAME assignments using the SPD Server LIBNAME engine. The examples
in this section refer to the SASSPDS engine, which is the engine for
SAS 9.3.
-
Start the SPD Server
environment.
-
On a client system that
is configured correctly, invoke SAS and make the following LIBNAME
assignments:
LIBNAME test sasspds 'tmp'
server=serverNode.port
user='anonymous';
In this code, serverNode
is the server's node name, and port is either the numeric value used
to start the name server or the service name you use to access the
SPD Server name server. Name services enable you to connect to a server
using a character string, instead of specifying a port number. If
you used the default numeric port assignment of 5400, your assignmentlooks
similar to the following example:
LIBNAME test sasspds 'tmp'
server=serverNode.5400
user='anonymous';
If you used the spdsname
service, your LIBNAME assignment looks similar to the following example:
LIBNAME test sasspds 'tmp'
server=serverNode.spdsname
user='anonymous';
In addition, you should
verify that the row-level integrity LIBNAME assignment works correctly:
LIBNAME testrl sasspds 'tmp'
server=serverNode.port
user='anonymous'
locking=YES;
When you verify these
statements, you confirm the connectivity between the SAS client and
the SPD Server environment. When you successfully make these LIBNAME
assignments, the network configuration is correct and most of the
SPD Server configuration is correct.
Substitute serverNode
with the node name that runs the name server and the data server.
The test assumes that the temporary LIBNAME definition in the sample
libnames.parm file was not changed during installation.
-
Watch the SAS log for
error messages. You might see failures to locate one or more of the
required SPD Server components. The following messages are common
error messages that you might receive:
ERROR: Module TEST not found in search paths.
ERROR: Error in the LIBNAME or FILENAME statement.
If you receive the following
error message (or a similar message) that describes failures to access
messages, check your -SASMSG option and confirm that the directory
in which you installed SPD Server components is correctly set.
ERROR: unable to access message 608.108
-
After you have assigned
every LIBNAME, you can further verify your installation by running
the sample SAS program,
InstallDir\samples\verify.sas
. Issue the following SAS command to execute the program:
%include 'InstallDir\samples\verify.sas'\source2;
This test exercises
many features of the SPD Server LIBNAME engine and proxy, and verifies
your installation configuration. The test performs a sequence of DATA
and PROC steps using a generated data set. It checks the results expected
from various DATA step queries. If any query fails to produce the
expected results, the SAS job is terminated. The job verify.sas requires
that the SAS librefs TEST and TESTRL are assigned as shown in
step 2.
-
Verify that SQL pass-through
services are working in SPD Server by issuing the following SAS commands:
%let spdshost=serverNode;
%let spdsport=port;
%include 'InstallDir\samples\verptsql.sas'\source2;
Note: serverNode and port are described
in
step 2.