Data Set Options for Relational Databases |
Default value: | 6 |
Valid in: | DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software) |
DBMS support: | Teradata |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
SLEEP=number-of-minutes |
the number of minutes that MultiLoad waits before it retries logging on to Teradata.
Details |
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.
See Also |
For information about specifying how long to continue to retry a logon operation, see the TENACITY= Data Set Option.
Maximizing Teradata Load Performance
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.