SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 119 / 271

spdsserv.parm Options
BINBUFSIZE=
controls the amount of memory that is used for each bin buffer during sorting. Each bin is
equal to the value that is specified for SORTSIZE. When the sort operation overflows a
single sort bin, SPD Server writes the contents of the bin to disk and then merges the bin
contents to produce the final, sorted results. This option sets the size of the I/O buffer that
must be used to read each bin.
Usage
BINBUFSIZE= <bin-buffer-size> ;
Note: If you specify a value that is smaller than the record length of the sort bin, a bin
buffer large enough to hold one record is created automatically.
FMTDOMAIN=
specifies a user defined format. The FMTDOMAIN= option specifies the domain where
the user defined format is stored. To use user defined formats, you must create a domain
that is named FORMATS. FMTDOMAIN= is used with FMTNAMENODE= and
FMTNAMEPORT=.
Usage
FMTDOMAIN=FORMATS ;
FMTNAMENODE=
specifies a user defined format. The FMTNAMENODE= option specifies the server on
which the user defined formats are stored. FMTNAMENODE= is used with
FMTDOMAIN= and FMTNAMEPORT=.
Usage
FMTNAMENODE=d8488 ;
FMTNAMEPORT=
specifies a user defined format. The FMTNAMEPORT= option specifies the port number
of the server on which the user defined formats are stored. FMTNAMEPORT= is used with
FMTDOMAIN= and FMTNAMENODE=.
Usage
FMTNAMEPORT=5400 ;
GRPBYROWCACHE=
specifies the maximum amount of memory threads that are used during parallel group
aggregations. The parallel group SELECT statement uses multiple threads up to the
MAXWHTHREADS= limit to perform parallel group aggregations. The threads equally
GRPBYROWCACHE=
113