17.10 - SET RESTART - 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)

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

This function does not force an immediate database restart.

Syntax

{ SET | S } { RESTART | R } [=] restartkind

Syntax Elements

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.