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 Vantage for a UNIX® operating system or Vantage for Windows.
For complete information about using the QrySessn utility, see the Teradata Vantage™ - Database Utilities, B035-1102.
Statistics Messages
For each import task, a Teradata MultiLoad statistics message reports the total number of:
- Data records sent to the 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.