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.