16.10 - Overview - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
June 2017
English (United States)
Last Update

The Dump Unload/Load utility, dul, saves and restores system dump tables.

If a Teradata Database failure occurs, the system automatically saves the contents of the affected AMP and its associated PE in a system-generated “dump table.” The information in these tables can be used to determine the cause of a system failure. Use dul to load the dump tables to disk.

Before you can use dul, the associated packages must be installed on a Teradata Database system.

The dul utility:

  • Transfers dump information from a Teradata Database system to file. This unload operation is normally performed at the customer site, where the crash dump information is transferred to the Teradata Support Center for analysis.
  • Is used by Teradata Support Center personnel to restore the dump information to a Support system for analysis.
  • Can be used to drop tables and obtain summary information about dumps without performing a load or unload operation.

Tables containing crash dump information are named according to the following syntax:

Syntax element … Is the …
yyyymmdd year, month, and day.
hhmmss hour, minute, and second.
nn sequence number, which is increased by one for each dump saved.

Dul can unload dump tables having any name.

Dul automatically saves unloaded dumps to a file with a compressed, gzip file format, and adds a .gz extension to the dump file name. When loading dumps, dul looks for the specified file name including a .gz extension. If that file is not found, dul looks for the specified file name without a .gz extension.