Enables you to change
the server configuration by specifying server options. Following is
the syntax:
Following are the options
for the ALTER SERVER statement:
alter-server-options
Specifies the list
of server options to alter. Shared login manager and password options
are paired.
"{" OPTIONS ["("] alter-server-option [{ "," alter-server-option } ... ] [")"]"}"
alter-server-option
Specifies the server
option to alter.
[alter-operation ]server-option | cache-option
server-option
Specifies the server
configuration. One of the following:
FILEDSNPATH | FILEDSN_ROOT directory-path
File DSN content location
root for FILEDSN and SAVEFILE keywords. This path can be absolute
or relative to the server's root content location specified in
the server configuration file.
PURGE_CACHE time-out-value
Specifies how often
(in minutes) old data cache tables will be removed from the server.
-
A positive time value indicates
the interval at which the cleanup thread will check for cleanup.
-
A negative time-out-value means
cleanup will happen in response to an explicit PURGE CACHE command
only.
-
A value of 0 indicates that old
caches will be removed after a CREATE, REFRESH, or PURGE CACHE command
is issued.
TRACEFILEPATH | TRACEFILE_ROOT directory-path
Specifies the trace
file content location root for TRACEFILE keywords and the TRACEFILE
environment handle attribute. The trace file path is used to store
all trace files that are created, either from SAS Federation Server
start-up, or when enabled on a connection. This path may be absolute
or relative to the server's ContentRoot that is specified in
the server configuration file. The default trace file path is drive:\Program
Files\SASHome\FedServer\server instance\var.
The DRIVER_TRACEFILE=
path that is set in the connection option, DRIVER TRACE, is resolved
against the path that is set here.
SHAREDLOGINMANAGER manager
The Authentication Server
manager account that will be used to retrieve the shared login map
credentials.
SHAREDLOGINPASSWORD password
The Authentication Server
password for the manager account that will be used to retrieve the
shared login map credentials.
Note: Shared login manager and
password options are paired.
SHAREDLOGINKEY key
The Authentication Server
grouping key used to search for shared login map credentials.
TRUSTED_USER_UID userid
The Authentication Server
trusted user account that is used to act on behalf of other users
for purposes of retrieving user-owned logins and group memberships
(trusting that those users have already been authenticated). The SAS Federation Server
makes a trusted user connection to Authentication Server
to process queries on definer's rights views since these views
retrieve SQL data under the identity of the view's schema owner
(the definer) rather than the invoking user.
TRUSTED_USER_PWD password
Specifies the password
for the TRUSTED_USER_UID.
Note: The Shared Login and Trusted
User passwords are encrypted. By default, SASProprietary encryption
is used and the method of encryption can vary depending on the security
platform where SAS Federation Server is installed.
If DataFlux Secure for SAS Federation Server
has been installed, AES encryption can be used.
CONNECTION_POOLING [N[O]|F[ALSE]|OFF|0|Y[ES]|T[RUE]|ON|1]
This option controls
whether connection pooling is enabled or disabled for the server.
If connection pooling is switched on, connections to databases are
not disconnected immediately when the client requests to disconnect
from the database. The connections are put into a pool of connections
that can be reused by subsequent requests to connect to the same database
with the same attributes and credentials
CONNECTION_POOL_TIMEOUT seconds
This option identifies
the time in seconds an unused connection stays in the connection pool.
The default is 60 seconds. If the option is unset or set to 0, the
connection stays in the pool for 60 seconds. If the time is exceeded
the connection is removed from the pool and the connection is closed.
CONNECTION_POOL_MAXSIZE maxsize
This option identifies
the maximum number of unused connections in the connection pool. The
default is 50. If the option is unset or set to 0, a maximum number
of 50 connections are kept in the pool. If the maximum number of connections
is reached and a new connection is added to the connection pool, the
oldest connection is removed from the pool and the connection is closed.
cache-option : :=
Specifies the server
configuration. One of the following:
CACHE ( NAME cache-name, cache-property cache-property
value )
The NAME option specifies
the cache name. Cache properties for that particular cache are altered
or created within the sublist. Normal generic SQL options syntax
and rules apply to the CACHE option and its suboptions.
cache name : :=
Specifies the name
of the Authentication Server cache.
AS - All AS cached resources
AS.Name - All AS.Name mappings
AS.Name.Subjects - User name to AS identifier cache
AS.Name.Groups - Group name to AS identifier cache
AS.Subject - All AS.Subject cache resources
AS.Subject.Groups - User group memberships cache
AS.Subject.Principals - User principal listings cache
AS.List.Subjects - User listings cache
AS.List.Groups - Group listings cache
Authorization - Privileges
ResultSet - Result set caches
ResultSet.View - Materialized view cache (VDC)
TIMEOUT
TIMEOUT is the number
of seconds before the cache data becomes stale after a refresh. After
timing out, the cache is emptied and refreshed on demand or emptied
automatically, depending on the cache implementation. The timeout
can be set for multiple related caches by specifying a non-terminal
cache namespace for the name suboption such as AS.List instead
of AS.List.Groups. A value of -1 corresponds
to infinite and a value of 0 corresponds to immediate. The default
time-out value is 0 for all caches if unset directly or through a
parent namespace.
To control the amount
of memory available to answer SQL requests, and enforce this limit
for all connections, use the CONOPTS option with the FedSQL driver
and set the SQL statement limit as explained below. If the option
is specifically set on a particular DSN, then the DSN value should
override the system setting.
ALTER SERVER {options CONOPTS(driver FEDSQL,
xset DEFAULT_ATTR(SQL_STMT_MEM_LIMIT 8000000))}
CONOPTS
Use this connection
string option to call the FedSQL driver.
Driver FEDSQL
FedSQL is
the required driver for SQL requests on SAS Federation Server.
DEFAULT_ATTR(SQL_STMT_MEM_LIMIT = n)
FedSQL statement
handle option. Used to control the amount of memory available to FedSQL
to answer SQL requests. (n)umber
is treated as an integer and is specified in bytes.
ALTER SERVER {OPTIONS add TRACEFILEPATH "C:\tracefiles"}ALTER SERVER {OPTIONS add TRACEFILEPATH "logs\tracefiles"}ALTER SERVER {OPTIONS xset SHAREDLOGINKEY 'DefaultKey'}ALTER SERVER {OPTIONS( CACHE(NAME AS.Subject, TIMEOUT 300),
CACHE(NAME AS.List.Subjects, TIMEOUT 60) )}ALTER SERVER {OPTIONS(xset PURGE_CACHE 30)}ALTER SERVER {options CONOPTS(driver FEDSQL,
xset DEFAULT_ATTR(SQL_STMT_MEM_LIMIT 8000000))}