SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

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;

 and 

 are described in Step 2.

SPD Server operation revolves around the executable files described in the packing list.
The executables are in the 

 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:

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 

 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 

 command supports the following options: