Usage Notes - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2019-02-14
dita:mapPath
ybx1527114222321.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table describes the things to consider when using the SLEEP command.

Usage Notes for SLEEP 
Topic Usage Notes
Function The SLEEP specification works with the TENACITY specification to control Teradata FastLoad logon attempts.

When Teradata FastLoad tries to log on for a new session, and the Teradata Database indicates that the maximum number of load sessions is already running, the Teradata FastLoad utility:

  1. Logs off any new sessions that were logged on
  2. Waits for 6 minutes, by default, or for the amount of time specified by the SLEEP command

    However, if the amount of time specified by the SLEEP command exceeds that of the TENACITY command, then the sleep interval is reset and equated to the amount of time specified by the TENACITY command.

    For example, if the time specified with the SLEEP command is 65 minutes and the time specified with TENACITY command is 1 hour, then the SLEEP time is reset to 60 minutes so that the SLEEP time does not exceed the TENACITY time.

  3. Tries again to log on to the Teradata Database

Teradata FastLoad repeats this process until it has either logged on for the required number of sessions or equates the amount of time specified by the TENACITY command.

The sleep interval specified in the SLEEP command is dynamically adjusted so that the total sleep times does not exceed the amount of time specified by the TENACITY command.
For example, if the time specified with the SLEEP command is 35 minutes and the time specified with the TENACTY command is 1 hour, then:
  • FastLoad sleeps for 35 minutes and then attempts to log on to the Teradata Database.
  • If the first logon attempt fails, then the SLEEP time is adjusted to 25 minutes so that the total SLEEP time does not exceed the TENACITY time.
Command Placement Command placement affects the logon operation. State the SLEEP and TENACITY commands before the LOGON command in the Teradata FastLoad job script. Teradata FastLoad terminates with an error message if these commands are stated after the LOGON command.
Command Overrides The SLEEP and TENACITY command specifications override the corresponding SLEEP and TENACITY specifications that may be made in the Teradata FastLoad configuration file.

Similarly, the SLEEP and TENACITY command specifications themselves are overridden by the corresponding specifications made as runtime parameters when invoking Teradata FastLoad.

The order of preferences for the SLEEP and TENACITY specifications, from highest to lowest, is:
  1. Runtime parameters
  2. Teradata FastLoad script commands
  3. Teradata FastLoad configuration file specifications
  4. Teradata FastLoad default values