SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

•

information in an SPD Server backup data file.

•

 Performs incremental or full restores of SPD Server tables using the SPD

Server backup data file created by the utility.

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 

 directory, and you must ensure that the 

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

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.

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.

The PROC SPDO spdscmd command requires similar access: either identical user IDs or
ACLSPECIAL=YES user privileges. See 

 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.