Macro Variables and System Options for Relational Databases

DBSRVTP= System Option

Specifies whether SAS/ACCESS engines holds or blocks the originating client while making performance-critical calls to the database.

Default value:	NONE
Valid in:	SAS invocation

Syntax
Syntax Description
Details
Examples

Syntax

DBSRVTP= 'ALL' | 'NONE' | '(engine-name(s))'

Syntax Description

ALL

indicates that SAS does not use any blocking operations for all underlying SAS/ACCESS engines that support this option.

NONE

indicates that SAS uses standard blocking operations for all SAS/ACCESS engines.

engine-name(s)

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

Top of Page