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.