Task Status Reporting
Teradata MultiLoad has three ways to provide information about the status of jobs
that are still in progress and those that have just completed:
Teradata MultiLoad utility messages provide job status reports, including:
Options messages that list the settings of Teradata MultiLoad task parameters.
Logoff/disconnect messages that list key run statistics.
The QrySessn Utility provides real-time, phase-oriented progress reports at selected intervals during
the Teradata MultiLoad job.
Statistics messages present information at the end of the Teradata MultiLoad job.
The following sections describe each Teradata MultiLoad task status reporting method.
Options Messages
Teradata MultiLoad options messages list the options specifications for each task:
SESSIONS
CHECKPOINT
TENACITY
SLEEP
ERRLIMIT
AMPCHECK
Logoff/Disconnect Messages
Issued in response to the LOGOFF command, the Teradata MultiLoad 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
QrySessn Utility
QrySessn is a separate utility that can be used to monitor the progress of a Teradata
MultiLoad job. QrySessn reports different sets of status information for each phase
of the Teradata MultiLoad job:
Preliminary
Acquisition
Application
QrySessn also reports on:
Action values for processing data
Data counts for the total activity
I/O accesses
Optional data counts and row/sector counts, by session
Phase and CPU time-of-day information
Row count statistics for:
Non-unique secondary indexes (NUSIs)
Primary data
Rows deleted
Rows inserted in target tables
Target table rows processed
QrySessn can be executed from a system console using the Database Window interface
on a system running Teradata Database for a UNIX® operating system or Teradata Database for Windows.
For complete information about using the QrySessn utility, see the Utilities Quick Reference.
Statistics Messages
For each import task, a Teradata MultiLoad statistics message reports the total number
of:
Data records sent to Teradata Database, including a subtotal of the number of records
from each data source
Records skipped from each data source because of false WHERE conditions
Rows inserted, updated, or deleted
Errors recorded in the first error table for each target table
Errors recorded in the second error table for each target table, including the number
of duplicate rows
At the end of an acquisition phase, a Teradata MultiLoad statistics message reports:
Elapsed time, CPU time, MB per second, and MB per cpusec
At the end of an application phase, a Teradata MultiLoad statistics message reports:
Elapsed time
Teradata MultiLoad writes options and logoff/disconnect messages, and the statistics
facility report to either:
The customary output destination for the client system (SYSPRINT/stdout or the redirected stdout).
or
An alternate destination specified in a ROUTE MESSAGES command.
The utility also writes the statistics information in the restart log table so it
can be restored after a system restart operation.