SET RESTART - Teradata Vantage - Database Engine 20

Database Utilities
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantage™

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.