You can use DBSLICEPARM=
in numerous locations. The usual rules of option precedence apply:
A table option has the highest precedence, followed by a LIBNAME
option, and so on. A 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 determine whether threaded Reads are actually generated,
turn on SAS tracing and run a program, as shown in this example.
options sastrace=”,,,d” 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, HP Neoview, 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.