15.00 - Task Status Reporting - MultiLoad

Teradata MultiLoad Reference

prodname
MultiLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2409-034K

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.