Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 03 Nov 2003 @ 11:10:46 GMT





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 




Subj:   Re: utility locks
 
From:   Dieter Nöth



  You're correct, showlocks inly displays ARC locks.  


  Why is that? No idea.  


  I've never come across a utility that will display existing mload/fastload locks.  



In V2R5 CheckTable has a new level PENDINGOP, which includes information about tables being loaded.

But be carefull:

"Do not use the CHECK command with the PARALLEL option when using the PENDINGOP option and with users logged on. A hang will occur."


Dieter





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008