17.10 - 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 RESTART command forces a database restart.

The RESTART command implicitly causes Vproc Manager to exit.

Syntax

{ RESTART | R }
  [TPA]
  [ NODUMP | DUMP { YES | NO } ]
  [ restartkind ]
  [ restart_comment ]

Syntax Elements

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

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

To view the current system setting for RestartKind or Restart Type, see STATUS DBS.

For additional information on stopping and restarting the system, see Teradata Vantage™ - Database Administration, B035-1093.

Example: Performing a COLD restart

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: Restarting with a dump

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: Restarting using current restart settings

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.