Task Status Reporting - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities
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.