15.00 - SET RESTART - 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

SET RESTART

Purpose  

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

Syntax  

 

Syntax element…

Description

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” on page 958.

    Usage Notes  

    This function does not force an immediate database restart. For additional information, see “Stopping and Restarting the System” in Database Administration.

    Example  

    Enter a command, HELP or QUIT:
     
    SET RESTART = COLDWAIT
     
    The System RestartKind has been set to COLDWAIT.