16.10 - RESTART - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

The RESTART command forces a database restart.

Syntax



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

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.