Specifies how many Teradata sessions to be logged on when using non-TPT FastLoad, FastExport, or Multiload.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Data source: | Teradata |
| See: | FASTEXPORT= LIBNAME option, SESSIONS= data set option, TPT_MAX_SESSIONS= LIBNAME option, TPT_MIN_SESSIONS= LIBNAME option, Using MultiLoad |
Table of Contents
specifies a numeric value that indicates the number of sessions to be logged on.
Starting in SAS 9.4M9, use the TPT_MAX_SESSIONS= and TPT_MIN_SESSIONS= LIBNAME options instead.
When you read data with non-TPT FastExport or load data with non-TPT FastLoad or MultiLoad, you can request multiple sessions to increase throughput. Using large values might not necessarily increase throughput due to the overhead associated with session management. Check whether your site has any recommended value for the number of sessions to use. See your Teradata documentation for details about using multiple sessions.
This example uses SESSIONS= in a LIBNAME statement to request five sessions for loading data with FastLoad.
libname x teradata user=myusr1 pw=mypwd1 SESSIONS=5;
proc datasets library=x;
delete test;run;
data x.test(FASTLOAD=YES);
i=5;
run;