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