222 SASTRACE= System Option Chapter 11
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 database’s threading support. Some databases handle
threading better than others, so you may want to invoke DBSRVTP= for some databases
and not others. Refer to the documentation for your database 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 only applicable on all Windows platforms, AIX, SLX, and MVS (Oracle
only). On some of these hosts, SAS can be invoked with the -SETJMP system option.
Setting -SETJMP disables the DBSRVTP= option.
Examples
The following examples invoke 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
SASTRACE= System Option
Generates trace information from a DBMS engine
Valid in: Wherever SAS system options are valid: OPTIONS statement, configuration
file, SAS invocation
Default value:
NONE
Syntax
SASTRACE= ’,,,d’
Syntax Description
’,,,d’
gives information about SAS/ACCESS engine calls to a relational DBMS.
SAS/ACCESS Specific Details
SASTRACE is a SAS system option that has behavior specific to SAS/ACCESS
software. SASTRACE is a very powerful tool to use when you want to see the
