Macro Variables and System Options for Relational Databases DBSRVTP= System Option 221
Note: The SAS system option REPLACE is not supported by the SAS/ACCESS
interfaces.
DBSRVTP= System Option
Specifies whether SAS/ACCESS engines put a hold (or block) on the originating client while
making performance-critical calls to the database. This option applies when SAS is invoked as a
server responding to multiple clients
Valid in:
SAS invocation
Default value:
NONE
Syntax
DBSRVTP= ’("ALL" | "NONE" |engine-name(s) )’
Syntax Description
ALL
indicates that SAS uses nonblocking operations for all underlying SAS/ACCESS
products that support this option.
NONE
indicates that SAS uses standard blocking operations for all SAS/ACCESS products.
engine-name(s)
indicates that SAS uses nonblocking operations for the specified SAS/ACCESS
interface(s). You can specify one or more of the following engine names. If you specify
more than one name, separate them with blank spaces and enclose the list in
parentheses.
DB2 (only supported on UNIX/PC hosts)
INFORMIX
ODBC (indicates that SAS uses nonblocking operations for the SAS/ACCESS
interfaces to ODBC interface and Microsoft SQL Server).
OLEDB
Oracle
SYBASE
TERADATA (not supported on OS/390)
Details
This option may be used to help throughput of the SAS server by supporting multiple
simultaneous execution streams, if the server utilizes certain SAS/ACCESS interfaces.
Better throughput is accomplished when the underlying SAS/ACCESS engine does not
hold or block the originating client, such that any one client using a SAS/ACCESS
product does not keep the SAS server from responding to other clients’ requests.
SAS/SHARE software and SAS Integration Technologies are two ways of invoking SAS
as a server.
