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

RESTART

Purpose  

The RESTART command forces a database restart.

Syntax  

 

Syntax element …

Description

TPA

This option has no effect on the RESTART command. It is included for compatibility.

NODUMP

A system dump will not occur. This is the default.

DUMP

Specifies whether a dump will occur:

  • YES means a dump will occur.
  • NO means no dump will occur.
  • 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.

    restart comment

    States the reason for the restart.

    Usage Notes  

    The RESTART command implicitly causes Vproc Manager to exit.

    To set the desired RestartKind or Restart Type, see or “SET RESTART” on page 960 or the RESTART TPA command in Database Window (xdbw).

    To view the current system setting for RestartKind or Restart Type, see “STATUS DBS” on page 967.

    For additional information on stopping and restarting the system, see Database Administration.

    Example  

    The following example shows how to perform a COLD restart and specifies a reason why.

    Enter a command, Help, or Quit:
     
    RESTART COLD This is a test.
     
    The system will be restarted:
        Dump        : NO
        RestartKind : COLD
        Reason      : This is a test.

    Example  

    The following example shows how to restart using the current system setting for RestartKind and specifies a reason why.

    Enter a command, Help, or Quit:
     
    RESTART DUMP = YES This is a test.
     
    The system will be restarted:
        Dump        : YES
        RestartKind : COLD
        Reason      : This is yet another test.

    Example  

    The following example shows how to restart using the current system setting for RestartKind and the default restart comment.

    Enter a command, Help, or Quit:
     
    RESTART
     
    The system will be restarted:
        DUMP        : NO
        RestartKind : COLD
        Reason      : System restarted by VprocManager.