Domain Path Options

Overview of Data Path Options

You can specify optional path parameters for a domain in libnames.parm libref statements.

SPD Server domain optional path parameters are specified using either standard option statements or using reserved option statements. The difference between non-reserved and reserved option statements is that non-reserved option statements can be altered by subsequent libref statements that are submitted to SPD Server via SAS code.

Use the roption (reserved option) specification to ensure that the domain options that you declare in libnames.parm cannot be modified by subsequent libref statements submitted to SPD Server via SAS code.

All options specified in libnames.parm files must be either standard options or reserved options (roptions). You cannot specify a combination of reserved and non-reserved options in the libnames.parm file.

The syntax you use to specify optional path parameters in the libnames.parm file is identical for options and roptions:

LIBNAME=domain-name PATHNAME=primary-metadata-path ;
     OPTIONS="<option-1 ... option-n>";

LIBNAME=domain-name PATHNAME=primary-metadata-path ;
     ROPTIONS="<option-1 ... option-n>";

The following are LIBNAME domain path options for SPD Server:

DATAPATH=

Specifies a list of paths that will contain SPD Server data tables associated with the declared domain. DATAPATH= can be specified as an option or as a roption.

Usage:

DATAPATH=('/data1/spds123'
          '/data2/spds123'
          '/data3/spds123'
          '/data4/spds123')

INDEXPATH=

Specifies a list of paths that will contain SPD Server index tables associated with the declared domain. INDEXPATH= can be specified as an option or as a roption.

Usage:

INDEXPATH=('/idx1/spds123'
           '/idx2/spds123'
           '/idx3/spds123'
           '/idx4/spds123')

WORKPATH=

Specifies a list of paths that will contain temporary SPD Server work tables and temporary SPD Server intermediate files associated with the declared domain. WORKPATH= can be specified as an option or as a roption.

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')