目的
TeradataDBの起動と停止方法
コマンド
| 内容 | コマンド | 実行例・補足 |
|---|---|---|
| Teradata停止 | tpareset -x [コメント] | tpareset -x comment |
| Teradata起動 | service tpa start | |
実行例
Teradata停止
TDExpress1620_Sles11:~ # tpareset -x comment
You are about to shutdown the database
on the system
'localhost'
Do you wish to continue (default: n) [y,n] y
状態確認
TDExpress1620_Sles11:~ # pdestate -a
PDE state: DOWN/HARDSTOP
Teradata起動
TDExpress1620_Sles11:~ # service tpa start
Teradata Database Initiator service is starting...
Teradata Database Initiator service started successfully.
状態確認
TDExpress1620_Sles11:~ # pdestate -a
PDE state is RUN/STARTED.
DBS state is 1/4: DBS Startup - Starting PE Partitions
TDExpress1620_Sles11:~ # pdestate -a
PDE state is RUN/STARTED.
DBS state is 5: Logons are enabled - The system is quiescent
参考
TPA Reset(tpareset) • Teradata Vantage™ - データベース ユーティリティ • リーダー • Teradataドキュメント
How To Start and Stop Teradata Database - Database Tutorials