Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 30 May 2002 @ 11:28:50 GMT


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


Subj:   Re: Locks on table
 
From:   Glen Blood

Mload leaves a special mload lock on the table. Depending on which phase you left the table in, you can try:

     Release mload on databasename.tablename;     Acquisition Phase
     Release mload on databasename.tablename in apply;  Application phase.
/* You may have to drop all NUSIs.  Only valid in V2R3 and later */

Otherwise, grab the DDL for the table, drop it and recreate it. If you have previous data in the table, you can use an access lock to pull the data out.

Glen



     
  <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: 28 Jun 2020