SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

   spdsserv -acl
      -acldir InstallDir/site
      -nameserver samson
      -libnamefile libnames.parm

Sample libnames.parm for a UNIX System

libname=all_users pathname=/disk1/peruser_tables
   roptions="datapath=('/disk2/userdata' '/disk3/userdata'
                       '/disk12/userdata' '/disk13/userdata')
   indexpath=('/disk4/userindexes' '/disk5/userindexes'
              '/disk14/userindexes' '/disk15/userindexes')";

Sample libnames.parm for a Windows System

libname=all_users
pathname=d:\peruser_tables
   roptions="datapath=('e:\userdata'
                       'f:\userdata'
                       'i:\userdata')
   indexpath=('g:\userindexes'
              'h:\userindexes'
              'j:\userindexes')";

In Example 3, SAS users can continue to create more SPD Server tables, as long as space
is available for the metadata files in the primary file system. When the primary file system
is exhausted, you might try to expand storage for the .mdf components by adding the
METAPATH= specification to your ROPTIONS= value in your LIBNAME parameter file.
Unfortunately, this will not solve your problem. Remember the SPD Server restriction
mentioned earlier: all .mdf components must have their initial partition file created in the
primary file system (the directory that was first specified by the PATHNAME= option for
the LIBNAME domain).

To solve your problem, your only recourse in this situation is to create a new LIBNAME
domain.

Here is why you should use ROPTIONS= instead of OPTIONS= in your libnames.parm
file.

ROPTIONS= specifications override any corresponding options that your SAS users
include in their programs. Example 3 demonstrates explicit control of disk usage by the
system administrator. In the example, even if SAS users specify file systems using
LIBNAME DATAPATH= and INDEXPATH= LIBNAME options during their
LIBNAME connection, the administrator's use of DATAPATH= and INDEXPATH= with
ROPTIONS= overrides the SAS users' specifications.