Restarting DUL - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
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.