Advanced SQL Engine | Utilities | Dump Unload/Load (dul) | Teradata Vantage - 17.10 - Dump Unload/Load Utility (dul) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)
The utility described is not available for as-a-service customers.

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

If an Advanced SQL Engine 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 Advanced SQL Engine.

The dul utility:

  • Transfers dump information from Advanced SQL Engine 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:

CrashDumps.Crash_yyyymmdd_hhmmss_nn
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.