Task Status Reporting - FastExport

Logon/Connect Messages

In addition to input command directives (except for the logon password), FastExport lists the options specifications for each task:

• SESSIONS limit
• TENACITY hours
• SLEEP minutes

Operational Status Messages

During the progress of a FastExport job, the utility displays a message each time a SELECT statement:

• Executes
• Completes

  The completion message also indicates the total number of data blocks generated by the statement.

Also, at five-minute intervals, FastExport reports:

• The total number of records that have been exported to the output file
• The number of blocks processed for each executing minute, displayed as both a running average and a five-minute average

Turn off status messages by setting:

• The runtime parameter -s to OFF
• The FastExport CONFIG FILE entry set to Status=OFF

For a detailed description, see Runtime Parameters and FastExport Configuration File.

Logoff/Disconnect Messages

Issued in response to the LOGOFF command, the FastExport logoff/disconnect message lists:

• The time that the LOGOFF command was executed
• Whether the disconnect operation was successful
• Whether the restart log table was dropped or kept, depending on the success or failure of the job
• The total processor time used
• The job start/end time and date
• The highest return code encountered by the job

Query Session Utility

QrySessn is a separate utility that monitors the progress of a FastExport job on Teradata Database. QrySessn reports status information for each phase of the FastExport job.

Execute the Query Session utility from either:

• A system console using the Database Window (DBW) interface on a Teradata Database for UNIX® system, or
• Teradata Manager

For complete information about using the Query Session utility, see Utilities (B035-1102).