HUTロックの取得状態を確認

目的

ホストユーティリティロック（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ドキュメント