SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 32 / 271

4. Verify that SQL Pass-Through services are working in SPD Server by submitting the
following SAS commands:
%let spdshost=serverNode;
%let spdsport=port;
%include 'InstallDir/samples/verptsql.sas'/source2;
serverNode
and
port
are described in Step 2.
SPD Server Command Reference
SPD Server operation revolves around the executable files described in the packing list.
The executables are in the
/bin
subdirectories. Each executable supports a set of
command-line options that override default features, or provides site-dependent
configuration information. The command-line options for each executable are provided in
the following sections:
SPD Server Name Server Commands
The SPD Server LIBNAME engine connects to the SPD Server Name Server. The Name
Server resolves LIBNAME domain names into physical file system paths for librefs. The
Name Server also resolves host node and end-point (TCP port) addresses for each
LIBNAME. Each SPD Server host process (spdsserv process) registers LIBNAME domain
information from its configuration file with its appointed Name Server process (spdsnsrv
process). Multiple SPD Server hosts can use the same Name Server to register their
LIBNAME domains. The only requirement is that the combination of the LIBNAME=
option values from the SPD Server host's LIBNAME configuration file must be unique
across all SPD Server hosts connecting to the Name Server.
Part of the function of the Name Server process is to start an SPD Server logging process.
The spdslog process performs message logging functions. Message logging functions are
controlled using spdsnsrv command-line options. Message logging functions include
automatic log filename generation and periodic log file cycling.
The spdsnsrv command-line options control automatic log filename generation and cycling
properties. Name Server availability improves performance because you can periodically
switch to a new Name Server log file without halting and restarting SPD Server. The default
rc.spds script in the
samples/
directory of your SPD Server installation provides
examples of spdsnsrv command-line options.
When using automatic log filename generation and cycling, remember to periodically clean
the log files. Proper log file maintenance includes archiving logs using secondary or long-
term storage.
Many users retain only a few generations of log files for quick reference. A shell script that
runs on a regular basis (such as CRONTAB) is a good way to perform log maintenance on
your server machine.
The SPD Server Name Server is invoked using the following command-line syntax:
spdsnsrv [-option [optval]...]
The
spdsnsrv
command supports the following options:
26
Chapter 3 • SPD Server UNIX Installation Guide