Purpose
Restarts or stops Teradata Database after optionally performing a dump.
Syntax
RESTART TPA
[ NODUMP | DUMP = { YES | NO } ]
[ COLD | COLDWAIT ] comment
- 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.
RESTART TPA does not prompt you to confirm the restart.
Example: Restarting Teradata Database
In this example, a cold restart is issued with a message stating the reason why.
restart tpa cold Scheduled maintenance. The reason for the restart is logged as: Scheduled maintenance.