SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador
Usage:
WORKPATH=('/work1/spds123'
'/work2/spds123'
'/work3/spds123'
'/work4/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.
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.
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')
'/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.
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')";
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".
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')" ;
OPTIONS="
DATAPATH=('d:\data\datapath1'
'e:\data\datapath2')
INDEXPATH=('f:\idx\index')" ;
126
Chapter 12 • Setting Up SPD Server Libname Parameter Files