Note: SPD Server media contains SAS client software modules for 64-bit SAS 9.1.3 installations for these platforms: Solaris by
Sun, AIX by IBM, Solaris x64, and HP/UX by Hewlett-Packard.
Once the SPD Server environment is configured and running, you need to complete some other installation functions on the SAS client platforms that will use SPD Server. This may include the system that is actually running the SPD Server, so some of these steps outlined here may have already been covered during installation of the SPD Server host software. If so, skip over the duplicated steps.
Perform the following steps on each SAS client system that will access SPD Server:
1. If you want to access SPD Server through a registered port (named service), add the following services to your /etc/inet/
services or /etc/services file if not already done:
spdsname ????/tcp # SPDS Name service
The service defines the port number for the spdsnsrv (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, sp44name) or you can directly include the SPD Server port number in your SAS statements.
2. SPD Server is designed to be accessed from multiple platforms. For SPD Server clients running SAS on Solaris, Solaris x64, Windows, AIX, HPIA64, and HP/UX operating systems, you must create your SPD Server client file directory. Locate the base directory of your SAS software installation, and create a subdirectory called spds44. Find the directory on your SPD Server installation media that matches your operating system, and copy the contents into the !SASROOT /
spds44 directory that you just created. This document refers to the !SASROOT/spds44 directory of the SPD Server 4.4
installation as SPDClientDir.
Use the table below to match each platform with the corresponding component directory:
Platform Subdirectory --- --- Solaris2 SOL2 AIX/RS-6000 AIX Windows/Intel WIN/core Solaris x64 SOLX64 HP/UX Itanium HPIA64
HP/UX HPUX
Enter the directory that corresponds to your client's operating system. (If you are using Windows, be sure to navigate to the WIN\core directory). All of the platform-specific directories contain two subdirectories called sasexe and sasmsg. Copy all of the files that you find the sasexe subdirectory and the sasmsg subdirectory into the !SASROOT/spds44 directory that you created on your SPD Server client computer. Remember that !SASROOT/ is a place holder that this documentation uses for the full path specification to the directory that your copy of SAS is installed in.
3. Now that SPD Server client software is on your SAS computer, you need to tell SAS where it is by modifying your SAS configuration file, sasv9.cfg. Open the sasv9.cfg file with a text editor and insert both of the following lines into the
sasv9.cfg file. Make sure that the new SPD Server directory is searched before any other -path() directories in your sasv9.cfg file. The -ins_msg() directory statement should immediately follow the -msg() statement in the sasv9.cfg file.
Otherwise, SAS will not pick up the upgraded SAS System appendages and message files.
-path !SASROOT/spds44 -ins_msg !SASROOT/spds44
If you want to launch the SPD Server client through a command line invocation instead of through your SAS configuration file, on UNIX systems you can use the following SAS invocation command.
-path !SASROOT/spds44 -ins_msg !SASROOT/spds44
4. The SPD Server can be accessed via the SAS/ODBC Driver version 9.0, SAS JDBC Driver, and SAS/htmSQL. Each of these drivers can be downloaded from the support link on the SAS Web at
http://support.sas.com
See, "Using SPD Server with Other Clients," in the online SPD Server 4.4 User's Guide, located at http://support.sas.com/
documentation/onlinedoc/91pdf/index_913.html for more information on connecting and configuring these applications.
ODBC client applications require installation of the spds.dll application extension. Install the ODBC client application extension as follows
❍ Install the SAS/ODBC Driver Version 9
❍ Copy
InstallDir/WIN/core/sasexe/spds.dll
into
<drive letter>:\Program Files\sas\shared files\general
❍ Configure an ODBC Data Source for direct SPD Server access. (For more details about configuring and using
these clients, see, "Using SPD Server with Other Clients," in the online SPD Server User's Guide, located at http://
support.sas.com/documentation/onlinedoc/91pdf/index_913.html.
5. SPD Server software includes support for the SAS Management Console (SMC). You must copy the necessary SMC files to the client system:
❍ Ensure that the SAS Management Console support is installed. You can verify this by checking the InstallDir/
spdssmcdirectory.
❍ Copy
InstallDir/spdssmc/sas.smc.SpdsMgr.jar
into
SMCInstallDir/plugins
where InstallDir is a placeholder for the directory your SPD Server software is installed, and where
SMCInstallDir is a placeholder for the directory your SAS Management Console is installed.