SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

creating temporary table spaces is to use the optional TEMP=YES specification when the
LIBNAME domain statement is issued in submitted SPD Server job code. All tables
residing in temporary table space are lost at the end of the SPD Server user session, when
temporary table space is automatically deleted.

The following SPD Server code examples illustrate the range of LIBNAME domains that
can be created using the libnames.parm file. The code examples begin with the simplest
forms of LIBNAME domain declaration and increase in complexity.

Example 1 demonstrates the syntax necessary for the simplest form of LIBNAME domain
configuration:

LIBNAME=SKULIST PATHNAME=c:\data\skulist;  

This statement creates the SPD Server LIBNAME domain SKULIST. All SPD Server
tables that are associated with the SKULIST domain (table data, metadata, index data, and
intermediate data) will reside in the single directory that is referenced in the path
specification c:\data\skulist.

Example 2 demonstrates the syntax necessary to declare a LIBNAME domain with separate
paths allocated for the domain data tables, index tables, and intermediate data files. The
domain metadata will continue to be stored in the location specified by the PATHNAME=
specification.

LIBNAME=SKULIST PATHNAME=/metadata/skulist
  options="
    DATAPATH=('/data01/skulist'
              '/data02/skulist'
              '/data03/skulist'
              '/data04/skulist'
              '/data05/skulist'
              '/data06/skulist')
    INDEXPATH=('/idx01/skulist'
               '/idx02/skulist'
               '/idx03/skulist'
               '/idx04/skulist')
    WORKPATH=('/work01/skulist'
              '/work02/skulist'
              '/work03/skulist'
              '/work04/skulist')";

Example 2 uses the domain path options DATAPATH=, INDEXPATH=, and
WORKPATH=. Optimal performance can be achieved in this configuration when each
domain path resides on a separate disk or on network components that can take advantage
of parallelism opportunities.