Restarts or stops the database after optionally performing a dump.
When you restart the database, all vprocs are reset.
RESTART TPA does not prompt you to confirm the restart.
Syntax
RESTART TPA
[ NODUMP | DUMP = { YES | NO } ]
[ COLD | COLDWAIT ] comment
Syntax Elements
- 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 the database restarts with a dump.
- If DUMP is set to NO, then the database restarts without a dump.
- COLD
- Restart the 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.
Example: Restarting the 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.