Previous Page | Next Page

Data Set Options for Relational Databases

SLEEP= Data Set Option



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

Syntax
Syntax Description
Details
See Also

Syntax

SLEEP=number-of-minutes

Syntax Description

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

Using the TPT API

MULTILOAD= Data Set Option

Previous Page | Next Page | Top of Page