Data Set Options for Relational Databases |
Specifies the number of
minutes that MultiLoad waits before it
retries logging in to Teradata.
Default value: |
6
|
Valid in: |
DATA and PROC steps (when creating and appending
to DBMS tables using SAS/ACCESS software)
|
DBMS support: |
Teradata
|
- number-of-minutes
-
the number of minutes that MultiLoad waits before it retries
logging on to Teradata.
Use the SLEEP= data set option to indicate to MultiLoad
how long to wait before it retries logging on to Teradata when the maximum
number of utilities are already running. (The maximum number of Teradata utilities
that can run concurrently varies from 5 to 15, depending upon the database
server setting.) The default value for SLEEP= is 6 minutes. The value that
you specify for SLEEP must be greater than 0.
Use SLEEP= with the TENACITY= data set option, which specifies the time
in hours that MultiLoad must continue to try the logon operation. SLEEP=
and TENACITY= function very much like the SLEEP and TENACITY run-time options
of the native Teradata MultiLoad utility.
For information about specifying how long to continue to retry a logon
operation, see the
TENACITY= Data Set Option.
Maximizing Teradata Load Performance
Using the TPT API
MULTILOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.