Specifies whether SAS/ACCESS engines hold or block the originating client while making performance-critical calls to the database.
| Valid in: | SAS invocation |
|---|---|
| Category: | Communications: Networking and Encryption |
| Default: | NONE |
| Data source: | DB2 under UNIX and PC Hosts, Informix, Netezza, ODBC, OLE DB, Oracle, SAP ASE, Teradata |
Table of Contents
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 engine name, separate them with blank spaces and enclose the list in parentheses.
| db2 (under UNIX and PC Hosts only) |
| informix |
| netezza |
| odbc (indicates that SAS uses non-blocking operations for SAS/ACCESS ODBC and Microsoft SQL Server interfaces) |
| oledb |
| oracle |
| sapase |
| teradata (not supported on z/OS) |
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. That is, 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 specified 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. When specifying multiple values, enclose the values in quotation marks and parentheses, and separate the values with a space.
This option is applicable on all Windows platforms, AIX, Solaris, and z/OS (Oracle only). On some of these hosts, you can call SAS with the -SETJMP system option. Specifying -SETJMP disables the DBSRVTP= option.
Each of these examples calls SAS from the UNIX command line.
sas -dbsrvtp allsas -dbsrvtp '(oracle db2)'sas -dbsrvtp teradatasas -dbsrvtp '(sapase informix odbc oledb)'sas -dbsrvtp none