[NO]LDAP
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;
[NO]NLSTRANSCODE
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.
[NO]WHERECOSTING
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 ;
RANDOMPLACEDPF
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
RANDOMPLACEDPF
117
Summary of Contents for Scalable Performance Data Server 4.5
Page 1: ...SAS Scalable Performance Data Server 4 5 Administrator s Guide...
Page 7: ...Part 1 Product Notes Chapter 1 SPD Server 4 5 Product Notes 3 1...
Page 8: ...2...
Page 12: ...6...
Page 63: ...Part 3 Migration Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility 59 57...
Page 64: ...58...
Page 70: ...64 Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility...
Page 72: ...66...
Page 76: ...70 Chapter 6 Using the SPD Server Name Server to Manage Resources...
Page 94: ...88 Chapter 7 Administering and Configuring SPD Server Using the SAS Management Console...
Page 98: ...92 Chapter 8 SPD Server SQL Query Rewrite Facility...
Page 116: ...110 Chapter 10 Configuring Disk Storage for SPD Server...
Page 128: ...122 Chapter 11 Setting Up SPD Server Parameter Files...
Page 154: ...148...
Page 198: ...192 Chapter 14 ACL Security Overview...
Page 212: ...206 Chapter 15 Managing SPD Server Passwords Users and Table ACLs...
Page 214: ...208...
Page 224: ...218 Chapter 16 SPD Server Operator Interface Procedure PROC SPDO...
Page 236: ...230 Chapter 18 SPD Server Table List Utility Spdsls...
Page 256: ...250 Chapter 19 SPD Server Backup and Restore Utilities...
Page 264: ...258 Chapter 20 SPD Server Directory Cleanup Utility...
Page 270: ......