17.10 - Restarting 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)

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 example above, 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.