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 Teradata 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 Teradata 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 Teradata 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. |