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.
The following table describes the possible 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
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).