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. 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, 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.