SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 124 / 271

RANDOMPLACEDPF in SPD Server 4.5, include a NORANDOMPLACEDPF statement
in your
spdsserv.parm file.
Usage
RANDOMPLACEDPF;
RANIOBUFMIN=
specifies the minimum random I/O buffer size. The specified value becomes the minimum
I/O buffer size that is used by the proxy when it performs random I/O and table requests.
Usage
RANIOBUFMIN=<ldap_server_binddn_string> <minimum-random-i/o-buffer-size> ;
SEQIOBUFMIN=
specifies the minimum sequential I/O buffer size. The specified value specified becomes
the minimum I/O buffer size that is used by the proxy when it performs sequential I/O and
table requests.
Usage
SEQIOBUFMIN=<ldap_server_binddn_string> <minimum-sequential-i/o-buffer-size> ;
SORTSIZE
controls the amount of memory to allocate for sort operations. A larger value for this option
can increase the paging activity for a file and degrade performance.
Usage
SORTSIZE=<ldap_server_binddn_string> <memory-allocated-for-sort-operations> ;
SQLOPTS=
overrides SQL default options for each SQL connect when it is specified on an SQL RESET
command. If SQLOPTS= is not specified, SQL default options apply. See the SQL RESET
command for possible RESET options you can set.
Usage
SQLOPTS= "RESET <SQL-option> [ <SQL-option>]" ;
TMPDOMAIN=
specifies an SPD Server domain that is defined in the libnames.parm file, which the query
rewrite facility uses to store intermediate tables.
Usage
...
libname=qrw pathname=/IDX1/spdsmgr/spds45_sasdqh/qrw ;
...
TMPDOMAIN=qrw ;
118
Chapter 11 • Setting Up SPD Server Parameter Files