- Logon/connect messages
- Operational status messages
- Logoff/disconnect messages
Additionally, the Query Session utility (QrySessn) provides real-time, phase-oriented progress reports at selected intervals during the FastExport job.
- The customary output destination for a client system (SYSPRINT/stdout or the redirected stdout)
or
- An alternate destination specified in a ROUTE MESSAGES command
The utility also writes operational status information in the restart log table so it can be restored after a system restart operation.
The following sections describe reporting methods available for monitoring FastExport.
Logon/Connect Messages
- SESSIONS limit
- TENACITY hours
- SLEEP minutes
Operational Status Messages
- Executes
- Completes
The completion message also indicates the total number of data blocks generated by the statement.
- 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
- 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
- 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 the database. QrySessn reports status information for each phase of the FastExport job.
- A system console using the Database Window (DBW) interface on Vantage for UNIX® system, or
- Teradata Manager
For complete information about using the Query Session utility, see Teradata Vantage™ - Database Utilities, B035-1102.