SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 132 / 271

Usage:
WORKPATH=('/work1/spds123'
'/work2/spds123'
'/work3/spds123'
'/work4/spds123')
METAPATH=
Specifies a list of paths that are allocated to contain overflow SPD Server metadata if the
designated metadata space that is allocated in the PATHNAME= option statement becomes
full. The additional metapaths provide a buffer space that can be used for update and append
operations to existing SPD Server tables.
When the primary metadata space that is defined by the PATHNAME= option becomes
filled, new tables cannot be added to the domain. The primary path should be located on a
file system that is expandable and mirrored. As a conservative estimate for space, plan for
20 gigabytes of metadata for every terabyte of compressed physical data.
METAPATH= can be specified as an option or as a roption.
Usage:
METAPATH=('/meta1/spdsmgr/meta'
'/meta2/spdsmgr/meta')
Consistency in Nomenclature
It is a suggested practice (but not a requirement) to match or closely match the LIBNAME,
pathname, and other optional pathnames for consistency. The following examples illustrate
a domain declaration that is easy to follow, and a domain declaration that requires more
concentration to follow.
Example of intuitive names in a libnames.parm file:
LIBNAME=SPDS123 PATHNAME=c:\data\spds123
OPTIONS="
DATAPATH=('d:\data\spds123'
'e:\data\spds123')
INDEXPATH=('f:\idx\spds123')";
In the previous example, the declared domain name, pathname, data pathname, and index
pathname are all "spds123".
Example of non-intuitive names in a libnames.parm file:
LIBNAME=BADEXAMPL PATHNAME=c:\data\myspds
OPTIONS="
DATAPATH=('d:\data\datapath1'
'e:\data\datapath2')
INDEXPATH=('f:\idx\index')" ;
126
Chapter 12 • Setting Up SPD Server Libname Parameter Files