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.