Macro Variables and System Options for Relational Databases |
Default value: | NONE |
Valid in: | SAS invocation |
Syntax | |
Syntax Description | |
Details | |
Examples |
Syntax |
DBSRVTP= 'ALL' | 'NONE' | '(engine-name(s))' |
indicates that SAS does not use any blocking operations for all underlying SAS/ACCESS engines that support this option.
indicates that SAS uses standard blocking operations for all SAS/ACCESS engines.
indicates that SAS does not use any blocking operations for the specified SAS/ACCESS engines. You can specify one or more engine names. If you specify more than one, separate them with blank spaces and enclose the list in parentheses.
db2 (supported under only UNIX and PC Hosts) |
informix |
netezza |
odbc (indicates that SAS uses non-blocking operations for SAS/ACCESS ODBC and Microsoft SQL Server interfaces) |
oledb |
oracle |
sybase |
teradata (not supported on z/OS) |
Details |
This option applies only when SAS is called as a server responding to multiple clients.
You can use this option to help throughput of the SAS server because it supports multiple simultaneous execution streams, if the server uses certain SAS/ACCESS interfaces. Improved throughput occurs 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 client requests. SAS/SHARE software and SAS Integration Technologies are two ways of invoking SAS as a server.
This option is a system invocation option, which means the value is set when SAS is invoked. Because the DBSRVTP= option uses multiple native threads, enabling this option uses the underlying DBMS's threading support. Some databases handle threading better than others, so you might want to invoke DBSRVTP= for some DBMSs and not others. Refer to your documentation for your DBMS for more information.
The option accepts a string where values are the engine name of a SAS/ACCESS product, ALL, or NONE. If multiple values are specified, enclose the values in quotation marks and parentheses, and separate the values with a space.
This option is applicable on all Windows platforms, AIX, SLX, and z/OS (Oracle only). On some of these hosts, you can call SAS with the -SETJMP system option. Setting -SETJMP disables the DBSRVTP= option.
Examples |
These examples call SAS from the UNIX command line:
sas -dbsrvtp all
sas -dbsrvtp '(oracle db2)'
sas -dbsrvtp teradata
sas -dbsrvtp '(sybase informix odbc oledb)'
sas -dbsrvtp none
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.