LIBNAME Domain Path Options :: SAS(R) Scalable Performance Data Server 5.1: Administrator's Guide, Second Edition

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.

Use the following syntax to specify optional path parameters in the libnames.parm file for ROPTIONS:

LIBNAME=domain-name 
  PATHNAME=primary-metadata-path 
  ROPTIONS="DATAPATH= 
    ('data-path_1' 'data-path_2' ... 'data-path_n')
  INDEXPATH= ('index-path_1' 'index-path_2' ... 'data-path_n')
  WORKPATH= ('work-path_1' 'work-path_2' ... 'work-path_n')
   METAPATH= ('meta-path_1' 'meta-path_2' ... 'meta-path_n')";

DATAPATH=

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

Usage:

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

INDEXPATH=

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

Usage:

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

WORKPATH=

specifies a list of paths that contain temporary SPD Server work tables and temporary SPD Server intermediate files that are associated with the declared domain. You use 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')