15.00 - Restarting DUL - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Restarting DUL

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, type the following commands.

 

Command

Description

LOGON ZZ/Admin, abc ;

The LOGON command logs user Admin onto the Teradata Database.

HELP DATABASE crashdumps ;

The HELP DATABASE command lists any dump tables that might have been created during a load operation.

DROP crashdumps.crash_20000606_142500_01 ;

The DROP command ensures that any partially created tables are deleted prior to submitting a new load operation.

SELECT ERROR ;

The SELECT command sets the selection criteria that determines the dump data that is loaded into tables on your Teradata Database. In the example above, only processors that contain error codes are selected.

LOAD

The LOAD command can then be used to resubmit the operation.

For example:

LOAD CL200, FALLBACK FILE = FILEPATH;

For a detailed explanation of loading dump files into tables, see “LOAD” on page 513.

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, include the following commands.

 

Command

Description

LOGON ZZ/Admin, abc ;

The LOGON command logs user Admin onto the Teradata Database.

SELECT ERROR ;

The SELECT command 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.

UNLOAD

The UNLOAD command can then be used to resubmit the unload operation.

For example:

UNLOAD crashdumps.crash_20000606_142500_01 FILE=filepath;

For a detailed explanation, see “UNLOAD” on page 532.