You can use DBSLICEPARM=
in numerous locations. The usual rules of option precedence apply:
A table option has the highest precedence, then a LIBNAME option,
and so on. SAS configuration file option has the lowest precedence
because DBSLICEPARM= in any of the other locations overrides that
configuration setting.
DBSLICEPARM=ALL and
DBSLICEPARM=THREADED_APPS make SAS programs eligible for threaded
Reads. To see whether threaded Reads are actually generated, turn
on SAS tracing and run a program, as shown in this example.
options sastrace=”,,t” sastraceloc=saslog nostsuffix;
proc print data=lib.dbtable(dbsliceparm=(ALL));
where dbcol>1000;
run;
If you want to directly
control the threading behavior, use the DBSLICE= data set option.
- DB2 under UNIX and PC Hosts, Informix, Microsoft SQL Server,
ODBC, Sybase, Sybase IQ
-
The default thread
number depends on whether an application passes in the number of threads
(CPUCOUNT=) and whether the data type of the column that was selected
for purposes of data partitioning is binary.