SPD Server Command Reference

SPD Server operation revolves around the executables that are 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 (spdsserv) host process registers LIBNAME domain information from its configuration file with its appointed name server (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 that connect to the name server.
Invoke the SPD Server name server by using the following command-line syntax:
spdsnsrv [-option [optval]...]
The spdsnsrv command supports the following options:
-listenport port#
specifies the explicit TCP port number that the name server uses to accept connections from the SPD Server LIBNAME engine and its SPD Server hosts. If no port is specified, the name server queries the system for port addresses using the service name spdsname. If no such service has been registered, SPD Server chooses a dynamic port number for the name server to use.
-logfile fileSpec
specifies that the logger process automatically creates a server log file. fileSpec specifies a partial pathname or filename specification that is used to generate the complete log file path. For example, if you specify fileSpec as \DOWNlogs\spdsnsrv, the name \DOWNlogs\spdsnsrv_mmddyyyy_hh:mm:ss.spdslog is generated. The values mmddyyyy and hh:mm:ss indicate the time when the system created the log file.
-logtime hh:mm
specifies the time of day to cycle a new generation of the name log file. At this time each day, the previous log file will be closed and a new log file will be opened.
-licensefile lic-file
License file keys are generated by SAS and provided to you. With this release of SPD Server, you receive an SPD Server license key for each machine on which you license SPD Server. The SPD Server administrator must enter each key into the license filer. SPD Server will not run on a machine whose valid license key has not been entered into the license file. License keys are plain text strings that include product, site, and machine information, and the password that is required for using the SPD Server in this specific environment.

SPD Server Host Commands

The SPD Server LIBNAME engine connects to the SPD Server host to access data in the server environment. The SPD Server host uses the SPD Server password file to validate each SPD Server user, and then creates a LIBNAME proxy process on behalf of each of them.
Part of the function of the SPD Server host process is to start SPD Server logging processes. The spdslog process performs message logging functions. The spdsaud process performs audit logging functions. The spdsserv command-line options control automatic log filename generation and cycling properties. The spdsserv command-line options also control the message and audit logging functions. Message and audit logging facilities include automatic log filename generation and periodic log file cycling support. You can periodically switch to a new name server log file without stopping and restarting SPD Server, which improves the availability of the name server.
Audit log records are kept for all resources that are accessed by each LIBNAME proxy process. The audit log saves records in its own separate space, away from other server log files. A sample SAS job that processes the audit log and generates a report is provided. Check samples\audit.sas for information about processing the audit log and generating the report. To enable the audit log, use the spdsserv command with the -AUDITFILE option.
When you are using automatic server log cycling or audit log 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.
Invoke the SPD Server host by using the following command-line syntax:
spdsserv [-option [optval]...]
The spdsserv command supports the following options:
-parmfile file-spec
specifies an explicit file path for the SPD Server host's parameter file. This file is mandatory and contains any SPD Server options. If this option is omitted, the SPD Server host assumes a parameter file named spdsserv.parm is in the process's current working directory. Option declarations in this file are of the following form:
Option[ = Value];
You probably do not need to modify the default values in InstallDir\site\spdsserv.parm. For more information about the parameter file and the server parameters, see Setting Up SPD Server Parameter Files .
-acldir pwd-dir-path
specifies the directory path to the SPD Server host password file. You can omit this option if the PASSPATH= option is declared in the SPD Server host's -PARMFILE option. A valid SPD Server password file is required even when you specify the -noacl option. You must use the SPD Account Manager to create the password file and to populate it with the set of valid SPD Server user IDs.
-noacl
disables SPD Server login validation for SPD Server LIBNAME engine connections to the SPD Server host.
-nameserver node-name
specifies the node name where the name server process is running. This node does not need to be the same node that is hosting the SPD Server host processes. This option is required.
-nameserverport port#
specifies an explicit TCP port number for the SPD Server host to use to connect to its name server. If you do not specify a port, the name server queries the system for a registered port address that is using the service name spdsname.
-libnamefile file-spec
specifies the name of the file that contains the logical LIBNAME domain definitions that the SPD Server host supports. LIBNAME definitions can span multiple lines and must begin with the LIBNAME=name keyword. Each LIBNAME definition must be terminated with a ; character.
-logfile fileSpec
specifies that the logger process will automatically create a server log file. The fileSpec value specifies a partial pathname or filename that is used to generate the complete log file path. For example, if you specify fileSpec as\DOWNlogs\spds, the generated name will be: \DOWNlogs\spds_ mmddyyyy_hh:mm:ss.spdslog. In this example, mmddyyyy and hh:mm:ss indicate the system time when the log file was created.
-logtime hh:mm
specifies the time of day to cycle a new generation of the server log file. At this time each day, the previous log file will be closed and a new log file will be opened.
-auditfile fileSpec
enables audit logging for the server and automatic audit log file creation by the audit process. The fileSpec value specifies a partial pathname or filename that is used to generate the complete audit file path. For example if you specify fileSpec as \audit\spds, the generated name will be mmddyyyy_yyyy.spdsaudit, where mmddyyyy is the system date when the log file was created.
-audittime hh:mm
specifies the time of day to cycle a new generation of the audit log file. At this time each day, the previous log file will be closed and a new log file will be opened.

SNET Server Commands

The SNET Server is the connection point for clients accessing SPD Server data through ODBC, JDBC, or htmSQL applications.
Invoke the SNET server by using the following command-line syntax:
spdssnet [-listenport listen_port]
The spdssnet command supports the following options:
-listenport listen_port
specifies the listen port number that spdssnet uses to accept connections from ODBC, JDBC, or htmSQL clients. If you do not specify a port numberd, spdssnet uses the name service spdssnet from the etc\services file to determine its listen port.
-logfile fileSpec
specifies that the logger process will automatically create a server log file. The fileSpec value specifies a partial path or filename that is used to generate the complete log file path. For example, if you specify fileSpec as \DOWNlogs\spdssnet, the generated name will be \DOWNlogs\spdssnet_mmddyyyy_hh:mm:ss.spdslog, where mmddyyyy and hh:mm:ss indicate the system time when the log file was created.
-logtime hh:mm
specifies the time of day to cycle a new generation of the SNET log file. At this time each day, the previous log file will beclosed and a new log file will be opened.

PSMGR Utility

The SPD Server administrator can use the psmgr utility to create and maintain the data set that contains the authorized SPD Server user IDs. If you choose to run SPD Server ACL support, you need to use this utility to create and populate the SPD Server password file before you start SPD Server. You can use the psmgr utility or SAS Management Console to manage passwords. For more information about the psmgr utility, see The Password Manager Utility psmgr.