SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 114 / 271

Example 3: Adding More File Systems to a Path Option When Its File
System Is Full
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.
Recommended: Use ROPTIONS=
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.
108
Chapter 10 • Configuring Disk Storage for SPD Server