Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 09 Jul 2004 @ 14:42:13 GMT

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

Subj:   Re: How to release locks from a table.
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 09, 2004 10:23 -->

It does sound like a table level lock. If you lock the table for access before you run your sql does it then return? [locking table dbname.tablename for access select x from dbname.tablename]

Could be a lock held by the backup utility. If it is a HUT lock you can find it from the supervisor window with the showlocks utility. cnsterm 6 > start showlocks cnsterm <window>. You can start the lock display utility the same way with start lokdisp from cnsterm 6. If it is a lock from the backup you can release it with release lock. It could also be an mload lock. If it is an mload lock you can only safely release it if mload was in the acquisition phase. release mload dbname.tablename is the command.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023