#目的
ホストユーティリティロック（HUTロック）の取得状態を確認する。
#コマンド
| 内容 | コマンド | 実行例 |
|---|---|---|
| cnsterm supervisor screenを起動 | cnsterm 6 | |
| Show Locksユーティリティの起動 | start showlocks | |
| 結果確認 | cnsterm 1 | |
| #実行例 | ||
| ###cnsterm supervisor screenを起動 |
TDExpress1620_Sles11:~ # cnsterm 6
Attempting to connect to CNS...Completed.
Hello
Input Supervisor Command:
>
###Show Locksユーティリティの起動
> start showlocks
start showlocks
Started 'showlocks' in window 1
at Sun Sep 27 12:15:29 2020
###showlocksの結果を確認(HUTロックがある場合)
TDExpress1620_Sles11:~ # cnsterm 1
Attempting to connect to CNS...Completed.
Hello
Host Utility locks which currently exist at both
the data base level and the table level.
For each lock which is found, an entry will
appear on your console which includes the following
information:
--Data Base Name
--Table Name (if applicable)
--HashId (if applicable)
--User Name of user who placed lock
--Lock Mode
--AMP Number
--JobId of DSA Job (if applicable)
--PROXY LOCK (if applicable)
SYSDBA.t1
USER DBC MODE Read AMP All Amps
--ShowLocks Processing Complete--
###showlocksの結果を確認(HUTロックがない場合)
「There are currently no host utility locks in the DBC」の表示
TDExpress1620_Sles11:~ # cnsterm 1
Attempting to connect to CNS...Completed.
Hello
This program queries all AMPs and reports all
Host Utility locks which currently exist at both
the data base level and the table level.
For each lock which is found, an entry will
appear on your console which includes the following
information:
--Data Base Name
--Table Name (if applicable)
--HashId (if applicable)
--User Name of user who placed lock
--Lock Mode
--AMP Number
--JobId of DSA Job (if applicable)
--PROXY LOCK (if applicable)
There are currently no host utility locks in the DBC
--ShowLocks Processing Complete--
#参考
Show Locks (showlocks) • Teradata Vantage™ - データベース ユーティリティ • リーダー • Teradataドキュメント