SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 120 / 271

share the memory that is specified using GRPBYROWCACHE to cache groups in memory;
each thread receives 1/MAXWHTHREADS= of the cache.
Once a thread accumulates enough distinct groups to fill its cache, the groups are moved
to secondary bins. At the completion of the parallel GROUP BY, the parallel group
aggregations in memory and secondary bins are merged to produce the final sorted results.
If the GRPBYROWCACHE option is not specified, the default value is a 2 megabyte cache
per thread. Increasing the default value can result in improved aggregation performance
with large numbers of groups. The trade-off is potentially allocating more memory than is
needed for caching, which diminishes the available resources for processing by the excess
amount of assigned memory.
Usage
GRPBYROWCACHE= <memory-cache-size> ;
IDLE_TIMEOUT=
specifies the interval of idle time that is permitted before the SPD Server client process
automatically terminates the client connection. When IDLE_TIMEOUT= is specified as a
value that is greater than 0, the option is enabled. If the value is less than or equal to 0, SPD
Server does not enable idle timeouts. The default value is 0.
Usage
IDLE_TIMEOUT= <timeout_seconds> ;
INDEX_MAXMEMORY=
affects Read operations on SPD Server tables. The specified value restricts the amount of
memory to allocate for each open index.
Usage
INDEX_MAXMEMORY= <maximum-allocated-index-memory> ;
INDEX_SORTSIZE=
controls the amount of memory to allocate for asynchronous (parallel) sort index creation
or appends. The specified value is divided by the number (n) of indexes to be created or
appended in parallel; each receives 1/nth of the memory allocation.
Usage
INDEX_SORTSIZE= <allocated-async-sort-index-memory> ;
LDAPSERVER=
specifies the network IP address or the host machine for the LDAP server. This is usually
the same value as the IP address of the SPD Server host. The default value for
LDAPSERVER= is the IP address of the SPD Server host.
Usage
LDAPSERVER=<ldap_server_host_ip> <LDAP-Server-IP-address-or-LDAP-Server-name>;
114
Chapter 11 • Setting Up SPD Server Parameter Files