17.10 - RESTART - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
vkz1472241255652

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.