LOGOFF - FastLoad

Teradata FastLoad Reference
Product
FastLoad
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose  

The LOGOFF command ends Teradata FastLoad sessions and exits from the Teradata Database.

The LOGOFF and QUIT commands may be used interchangeably.

Syntax  

Usage Notes

Table 37 describes the things to consider when using the LOGOFF command.

 

Table 37: LOGOFF Command Usage Notes 

Topic

Usage Notes

Pausing Teradata FastLoad

If the LOGOFF command is entered after a BEGIN LOADING command, but before the END LOADING command, the Teradata FastLoad job pauses and can be restarted later.

Locked Tables

When a Teradata FastLoad job pauses during the loading phase, the Teradata Database locks the tables named in the BEGIN LOADING command. The tables remain locked until an END LOADING command is entered.

Termination Return Codes

When a Teradata FastLoad job terminates, the utility returns a code indicating the way the job completed:

  • Code 0—Normal completion. The job completed successfully and according to the specified plan.
  • Code 4—Warning. A warning condition occurred; for example, a job deviated from normal or from the specified plan, but still completed successfully. A warning may indicate deviation from the plan; for example, the number of sessions specified were not actually used, or a part of the job did not run. Warning conditions do not terminate the job.
  • Code 8—User error. A user error, such as a syntax error in the job script, terminated the job.
  • Code 12—Severe error. A fatal error terminated the job. A fatal error is any error other than a user error.
    		•

    Example  

    The following command example ends Teradata FastLoad and exits the Teradata Database:

    LOGOFF ;
    Completion Message

    The completion message indicates that the Teradata FastLoad job was either paused or terminated, depending on whether the job was in the loading phase or not:

    Table 38 describes the possible LOGOFF command Completion messages.

     

    Table 38: LOGOFF Command Completion Messages 

    Job

    Teradata FastLoad Response Layout

    If the Job is in the loading phase 

    *** 16:09:18 Logging off all sessions
    *** 16:09:21 Total processor time used = '0.374402 Seconds'
        .        Start : Fri Jan 10 16:08:59 2014
        .        End   : Fri Jan 10 16:09:21 2014
        .        Highest return code encountered = '4'.
    *** 16:09:21 FastLoad Paused

    If the Job is not in the loading phase 

    **** 16:11:42 Logging off all sessions
    **** 16:11:45 Total processor time used = '0.358802 Seconds'
         .        Start : Fri Jan 10 16:11:20 2014
         .        End   : Fri Jan 10 16:11:45 2014
         .        Highest return code encountered = '0'.
    **** 16:11:45 FDL4818 FastLoad Terminated

    Note: After FastLoad successfully requests disconnecting all sessions, it displays either “FDL4818 FastLoad Paused” or “FDL4818 FastLoad Terminated,” but all the sessions might not be logged off (disconnected).