Data Mover Logging Levels | Teradata Data Mover - Logging Levels - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

You can control the level of logging for a job that you launch through the command-line interface. For the command-line interface, use the -log_level parameter of the create and move commands. Teradata recommends using log level 0 or 1 during normal operation.

Value Command-Line Interface Description Details
0 x Disables logging. This is the default value for the -log_level parameter of the create and move commands.
  • If the job completes successfully, the log is deleted.

    You cannot view utility logs of successfully completed jobs with the status command.

  • If the job fails, the log is not deleted.

    You can view the logs of the failed job with the status command.

  • If a DSA job, this defaults to the DSMAIN error logging level. DSMAIN logs are in the /var/opt/teradata/tdtemp/bar directory on the source and target databases.
1 x Enables detailed logging.
  • You can view the logs of successfully completed or failed jobs with the status command.
  • If a DSA job, this enables the DSMAIN error logging level. DSMAIN logs are in the /var/opt/teradata/tdtemp/bar directory on the source and target databases.
2 x Enables extra logging for command-line interface jobs that use Teradata ARC by setting the VERBOSE option of Teradata ARC.
  • You can view the logs of successfully completed or failed jobs with the status command.
  • If a DSA job, this enables the DSMAIN info logging level. DSMAIN logs are in the /var/opt/teradata/tdtemp/bar directory on the source and target databases.
    • The DSA job definition is logged in the Data Mover agent log as a JSON.
99 x Enables maximum logging.
  • For TPT API, both operator and data stream logs are sent to /var/opt/teradata/datamover/logs/temp/task XXX YYYY directory, where XXXX is the job id and YYYY is the task ID.
  • For ARC jobs, this sets the VERBOSE3 option.
  • For DSA jobs, this enables the DSMAIN DEBUG logging level. DSMAIN logs are under the /var/opt/teradata/tdtemp/bar directory on the source and target databases.
  • For Aster jobs, this sets TRACE_LEVEL-VALUE=7, when calling the AsterSQLMR functions.
  • You can view the logs of successfully completed or failed jobs with the status command.
  • Use log level 99 only under the guidance of a Teradata Technical Support Specialist when a job issue needs extremely detailed debug information.
  • If you enable maximum logging, Data Mover creates temporary directories on the Data Mover agent server that runs the task. These directories are not automatically deleted. When you no longer need them, delete the task_XXXX_YYYY directories in /var/opt/teradata/datamover/logs/temp.
  • If a DSA job, the DSA job definition is logged in the Data Mover agent log as a JSON.