SPD Server
client software makes SAS LIBNAME connections and performs user-specific
functions on the SPD Server host. SPD Server client software is installed
with SAS 9.2. It contains the following SAS modules:
-
sasspds is the LIBNAME engine that is
required to access the SPD Server environment from SAS 9.2.
-
sasspdo is the SPD Server operator procedure
that is required to access the SPD Server 4.5 environment from SAS
9.2.
-
spds.msg is the SAS compatible message
file for the SPD Server LIBNAME engine and SPDO operator procedure.
The SPD
Server client software is installed with SAS 9.2 Foundation at
<SASROOT>\SASFoundation\9.2\spdclient. The
SAS 9.2 configuration file automatically includes your SPD Server
client software directory in its required path list.
Once the
SPD Server environment is configured and running, you need to complete
other installation tasks on the SAS clients that will use SPD Server.
This might include the system that is actually running SPD Server.
Therefore, some of these steps might have already been performed during
installation of the SPD Server host. If so, skip the duplicated steps.
SPD Server
media contains SAS client software modules for SAS 9.2 installations
on Solaris by Sun, AIX by IBM, and HP-UX by Hewlett-Packard. Perform
the following steps on each SAS client that will access SPD Server:
-
If you
want to access SPD Server through a registered port (name service),
add the following service to your client's
\etc\services file if it is not already there:
spdsname ????\tcp # SPDS Name service
The service
defines the port number for the spdsnsrv (SPD Server Name Server)
process. Make sure the port number matches the port number used during
SPD Server installation. If you are running SAS with existing SPD
Server installation, this service name is probably already defined.
You can either define another service name for the SAS client to use
(for example, sp45name), or you can directly include the SPD Server
port number in your SAS statements.
-
The SPD
Server can be accessed with the SAS 9.2 ODBC Driver, JDBC Driver,
and htmSQL Driver. Each of these drivers can be downloaded from the
Support tab at
support.sas.com.
For more
information about connecting and configuring these applications, see
Chapter 6, "Using SAS Scalable Performance Data (SPD) Server with
Other Clients," in the
SAS Scalable Performance Data (SPD)
Server 4.5: User's Guide.
ODBC client
applications require installation of the
spds.dll application extension. Install the ODBC client application extension
as follows:
-
Install the SAS 9.2 ODBC Driver
-
Copy
InstallDir\lib\spds.dll to
<drive letter>:\Program Files\sas\shared
files\general.
-
Configure an ODBC data source for
direct SPD Server access.