Restarting DUL - Teradata Vantage - Database Engine 20

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

Restarting During a Load Operation

If your system fails during a dul load operation, dul must be restarted. You must resubmit the LOAD command.

To restart dul during a load operation, enter the following commands.

Command Description
LOGON ZZ/Admin, abc ; Logs user Admin onto the database.
HELP DATABASE crashdumps ; Lists any dump tables that might have been created during a load operation.
DROP crashdumps.crash_20000606_142500_01 ; Ensures that any partially created tables are deleted prior to submitting a new load operation.
SELECT ERROR ; Sets the selection criteria that determines the dump data that is loaded into tables on your database. In the previous example, only processors that contain error codes are selected. The LOAD command can then be used to resubmit the operation.
LOAD Resubmits the load operation.

For example:

LOAD CL200, FALLBACK FILE = FILEPATH;

For a detailed explanation of loading dump files into tables, see LOAD.

Restarting During an Unload Operation

If your system fails during an unload operation, dul must be restarted. You must resubmit the UNLOAD command.

To restart dul during an unload operation, enter the following commands.

Command Description
LOGON ZZ/Admin, abc ; Logs user Admin onto the database.
SELECT ERROR ; Sets the selection criteria that determines the dump data that is unloaded onto your host system. In the previous example, only processors that contain error codes are selected. The UNLOAD command can then be used to resubmit the unload operation.
UNLOAD Resubmits the unload operation.

For example:

UNLOAD crashdumps.crash_20000606_142500_01 FILE=filepath;

For a detailed explanation, see UNLOAD.