Domain Path Options

You can specify optional path parameters for a domain in libnames.parm libref statements. You specify these optional path parameters 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 with SAS code. Specify ROPTIONS (reserved option) to ensure that the domain options that you declare in libnames.parm cannot be modified by subsequent libref statements submitted to SPD Server using SAS code.

All options that are 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.

Use the following syntax to specify optional path parameters in the libnames.parm file for both 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 list describes the LIBNAME domain path options for SPD Server.

DATAPATH=

specifies a list of paths that will contain SPD Server data tables that are associated with the declared domain. You can use OPTIONS or ROPTIONS to specify DATAPATH=.

Usage:

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

INDEXPATH=

Specifies a list of paths that will contain SPD Server index tables that are associated with the declared domain. You can use OPTIONS or ROPTIONS to specify INDEXPATH=.

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 that are associated with the declared domain. You can use OPTIONS or ROPTIONS to specify WORKPATH=.

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 is full, new tables cannot be added to the domain. Put the primary path 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.

You can use OPTIONS or ROPTIONS to specify METAPATH=

Usage:

METAPATH=('/meta1/spdsmgr/meta'
          '/meta2/spdsmgr/meta')