SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 239 / 271

• spdsbkup Performs incremental or full backups of SPD Server tables, storing the
information in an SPD Server backup data file.
• spdsrstr Performs incremental or full restores of SPD Server tables using the SPD
Server backup data file created by the utility.
Using Utilities with SPD Server
SPD Server Utilities Path Requirements
SPD Server provides National Language Support (NLS) for multiple languages and
character sets in database operations. As a result, all SPD Server utilities require access to
the
InstallDir/bin
directory, and you must ensure that the
InstallDir/bin
directory is included in your SPD Server library path specification.
Here is an example of a statement that specifies the necessary path:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:InstallDir/bin
export LD_LIBRARY_PATH
Compatibility with Previous Versions
SPD Server 4.5 backup and restore utilities are not compatible with SPD Server 3.x and
earlier releases. You cannot restore SPD Server 3.x backup files using SPD Server 4.5
utilities. You must use your SPD Server 3.x utilities to restore SPD Server 3.x backup files,
and then archive the restored files using the SPD Server 4.5 utilities.
Privileged Access Protection
Running the SPD Server backup and restore utilities is a privileged operation. For a user
to have access to SPD Server backup and restore utilities, one of the following must be
true:
• The user ID that starts the SPD Server session must be identical to the user ID that
performs the SPD Server backup and restore utilities (by definition, the user ID that
starts the SPD Server session is a privileged user).
• The user has ACLSPECIAL=YES privileges.
To run the backup and restore utilities remotely using the SAS PROC SPDO spdscmd.
The PROC SPDO spdscmd command requires similar access: either identical user IDs or
ACLSPECIAL=YES user privileges. See Usage Scenarios for more information about
running the SPD Server backup and restore utilities with PROC SPDO.
Access to the backup and restore utilities will be given to the special user "SPDSBKUP".
Optional user and password options are available for the utilities that can be used to give
access to a specific privileged user.
Privileged Access Protection
233