SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

INDEX_MAXMEMORY=8M;
NOCOREFILE;
SEQIOBUFMIN=64K;
RANIOBUFMIN=4K;
MAXWHTHREADS=8;
WHERECOSTING;
RANDOMPLACEDPF;
MINPARTSIZE=128M;
TMPDOMAIN=QRW;
WORKPATH=('c:\temp\work1');

Example 4 uses a combination of libnames.parm, spdsserv.parm, and user-issued SAS
code submitted to SPD Server to create multiple domains that house the following:

•

permanent production tables

•

permanent to semi-permanent user tables

•

temporary tables for intermediate calculations.

In the Example 4 environment, users can access information from permanent production-
type tables, manipulate the information and save, and delete the results in a semi-permanent
user space, and at the same time, use temporary tables with sufficient disk space to perform
large or optimized intermediate table calculations. Multiple data and index paths are
specified to take advantage of RAID-configured disk arrays.

Libnames.parm file code defines the domain named PROD, which contains permanent
production and historical data tables:

LIBNAME=PROD PATHNAME=/metadata/prod
  options="
    DATAPATH=('/data01/prod'
              '/data02/prod'
              '/data03/prod'
              '/data04/prod'
              '/data05/prod'
              '/data06/prod'
              '/data07/prod'
              '/data08/prod'
              '/data09/prod')
    INDEXPATH=('/idx01/prod'
               '/idx02/prod'
               '/idx03/prod'
               '/idx04/prod'
               '/idx05/prod')";

Additional libnames.parm file code defines the domain named USERTBLS, which
contains semi-permanent tables for user projects. Content in USERTBLS can be saved and
deleted by SPD Server users.

LIBNAME=USERTBLS PATHNAME=/metadata/usertbls
  options="
    DATAPATH=('/data01/usertbls'
              '/data02/usertbls'
              '/data03/usertbls'