16.10 - SET RESTART - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

The SET RESTART command sets the restart type to use during the next restart of the system.

Syntax



restartkind
Specifies the type of restart to perform:
  • COLD indicates a full restart, including the database (DBS) component, however, transaction recovery will be deferred.
  • COLDWAIT indicates a full restart, however, DBS startup will be deferred until transaction recovery is complete.
If you do not specify a RestartKind, the current system setting is used.
For additional information, see RESTART.

Usage Notes

This function does not force an immediate database restart.

Example: Setting the restart type

Enter a command, HELP or QUIT:

SET RESTART = COLDWAIT

The System RestartKind has been set to COLDWAIT.