15.00 - RESTART TPA - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25

RESTART TPA

Purpose  

Restarts or stops Teradata Database after optionally performing a dump.

Syntax  

 

Syntax element …

Specifies …

NODUMP

restart the database without a dump. This is the default.

DUMP

restart the database with a dump.

If DUMP is set to YES, then Teradata Database restarts with a dump.

If DUMP is set to NO, then Teradata Database restarts without a dump.

COLD

restart Teradata database without waiting for transaction recovery. This is the default.

COLDWAIT

finish all database transaction recovery before allowing users to log on.

comment

the reason for the restart.

Usage Notes  

You must type a comment explaining the reason for the restart.

When you restart Teradata Database, all vprocs are reset.

Note: RESTART TPA does not prompt you to confirm the restart.

Example  

In this example, a cold restart is issued with a message stating the reason why.

restart tpa cold Screen dump for book.
 
The reason for the restart is logged as:
Screen dump for book.