SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

turns SPD Server LDAP user authentication on or off. If the LDAP option is found or set
during SPD Server start-up, then the SPD Server host creates a context for LDAP user
authentication.

Usage

LDAP ;

NOLDAP;

enables or suppresses the server-side SPD Server NLS processing. The default value for
NLSTRANSCODE is NONLSTRANSCODE if the option is not found in the
spdsserv.parm file. The default spdsserv.parm file for SPD Server does not contain the
NLSTRANSCODE option. Users must explicitly activate server-side transcoding in SPD
Server 4.5.

Usage

NLSTRANSCODE ;

NONLSTRANSCODE ;

When NONLSTRANSCODE is specified, SPD Server treats all character column data as
8-bit raw bytes internally, regardless of the table's specified character set encoding (CEI).
SPD Server 4.5 (with SAS 9) performs normal server-side processing of tables, ignoring
the CEI of the table. SAS 9.2, however, will read the CEI value of the table and performs
transcoding for any pertinent character data in the rows returned from SPD Server.

When NLSTRANSCODE is specified, SPD Server reads the table's CEI value and the CEI
value of the associated SAS 9.2 session. SPD Server does not perform transcoding if these
values are the same. If the CEI values are different, SPD Server restricts the types of
WHERE clause predicates that are permitted in indexed lookups, and SPD Server ensures
that data is returned to SAS 9.2 using the same encoding that the SAS 9.2 session uses.

controls whether to use dynamic WHERE costing. The default value is
NOWHERECOSTING. When dynamic WHERE costing is not enabled, SPD Server uses
the rules-based heuristic WHINIT.

Usage

WHERECOSTING ;
NOWHERECOSTING ; 

invokes random placement of the initial data partition for all tables in a domain. The random
placement strategy manages large tables efficiently and balances data loads without losing
disk space. RANDOMPLACEDPF is enabled by default. To disable