SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 30 / 271

The service defines the port number for the SPD Server Name Server process. Make
sure the added port number matches the port number used during the SPD Server
installation. If you are running SAS with an 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.
2. 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
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.
Testing Your SPD Server Installation Using SAS
Testing your SPD Server installation is simple. To verify, 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.2.
1. Start the SPD Server environment by executing your customized rc.spds script. Execute
this script from the UNIX user ID that owns the LIBNAME directories that are
configured in the SPD Server LIBNAME file. For more information about the rc.spds
script and SPD Server LIBNAME files, see
“Notes for SPD Server Administrators” on
page 32 .
2. On a correctly configured client system, invoke SAS, and make the following
LIBNAME assignments:
LIBNAME test sasspds 'tmp'
server=serverNode.port
user='anonymous';
serverNode is the server's node name and port is either the numeric value assigned to
NSPORT from the rc.spds file, or the service name you use to access the SPD Server
Name Server. If you used the sample rc.spds, your LIBNAME assignment would look
similar to the following:
LIBNAME test sasspds 'tmp'
server=serverNode.5190
user='anonymous';
If you use the spdsname service, your LIBNAME assignment would look similar to
the following:
24
Chapter 3 • SPD Server UNIX Installation Guide