SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

RANDOMPLACEDPF in SPD Server 4.5, include a NORANDOMPLACEDPF statement
in your spdsserv.parm file.

Usage

RANDOMPLACEDPF;

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> ;  

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> ;

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> ;  

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>]" ;

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 ;